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

Jane Wang via OracleMonster.com wrote:
> 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
>

There are many things that can go wrong, maybe you try to find the logfiles DBCA created and look what error actually occurred.

Or you use DBCA to create scripts and execute the scripts line by line to create the Database. At some point the database creation will fail *with an error* which in turn should give you an idea.

But most likely Noel is right and it's something with your network configuration - you don't use DHCP, do you?

HTH
Holger Received on Fri Jan 07 2005 - 04:16:10 CST