Listener problem

From: Emmanuel <mars_at_tacks.com>
Date: Fri, 04 Aug 2006 16:09:22 +0200
Message-ID: <eavkep$8ra$1@s1.news.oleane.net>

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 Received on Fri Aug 04 2006 - 09:09:22 CDT