473,325 Members | 2,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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 46932


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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Park Yeon Jo | last post by:
About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I installed Oracle 8.1.7 on Windows XP Professional. and I wanto connect to that server...
0
by: dance | last post by:
My Apologies for my ineptitude on posting, this is all new to me...........but I'll get it.... I'm using Windows 2000 Version 5.0 with Service pack 4 I installed the free version of Oracle...
6
by: Ellen K. | last post by:
Hi all, I'm a developer. While at my current job I've been working with mostly SQL Server, now I need to connect to our Oracle Financials running on HP-UX. The Oracle DBA set me up as a user...
2
by: Artur | last post by:
Hi Newsgroup, im currently working on programming a asp.net application consuming an Webservice hosted on Apache/Axis. I have generated WSDL and Proxy classes from VisualStudio.net. But when...
2
by: Dave Bailey | last post by:
I am connecting to an Oracle database using ADO on a Webpage. When I run the program i get the following error when it gets to the oleDbConnection.Open command: ORA-12541: TNS:no listener ...
7
by: Christian Wilhelm | last post by:
Hi! I'm trying to call a Java WebService out of a .net Client. There are two Methods, one Method requires one Parameter of type Parameter, the other Method requires one Parameter of type...
2
by: smanicom | last post by:
Hi all I need help urgently as I am in the middle of a migration and can't resolve a TNS error. My db has been fine for months! Today I connected as sysdba and shut down the db. Now I am trying...
1
by: aradea | last post by:
dearest experts or whomever that can help this error is making me crazy .i cannot connect my database at TOAD and manually scott then password tiger, and host string=orcl --> will resulted error....
1
by: abhu50 | last post by:
hiiiiiiiiii i was using my sql*plus in new user a/c that was member of users group on my pc now after some time i logged on admin a/c and change the login password my sql* plus using this alter user...
1
by: rajendra deshmukh | last post by:
I am getting tns error while working in oracle pl guide
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.