Re: ORA-01034: ORACLE not available

From: Thomas Fischer <himself_at_tfischer.de>
Date: Sun, 05 Mar 2000 20:36:46 GMT
Message-ID: <38c2c3fd.12745537@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

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 - 14:36:46 CST