8i Listener Problem

From: John McNamee <myvoice_at_zipworld.com.au>
Date: Thu, 24 Aug 2000 09:22:49 +1000
Message-ID: <39a45e3f.14497@nancy.pacific.net.au>

 Hi

 I'm having problems with our Linux 8i server.

 Software has been installed ok and I can get client connections with a  freshly started listener (LSNRCTL start) using the DBA studio client.

 Once I disconnect and then attempt to reconnect I get a "Target not found"  error. But, if I restart the listener on the server then try to connect  again all is fine.telnet is ok the port is open and ready.  I have some more information below that I think is causing my problem

 When I start the listener I get

 TNSLSNR for Linux: Version 8.1.6.0.0 - Production  System parameter file is
 /u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora  Log messages written to
 /u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log  Listening on:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=holly.mv)(PORT=1521)))  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

 Connecting to
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=holly.mv)(PORT=1521)))  STATUS of the LISTENER

---

 Alias                     LISTENER
 Version                   TNSLSNR for Linux: Version 8.1.6.0.0 - Production
 Start Date                23-AUG-2000 09:23:48
 Uptime                    0 days 0 hr. 0 min. 0 sec
 Trace Level               off
 Security                  OFF
 SNMP                      ON

 Listener Parameter File
 /u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora  Listener Log File
 /u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log  Services Summary...
   PLSExtProc has 1 service handler(s)
   ora8 has 1 service handler(s)
 The command completed successfully

 ***EOF  For around 50 -65 seconds after this I can connect and reconnect etc  After this time if I do a lsnrctl status I get ( Note the 3 extra handlers
 on ora8 )

 LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 23-AUG-2000 09:24:39

 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

 Connecting to
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=holly.mv)(PORT=1521)))  STATUS of the LISTENER

---

 Alias                     LISTENER
 Version                   TNSLSNR for Linux: Version 8.1.6.0.0 - Production
 Start Date                23-AUG-2000 09:23:48
 Uptime                    0 days 0 hr. 0 min. 51 sec
 Trace Level               off
 Security                  OFF
 SNMP                      ON

 Listener Parameter File
 /u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora  Listener Log File
 /u01/ora8/app/oracle/8i_8.1.6/network/log/listener.log  Services Summary...
   PLSExtProc has 1 service handler(s)
   ora8 has 1 service handler(s)
   ora8 has 3 service handler(s) <======== ???????  The command completed successfully

 ***EOF  Once these extra handlers appear, I can no longer connect to the server.  Here is my listener.ora file

 # LISTENER.ORA Configuration
 File:/u01/ora8/app/oracle/8i_8.1.6/network/admin/listener.ora  # Generated by Oracle configuration tools.

 LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = TCP)(HOST = holly.mv)(PORT = 1521))
       )


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
       )
     )

   )

 SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = /u01/ora8/app/oracle/8i_8.1.6)

       (PROGRAM = extproc)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = ora8)

       (ORACLE_HOME = /u01/ora8/app/oracle/8i_8.1.6)

       (SID_NAME = ora8)

  )
   )

 ***EOF  Any ideas on if this is related to my problem

 Regards
 John Received on Wed Aug 23 2000 - 18:22:49 CDT