TNS-12538: TNS:no such protocol adapter

Brownson Lee

unread,

Sep 4, 1998, 3:00:00 AM9/4/98

to

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

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)
)
)

Sandro Décio

unread,

Sep 4, 1998, 3:00:00 AM9/4/98

to

Check your TCP install trying this command :
ping <IP address>

If you don't have error messages, verify the adapters that you have
linked in your oracle installation executing :
$ORACLE_HOME/bin/adapters

If you don't have de Oracle TCP/IP Protocol Adpater, re-install it or
relink your software by the command:
$ cd $ORACLE_HOME/rdbms/install/
$ make -f oracle.mk install
(or somethink like that)

Finally, you can get more help on support.oracle.com if you have a CSI
number.

good luck.

vcard.vcf

sa...@my-dejanews.com

unread,

Sep 4, 1998, 3:00:00 AM9/4/98

to

Try
Hi,
It looks like your Listener.ora file is not configuired properly.
try tnsping ora_ins.world
if not, change the listener.ora to include:

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

In article <35EF5382...@ac.com>,

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum