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

[NotNeo]

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?

[TurkBear]

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



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" <chas_newport@b igfoot.comwrote :

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

[NotNeo]

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

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_LI ST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NEO)(PORT = 1521))
)
)

SID_LIST_LISTEN ER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = escapism.invoko n)
(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?