TNS-12538: TNS:no such protocol adapter [message #143383] |
Thu, 20 October 2005 04:26 |
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 |
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
|
|
|
|
|