Re: ORA 12560: TNS: Protocol Adapter Error

Karsten Wutzke wrote:
>
> Hi all!
>
> I have posted a message just a few hours ago, but the problem seems to
> be harder to solve than expected. I have searched the net already, but I
> couldn't find any useful answers, whereas I found MANY questions
> regarding the same issue.
>
> I have installed Oracle8i Personal on my machine (Windows 2k Pro). The
> DB is to be used locally only, at least for now. When I try to log on
> with "sys"/"manager"/"" (without the "" of course), the error message
> "ORA 12560: TNS: Protocol Adapter Error" appears. Does anyone know
> what's going on?
>
> Thanks for helping a COMPLETE DB NEWBIE...
>
> Karsten
>
> PS: Sorry for the X-post, but it's really important to me!

Hi Karsten,

As the oracle user I type in "oerr ora 12560" and I get the following:

12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred. // *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors.For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.

So what you probably want to do is check your tnsnames.ora and listener.ora files...especially tnsnames.ora. You will probably want to run
Programs->Oracle-OraHome81->Network Administration->Net8 Assistant and establish/check your net connections to the DB.

Good luck,
-Dirk Received on Tue Aug 07 2001 - 14:42:05 CDT