Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error message
On Mon, 12 Aug 2002 17:09:39 GMT, "Shon" <vze43w86_at_verizon.net> wrote:
>Hi,
>
>I'm getting this error massage (ORA-12560: TNS: protocol adapter error) and
>unable to connect to database.
>
>How I can resolve this ?
>
>
>
>Thanks
>
>Shon
>
>
Please always post platform and version, if that's not asked too much.
On NT the error happens in two situations:
1 You are on the server and you didn't set ORACLE_SID
2 You are on a client, you didn't set up tnsnames.ora and/or don't
specify a service name when connecting.
You could of course also resolve this by reading the installation manual and/or the Troubleshooting chapter in the net8 administrator manual. This type of error usually is being caused by not reading the manual.
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Mon Aug 12 2002 - 12:57:06 CDT
![]() |
![]() |