Re: ORA-12560: error

$ oerr ora 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Be
+fore
// reporting this error, look at the error stack and check for lower l
+evel
// transport errors. For further details, turn on tracing and reexecut
+e the
// operation. Turn off tracing when the operation is complete.
[download]

Sounds like you need to talk to your DBA and verify the DSN you're using and that Oracle's configured with the right hostnames (and that the hostname you're trying to connect to is reachable).

--
We're looking for people in ATL

Comment on Re: ORA-12560: error Download Code

Replies are listed 'Best First'.
Re^2: ORA-12560: error by jhourcle (Prior) on Jul 25, 2005 at 15:02 UTC
If I recall correctly (and I very well may not), this is the annoying error that you get under 8i (and possibly other versions), when trying to connect to a remote database that you've defined under 'ORACLE_SID'. It won't work... you have to place the SID in 'TWO_TASK'. For the original poster -- If you can't get a response from tnsping, then track down your DBA... this is just the type of thing that they hate dealing with, but the reason why they can justify getting a big paycheck. (there are a whole lot of things that can cause this error)	[reply]

Replies are listed 'Best First'.

Re^2: ORA-12560: error
by jhourcle (Prior) on Jul 25, 2005 at 15:02 UTC

If I recall correctly (and I very well may not), this is the annoying error that you get under 8i (and possibly other versions), when trying to connect to a remote database that you've defined under 'ORACLE_SID'. It won't work... you have to place the SID in 'TWO_TASK'.

For the original poster -- If you can't get a response from tnsping, then track down your DBA... this is just the type of thing that they hate dealing with, but the reason why they can justify getting a big paycheck. (there are a whole lot of things that can cause this error)

[reply]