Re: TNS-12560:Protocol adapter error from client side only...

Originally posted by Notneo
> > Can you tnsping from the client.?
> No, that's the problem.
> > Is your Oracle_Home correctly set on the client and is your
> tnsnames.ora
> file in the /network/admin
> > directory under that home?
> Yes and Yes
> > What client version, server version of Oracle..
> Oracle9i both sides.
> > Is it XP Home or XP Pro..
> XP Pro
> > By consistent, do you mean the same?
> The same.
> > Please post, if you can, the tnsnames.ora file from the client
> and the [Quoted]
> listener.ora form the server...
>
>
> TNSNAMES
>
> ESCINST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = NEO)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SID = escinst)
> )
> )
>
> LISTENER
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = NEO)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/9.2.0)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = escapism.invokon)
> (ORACLE_HOME = /opt/oracle/product/9.2.0)
> (SID_NAME = escapism)
> )
> )
>
> > ( Just a note: cross-posting is highly discouraged..)
> I'm a newbie - what exactly constitutes cross-posting?
>

Change the TNSNAMES.ORA file on the client change
ESCINST =
to
ESCINST.WORLD = You then connect to ESCINST.WORLD

I had a similar problem and this worked.

--
Posted via http://dbforums.com