By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

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

P: n/a
I am getting a strange symptom: tnsping and sqlplus work fine on my LINUX
server (neo) so the listener and DB are OK. However, from my remote XP
Client (tank) I get TNS-12560. I can ping the neo from tanks and tank from
neo so it isn't a network problem. The trace file shows that in can't start
the transport layer due to an error 530:

Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 54
nt OS err code: 0

Looking in the listener.log file on the server I can see entries for the two
successful actions on neo. However, the remote attempts from tank don't
even seem to hit the listener port on 1521. TNSNAMES.ORA entries are
consistent on both sides LISTENER.ORA seems correct and I only have a single
Oracle home.

I have changed the Client side hosts file to include named mappings for both
the involved machines with the correct IPs.

I have even used the adapters command to check the linked protocols and they
are present in the listener and oracle executables - both have TCP/IP
linked.

Getting desperate here now... has anyone seen and solved this problem?
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


Can you tnsping from the client.?
Is your Oracle_Home correctly set on the client and is your tnsnames.ora file in the /network/admin directory under that
home?
What client version, server version of Oracle..
Is it XP Home or XP Pro..

By consistent, do you mean the same? Please post, if you can, the tnsnames.ora file from the client and the listener.ora form
the server...
( Just a note: cross-posting is highly discouraged..)
"NotNeo" <ch**********@bigfoot.com> wrote:
I am getting a strange symptom: tnsping and sqlplus work fine on my LINUX
server (neo) so the listener and DB are OK. However, from my remote XP
Client (tank) I get TNS-12560. I can ping the neo from tanks and tank from
neo so it isn't a network problem. The trace file shows that in can't start
the transport layer due to an error 530:

Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 54
nt OS err code: 0

Looking in the listener.log file on the server I can see entries for the two
successful actions on neo. However, the remote attempts from tank don't
even seem to hit the listener port on 1521. TNSNAMES.ORA entries are
consistent on both sides LISTENER.ORA seems correct and I only have a single
Oracle home.

I have changed the Client side hosts file to include named mappings for both
the involved machines with the correct IPs.

I have even used the adapters command to check the linked protocols and they
are present in the listener and oracle executables - both have TCP/IP
linked.

Getting desperate here now... has anyone seen and solved this problem?


Jul 19 '05 #2

P: n/a
> 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?
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.