topic Re: Db problem in Operating System - HP-UX

Db problem

alan_131 — Fri, 13 Aug 2004 01:43:41 GMT

I have 1 listener called by my applications when i'm trying to connect via SQl/NAV.
I want to add another listener w/o affecting the other listener that i have created.
How will I add a new listener?

thanks

regards

Re: Db problem

Ravi_8 — Fri, 13 Aug 2004 02:58:28 GMT

Hi

Listeners will already be there (oracle will tuned to this). just make sure listerner are up and running
$lsnrctl
lsnrctl> status

will show the listener status.

Re: Db problem

Eric Antunes — Fri, 13 Aug 2004 03:30:48 GMT

You want another listener to listen to the same instance or is it another instance??

If you want to create another listener for another instance, go to $ORACLE_HOME/network/admin, open the tnsnames.ora and listener.ora and add what's necessary.

Re: Db problem

Michael Campbell — Fri, 13 Aug 2004 03:31:09 GMT

Hi

If you like you can add another listener into your $ORACLE_HOME/network/admin/listener.ora. This can then be started and stopped independently. e.g. lsnrctl start

Hope This Helps

Michael

Re: Db problem

alan_131 — Fri, 13 Aug 2004 04:14:23 GMT

I want to add a new listener for new instance.
I 've already add the new instance in the listener.ora and configdured evrything in the tnsnames.ora. When i tried starting the default listener by the command - lsnrctl start, listener started properly, but when i tried to start the new listener for the new instance, it states that " Listener using listener name LISTENER has already been started"

how can i start 2 different listener in one server. By the way i'have added the new listener value in the listener.ora file.

Re: Db problem

Eric Antunes — Fri, 13 Aug 2004 04:23:21 GMT

Alan,

In tnsnames.ora:

= (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1531))
(CONNECT_DATA=(SID=))
)

= (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1531))
(CONNECT_DATA=(SID=))
)

In listener.ora:

=
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= ))
(ADDRESS= (PROTOCOL= TCP)(Host= hp440)(Port= 1531))
)

SID_LIST_ =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= hp440)
(ORACLE_HOME= /.../product/805) -- My RDBMS is 8.0.5
(SID_NAME = )
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /.../product/805)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME= /disc2/app/oracle/product/805)
(SID_NAME = )
)
)

STARTUP_WAIT_TIME_ = 0
CONNECT_TIMEOUT_ = 10
TRACE_LEVEL_ = OFF

LOG_DIRECTORY_ = /.../product/805/network/admin
LOG_FILE_ =
TRACE_DIRECTORY_ = /.../product/805/network/admin
TRACE_FILE_ =

Hope this'll help!

Re: Db problem

Michael Campbell — Fri, 13 Aug 2004 04:39:27 GMT

Alan

When you added the new listener value, did you put it as a separate listener or as another SID in the default listener section. See the following listener.ora example for adding a new listener call newdb:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = db01))
(ADDRESS = (PROTOCOL = IPC)(KEY = db02))
(ADDRESS = (PROTOCOL = IPC)(KEY = db03))
(ADDRESS = (PROTOCOL = IPC)(KEY = db04))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST = ????)(PORT = 1222))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = ????)
(ORACLE_HOME = /oracle/product/8.1.7)
)
)

NEWDB =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=ipc)
(KEY=????) )
(ADDRESS=
(HOST = ????)
(PROTOCOL = TCP)
(PORT = 1234)
)
)

The new listener can then be started separately using lsnrctl start newdb
N.B. Ensure that your new listener is using a different port number.

Hope This Helps

Michael

Re: Db problem

Michael Campbell — Fri, 13 Aug 2004 05:22:35 GMT

Alan

Let us know how you get on with this.

Regards

Michael