Re: Listener problem

Emmanuel wrote:
> Hello all,
>
> I have a slight listener problem.
>
> I have a Windows Xp (sorry) running oracle 8.1.7.4.1 and oracle
> 10.2.0.1.0. I have databases of each oracle version, and I'm using the
> 10g listener. Unfortunately I cannot connect to the 8i database, I
> always get the following errors in the listener.log file :
> TNS-12518: TNS : TNS:listener could not hand off client connection
> TNS-12560: TNS:protocol adapter error
>
> I have a basic listener configuration :
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Clt-dev-SD)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = ORA81)
> (ORACLE_HOME = C:\oracle\ora81)
> (SID_NAME = ORA81)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = ORA10G)
> (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
> (SID_NAME = ORA10G)
> )
> )
>
> and a basic sqlnet.ora file too :
> SQLNET.AUTHENTICATION_SERVICES = (NTS)
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
>
> Such a configuration should work, I have it working on a Windows 2000...
> I traced the listener, and I noticed that :
> [04-AOÛT -2006 15:18:49:868] snlpcss: Unable to spawn Oracle oracle
> (LOCAL=NO) ORA81, error 2.
>
> What does that mean ? I have traced the listener on the Windows 2000,
> and it seems that the listener is able to spawn the server process that
> will handle the connection.
>
> Do you have any clue ?
>
> Thanks in advance,
>
> Emmanuel PIC

The 10g listener cannot 'talk' to the 8.1.7 database/SQL*Net version; this is clearly documented.

You'll need to run both the 10g listener and the 8i listener to access both releases of Oracle. You'll need to use different ports, I believe, since you'll be running two different listeners on the same machine.

David Fitzjarrell Received on Fri Aug 04 2006 - 09:30:16 CDT