Re: ORA-01034

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 26 Mar 2002 10:34:09 -0000
Message-ID: <3ca04eac$0$8514$ed9e5944@reading.news.pipex.net>

Run a command prompt and type the following

set oracle_sid=<sid>
svrmgr30
connect internal/<internal password>
startup;

this should either start the database up or give you an error message. You should also check the alert log , in fact now I am typing this do that first. My guess would be that the database might need recovery.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Peter Mathis" <pmathis_at_o-s-k.de> wrote in message
news:3ca04330.9750700_at_News.CIS.DFN.DE...


> Hi,

>

> after a power failure I get an "ORA-01034 ORACLE NOT AVAILABLE"-Error

> when I try to connect with SQL-Plus on one special db-service. Other

> db-services have no problem.

> I already checked the registry-settings and the config-files. The

> NT-Services start without an error. I also tried the "shutdown abort"

> command in svrmgr30 and of course a simple server-reboot. Before this

> power failure, the db worked fine.

> System is NT4, SP6 and Oracle 8.0.

>

> Any help appreciated.

>

> ciao

>  Peter

>

>

>

Received on Tue Mar 26 2002 - 04:34:09 CST