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

Might it be that XP wasn't even a gleam in Bill's eye when Oracle 8.1.7 was written? Thus, 8.1.7 was never, ever, certified for XP? If this is all just on your desktop and no remote connections are needed, maybe you should use a bequeath connection and bypass the listener? Again, with 8.x on XP, nothing is promised but it might be worth a try. Received on Fri Aug 04 2006 - 09:35:57 CDT