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

Hi newdbuser, thanks for writing this:
>
> 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
> > 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
>

If that workaround works and you don't like appending .WORLD to everything, then you need to look in your SQLNET.ORA file for a line that sets WORLD as your default domain (I haven't seen that since Oracle7).

-- 
[:%s/Karsten Farrell/Oracle DBA/g]