Re: TNS-12538: TNS:no such protocol adapter

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.8BA0CF03_at_ac.com>,
  Brownson Lee <brownson.c.lee_at_ac.com> wrote:
>
> 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)
> )
> )
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 04 1998 - 16:06:01 CDT