DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to start 2 listeners on Sun Solaris

  1. #1
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    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

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    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
  •  


Click Here to Expand Forum to Full Width