Re: TNS-12560:Protocol adapter error from client side only...
Date: Thu, 17 Jul 2003 17:54:54 GMT
Message-ID: <ffd1fd6361de5afbbcb09c930ebf6e18_at_free.teranews.com>
> 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?
Received on Thu Jul 17 2003 - 19:54:54 CEST