Re: ORA-01034: ORACLE not available

From: Thomas Fischer <himself_at_tfischer.de>
Date: Mon, 06 Mar 2000 04:07:05 GMT
Message-ID: <38c2c127.12019913@news.uni-kassel.de>

Hi,

On Sun, 05 Mar 2000 17:12:19 GMT, "joon" <joopark_at_home.com> wrote:

>You should have initial file called "initARCH.ora" or something
>It is in $ORACLE_HOME/dbs/

yes, somewhere I read I need this file. it wasn't there just another one called init.ora.
I made a copy of it named 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 if init.ora) it says:

# define two control files by default
control_files = (ora_control1, ora_control2)

I already tried to comment this out - didn't work.

Thanks,
Tom Received on Sun Mar 05 2000 - 22:07:05 CST