468,785 Members | 1,536 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,785 developers. It's quick & easy.

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

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
2 46439


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
> 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.

Similar topics

reply views Thread by dance | last post: by
6 posts views Thread by Ellen K. | last post: by
2 posts views Thread by Dave Bailey | last post: by
7 posts views Thread by Christian Wilhelm | last post: by
1 post views Thread by rajendra deshmukh | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.