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 -> Re: ORA-12560: TNS:protocol adapter error after 8i installation and new db creation

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

From: Noel <tomekb_at_s_o_f_t_m_a_n.pl>
Date: Fri, 07 Jan 2005 10:55:35 +0100
Message-ID: <crlmhr$jrf$1@atlantis.news.tpi.pl>


Dnia 1/7/2005 7:41 AM, Użytkownik DA Morgan napisał:

> 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
> 
> 
> Run DBCA

I'm affraid he did :(
There is lack of details i'm affraid.

Is it standalone instance of Oracle ?
If yes, have you got a TCP/IP protocol configured corectly? Have you got, i this case, 'loopback' service instaled on Win 2000 ? I would like to see TNSNAMES.ORA to check what sqlplus is gonna connect to, if that file exists, after failed Net8 configuration.

-- 
Noel
Received on Fri Jan 07 2005 - 03:55:35 CST

Original text of this message

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