ORA-12560: TNS:protocol adapter error
February 03, 2010 19:26:35 Last update: February 04, 2010 16:53:04
This seemed to happen when Oracle does not know which instance to connect to. Instead of telling you that you didn't give enough information, Oracle decides that you are better informed by telling you that it's a "protocol adapter error".
In the following I didn't give the SID, nor did I set LOCAL:
It does seem to give the right information on Linux:
Strange enough, when I change the connection string to connect to my echo server instead of the Oracle listener, I got "packet checksum failure":
In the following I didn't give the SID, nor did I set LOCAL:
C:\>sqlplus scott/tiger SQL*Plus: Release 10.1.0.5.0 - Production on Wed Feb 3 11:52:43 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
It does seem to give the right information on Linux:
$ sqlplus scott/tiger SQL*Plus: Release 10.1.0.5.0 - Production on Thu Feb 4 10:51:10 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12162: TNS:net service name is incorrectly specified Enter user-name:
Strange enough, when I change the connection string to connect to my echo server instead of the Oracle listener, I got "packet checksum failure":
C:\tmp>sqlplus scott/tiger@xe SQL*Plus: Release 10.1.0.5.0 - Production on Thu Feb 4 10:46:00 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12569: TNS:packet checksum failure
Easy email testing with http://www.ximailstop.com
