Re: ORA-12560: TNS:protocol adapter error

yls177 wrote:

> i am on windows 2000, with oracle 8.1.7. My oracle was fine in the
> past. Until today, when i have problems with connection and found out
> that oracle has this "ORA-12560: TNS:protocol adapter error". I
> checked the oracleservice<sid> service and it was running. I also did
> a stop/start, and a restart but both failed. Eventually, i did a
> reboot of the system and it is fine now.
>
> I searched OSS and came across this note 441518 with the below
> section.
>
> "11. Check whether a reboot solves the problem. This solved the
> problem in the past, for example, in the case of problems accessing
> pipes such as
>
> sntpcall: Attempting to open pipe \\.\PIPE\ORANTPFE8.A68
> sntpcall: Failed to open pipe \.\PIPE\ORANTPFE8.A68, err = 2
>
> in the Net8 trace and in the subsequent ORA-12560. "
>
>
> My questions are as follows
> 1) Does it mean that this will happen consistently in future?
> 2) my alert file did not show the above error messages either.

Why would you be looking in the Alert file for a Listener issue? You might want to check the listener's log. (Also check whether the listener is up and running.)

Are you aware that an Oracle 'Listener' listens on the network for interaction requests on behalf of one or more [database] instances, and then passes the request to the required instance using an appropriate technique (such as hand off or bequeath)? As a result, the Listener (aka TNSListener) must be running and properly configured. The ORA-12560 generally indicates a problem interacting with the listener. Received on Mon Aug 02 2004 - 12:36:20 CDT