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 after 8i installation and new db creation

ORA-12560: TNS:protocol adapter error after 8i installation and new db creation

From: Jane Wang via OracleMonster.com <forum_at_OracleMonster.com>
Date: Thu, 06 Jan 2005 21:16:57 GMT
Message-ID: <8bf2ec2ff91542ad8b593e972cd2f8df@OracleMonster.com>


I installed Oracle 8i on Windows 2000, but the installation was stuck when configuring Net8, Database Configuration Assistant and Oracle HTTP Service (the 3 optional tools). I checked that the following 6 Oracle services were installed under Windows Services:

Service name Status Startup

OracleOraHome81Agent	    Started		Automatic
OracleOraHome81ClientCache		        Manual
OracleOraHome81DataGatherer Started	        Automatic
OracleOraHome81HTTPServer		        Manual
OracleOraHome81PagingServer		        Manual
OracleOraHome81TNSListener  Started	        Automatic

I assumed that my Oracle installation was successful. But when I tried to use SQLPlus as follows:

sqlplus /nolog
conn / as sysdba

I got the error:
ORA-12560: TNS:protocol adapter error

I haven't created any database yet. I also tried to create a database manullay using Database Configuration Assistant. After I went through all the configuration, I got the same error, and the database was not created.

Anybody has any idea what could go wrong?

Thanks,

Jianqun

-- 
Message posted via http://www.oraclemonster.com
Received on Thu Jan 06 2005 - 15:16:57 CST

Original text of this message

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