Re: ORA-01034: ORACLE not available

Control files are essential, database must have this file Can you find ora_contron1.ora in your system/

Send me init.ora and last potion of alert.log I will get back to you tommrow
and I will solve the problem yaa!!!!
I hope this is not company production database!

"Thomas Fischer" <himself_at_tfischer.de> wrote in message news:38c2c3fd.12745537_at_news.uni-kassel.de...
> Hi,
>
> On Sun, 05 Mar 2000 17:12:19 GMT, "joon" <joopark_at_home.com> wrote:
>
> >Yes, database never been mounted and opened. That ' s why
> >Looks like you several instances, and starting wrong one
> >
> >You should have initial file called "initARCH.ora" or something
> >It is in $ORACLE_HOME/dbs/
>
> Somewhere I read I need this file. it wasn't there, just an init.ora.
> I copied it to initARCH.ora.
>
> >go like this
> >
> >>srvmgrl
> >>connect internal
> >>startup pfile=$ORACLE_HOME/dbs/initARCH.ora
> >>select * from v$database;
>
> This is what I get:
>
> -----------------------------------------
> oracle_at_libretto:/home/oracle > svrmgrl
>
> Oracle Server Manager Release 3.0.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup pfile=/home/oracle/product/8.0.5/dbs/initARCH.ora
> ORACLE instance started.
> Total System Global Area 4554000 bytes
> Fixed Size 48400 bytes
> Variable Size 4227072 bytes
> Database Buffers 204800 bytes
> Redo Buffers 73728 bytes
> ORA-00205: error in identifying controlfile, check alert log for more
> info
> SVRMGR>
> -----------------------------------------
>
> in my initARCH.ora (copy od init.ora) it says:
>
> # define two control files by default
> control_files = (ora_control1, ora_control2)
>
> I tried to comment this out but it didn't work.
>
> Thanks,
> Tom
Received on Sun Mar 05 2000 - 17:44:42 CST