-
On my NT workstation I have an Oracle 8.1.7 enterprize running and I can start 2 listeners on this PC that listen on different ports.
However when I try the similar thing on other instances running on Sun Solaris it does not work the same way -
Here is the copy of the listener.ora on Sun--
===============
USE_PLUG_AND_PLAY_LISTENER = ON
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 2481))
)
)
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 1526))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost)(PORT = 2481))
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ora/u01/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mydb1.test.com)
(ORACLE_HOME = /ora/u01/oracle/product/8.1.7)
(SID_NAME = mydb1)
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ora/u01/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mydb2.test.com)
(ORACLE_HOME = /ora/u01/oracle/product/8.1.7)
(SID_NAME = mydb2)
)
)
===============
I start "lsnrctl" and --
lsnrctl> start LISTENER1
this starts the listener for listener1 and listens on port 1521
now if I do
lsnrctl> start LISTENER2
it says that the listener already started. It however is not listeing on the port 1526
If I stop the listener and reverse the order of the above operation, it listens for listener2 (port 1526) but does not listen for listener1 ( port 1521)
Seems like it's allowing only one lister to start (the first one to start)
Does anyone have any ideas ?
We need 2 listeners in order to separate it for the 2 instances running on that server so that each DBA has freedom to stop/start his own listener.
Thanks,
- Rajeev
Rajeev Suri
-
did you try "lsnrctl start listener1" , "lsnrctl start listener2"?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|