TNS-12538: TNS:no such protocol adapter

From: Brownson Lee <brownson.c.lee_at_ac.com>
Date: Fri, 04 Sep 1998 10:42:11 +0800
Message-ID: <35EF5382.8BA0CF03@ac.com>

Hi,

I encountered a problem when I installed Oracle 7.2 on Solaris. Everything works fine except when I tried to tnsping the Oracle instance I just set up. The following error message was displayed:

e3000:/home/oracle> tnsping ora_ins
TNS Ping Utility for SVR4: Version 2.2.2.0.0 - Production on 04-SEP-98 10:29:30

Copyright (c) Oracle Corporation 1995. All rights reserved.

Attempting to contact
(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=10.202.32.31)(Port=1521))

TNS-12538: TNS:no such protocol adapter

I am sure I've installed the TCP protocol adapter. The weird thing is I can tnsping from another Win95 machine, but failed from the Solaris machine where I installed the Oracle server. Here is the listener.ora and tnsnames.ora file I set up on the UNIX box. Thanks.

Brownson

listener.ora:
LISTENER =
 (ADDRESS_LIST =
   (ADDRESS =
(PROTOCOL=IPC)
(KEY=ORA_INS)

   )
   (ADDRESS =
(COMMUNITY=tcp.world)
(PROTOCOL=TCP)
(Host=127.0.0.1)
(Port=1521)

   )
 )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
   (SID_LIST =
(SID_DESC =

         (SID_NAME = ORA_INS)
         (ORACLE_HOME=/home/oracle)
      )

   )

tnsnames.ora:
Tcp-loopback.world =

   (DESCRIPTION =
(ADDRESS_LIST =

         (ADDRESS =
            (COMMUNITY = tcp.world)
            (PROTOCOL = TCP)
            (HOST = 127.0.0.1)
            (PORT = 1521)
         )
      )


      (CONNECT_DATA = (SID = ORA_INS)


      )

    )

ORA_INS.world =

   (DESCRIPTION =
(ADDRESS_LIST =

         (ADDRESS =
     (COMMUNITY = tcp.world)
            (PROTOCOL=TCP)
            (Host = 10.202.32.31)
            (Port = 1521)
         )
      )


      (CONNECT_DATA = (SID = ORA_INS)


      )

   ) Received on Thu Sep 03 1998 - 21:42:11 CDT