Re: ORA-01034: ORACLE not available

Oracle wants to see the name(s) of your control file(s) in the init.ora file that it reads when trying to start your database. Make sure the names are there and properly pathed.

Van

joon <joopark_at_home.com> wrote in message news:KjCw4.99208$up4.1567540_at_news1.rdc1.ab.home.com...
> 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 - 19:12:42 CST