Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> TNS-12538: TNS:no such protocol adapter
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)
)