Re: 8i Listener Problem

Your listener runs fine.

Let us know the following and we might be able to help you:

1. What is in your "tnsname.ora" file?
2. What is the exact command you issued when you say it failed? What is the oracle error message you get?

In article <39a45e3f.14497_at_nancy.pacific.net.au>,   "John McNamee" <myvoice_at_zipworld.com.au> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 14:34:45 CDT