Re: pb starting Oracle 9i on Linux

From: Beserko <beserkobob_at_yahoo.ca>
Date: Mon, 30 Dec 2002 22:16:57 -0500
Message-ID: <pan.2002.12.31.03.16.54.158865.2834@yahoo.ca>

When I installed Oracle, I haven't created a database. Should I create a database before or after setting those "control files" ? What I found in the manual is pretty vague.

Thanks,

B.

On Mon, 30 Dec 2002 11:03:21 -0500, Rauf Sarwar wrote:

> Beserko <beserkobob_at_yahoo.ca> wrote in message
> news:<pan.2002.12.30.06.21.41.788552.4447_at_yahoo.ca>...

>> Hi,
>>
>> I recently installed Oracle 9i on Linux. Everything went fine, but,
>> when I tried to start the database this message showed up :
>>
>>
>> [oracle_at_Rodan oracle]$ sqlplus /nolog
>>
>> SQL*Plus: Release 9.2.0.1.0 - Production on Lu Dec 30 01:16:16 2002
>>
>> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>>
>> SQL> connect / as sysdba
>> Connected to an idle instance.
>> SQL> startup pfile=/opt/oracle/product/9.2.0/dbs/init.ora ORACLE
>> instance started.
>>
>> Total System Global Area 42741800 bytes Fixed Size 450600 bytes
>> Variable Size 41943040 bytes Database Buffers
>> 204800 bytes Redo Buffers 143360 bytes
>> ORA-00205: error in identifying controlfile, check alert log for more
>> info
>>
>>
>> SQL>
>>
>> What's the problem ? I searched on the net, but I haven't found
>> anything useful.
>>
>> Thanks,
>>
>> B.

> 
> 
> Check that the proper control filename is referenced in the
> CONTROL_FILES initialization parameter in the init.ora file and try
> again.
> 
> Regards
> /Rauf Sarwar

Received on Mon Dec 30 2002 - 21:16:57 CST