Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

From: yls177 <yls177_at_hotmail.com>
Date: 1 Aug 2004 21:43:35 -0700
Message-ID: <c06e4d68.0408012043.728dee6f@posting.google.com>


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. Received on Sun Aug 01 2004 - 23:43:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US