ORA-12560: error

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: ORA-12560: error by Fletch (Bishop) on Jul 25, 2005 at 13:52 UTC
`$ 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	[reply] [d/l]
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]
Re: ORA-12560: error by wazoox (Prior) on Jul 25, 2005 at 14:02 UTC
You should post the line of code that generate that error, too.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.