Re: Listener problem ....

[Arup Nanda]

Joshua,   This is not a problem. From Oracle 8i onwards, the instance running can register itself with the listener running on the local host without any listener.ora file. Or, if the listener.ora is defined and the listener runs on the default port, 1521.   In this case you have one handler for the one defined in listener.ora file (under SID_LIST parameter) an another for the one that has been registered automatically.   HTH.   Arup Nanda ----- Original Message ----- From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Monday, January 20, 2003 11:59 PM Subject: Listener problem .... Hi all,   I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521))) Services Summary... Service "TEST2" has 2 instance(s).   Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0          LOCAL SERVER   Instance "TEST2", status READY, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:1 refused:0 state:ready          LOCAL SERVER Service "TEST1" has 2 instance(s).   Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0          LOCAL SERVER   Instance "TEST1",! status READY, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0 state:ready          LOCAL SERVER Service "TEST3" has 2 instance(s).   Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0          LOCAL SERVER   Instance "TEST3", status READY, has 1 handler(s) for this service...     Handler(s):       "DEDICATED" established:0 refused:0 state:ready          LOCAL SERVER Why it shows service XXXX has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!