Home » RDBMS Server » Networking and Gateways » TNS-12538: TNS:no such protocol adapter
TNS-12538: TNS:no such protocol adapter [message #143383] Thu, 20 October 2005 04:26 Go to next message
devarajraja
Messages: 2
Registered: October 2005
Junior Member
Hi,

I am using SQL*Plus 8.0.6 on Win XP to connect to Oracle server 9.2.0 on HP-UX. I get the following error message
ORA-12203: TNS:unable to connect to destination. I tried tnsping80 which reported the follwoing error
TNS:12538:TNS: no such protocol adapter. I reinstalled sqlplus and installing again, I reinstalled the protocol adapter. But still the error persist.
I checked for duplicate TNSNAMES.ora but only one exists.
Can anyone help me in this regard.

Thanks and Regards,
Devaraj.
Re: TNS-12538: TNS:no such protocol adapter [message #143422 is a reply to message #143383] Thu, 20 October 2005 07:31 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

$ oerr tns 12203
12203, 00000, "TNS:unable to connect to destination"
// *Cause: Invalid TNS address supplied or destination is not listening.
// This error can also occur because of underlying network transport
// problems.
// *Action: Verify that the service name you entered on the command line
// was correct. Ensure that the listener is running at the remote node and
// that the ADDRESS parameters specified in TNSNAMES.ORA are correct.
// Finally, check that all Interchanges needed to make the connection are
// up and running.


$ oerr tns 12538
12538, 00000, "TNS:no such protocol adapter"
// *Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)"
// keyword-value pair in a TNS address) is unknown. If the supplied address
// is typographically correct then the protocol adaptor is not installed.
// *Action: Install the protocol adapter or correct typographically error,
// as appropriate.  Note: if the supplied address was derived from
// resolving the service name, check the address in the appropriate file
// (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).


Best regards.

Frank
Re: TNS-12538: TNS:no such protocol adapter [message #143430 is a reply to message #143422] Thu, 20 October 2005 07:38 Go to previous messageGo to next message
devarajraja
Messages: 2
Registered: October 2005
Junior Member
Hi Frank,
Thanks for your inputs.
I am able to connect to the server from a different client machine. Whcih means that listener and database is running.
I hace checked for typo errors but found none.
How should I proceed?
Regards,
Devaraj
Re: TNS-12538: TNS:no such protocol adapter [message #143433 is a reply to message #143430] Thu, 20 October 2005 07:46 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Copy the TNSNAMES.ORA and SQLNET.ORA files from the PC that's working. If, after that, it's still not working, reinstall the entire PC.

Best regards.

Frank
Previous Topic: ORA-02019: connection description for remote database not found
Next Topic: Create referential Integrity constraints from LDAP to Oracle
Goto Forum:
  


Current Time: Mon Nov 25 17:05:30 CST 2024