Re: ORA-01033: Oracle initialization or shutdown in progress

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 4 Jul 2003 15:46:06 +0100
Message-ID: <3f05932f$0$18491$ed9e5944@reading.news.pipex.net>

"Robert Wehofer" <thalion77_at_graffiti.net> wrote in message news:88gNa.106727$kC4.1743882_at_news.chello.at...
> > Look in the alert log and see what error messages you have.
>
> Where can I find the alert log file?

technically in the directory specified by the init.ora parameter background_dump_dest, but as you may not know where to find this I'd suggest

c:\oracle\admin\<sid>\bdump OR
c:\oracle\ora81\admin\<sid>\bdump OR
c:\oracle\ora81\rdbms\trace

It will be called alert<sid>.log so you could also use windows search. the alert.log is where system level alerts get written so should be checked regularly on production systems.

the initialization parameters can be found in init<sid>.ora in c:\oracle\ora81\database. (or any file listed on ifile= line in this file).

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Jul 04 2003 - 09:46:06 CDT