8i Listener Problem
Date: Thu, 24 Aug 2000 09:22:49 +1000
Message-ID: <39a45e3f.14497_at_nancy.pacific.net.au>
Hi
[Quoted] I'm having problems with our Linux 8i server.
Software has been installed ok and I can get client connections with a [Quoted] freshly started listener (LSNRCTL start) using the DBA studio client.
Once I disconnect and then attempt to reconnect I get a "Target not found" [Quoted] error. But, if I restart the listener on the server then try to connect [Quoted] 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
[Quoted] 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
[Quoted] (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)
[Quoted] ora8 has 3 service handler(s) <======== ??????? The command completed successfully
***EOF Once these extra handlers appear, I can no longer connect to the server. [Quoted] 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 Thu Aug 24 2000 - 01:22:49 CEST