Oracle on Linux, Error in identifying the control file

Hi every one,

I just finished installing Oracle 9i database on Redhat 9.

To start the server i do the following:

[root_at_server]# su - oracle
[oracle_at_server oracle]$ lsnrctl start
[oracle_at_server oracle]$ sqlplus /nolog
 

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jan 20 04:39:53 2004  

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.  

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
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 control file, check alert log for more info.

SQL>shutdown
ORA-1507 : database not mounted

ORACLE instance shut down.
SQL> On checking the alert log(alert_ora9i.log) in $ORACLE_HOME/rdbms/log, I found the following towards the end:

Wed Jan 21 06:34:07 2004
ORA-00202 : controlfile: 'ora_control1'
ORA-27037 : unable to obtain file status Linux Error : 2 : No such file or directory Additional Information : 3
Wed Jan 21 06:34:08 2004
ORA-205 signalled during : ALTER DATABASE MOUNT...

So i deleted the existing database and created a new one once again using dbca
During the process of database creation , I made sure the control files are created in the following path

$ORACLE_BASE/oradat/{DB-NAME}/control01.ctl
$ORACLE_BASE/oradat/{DB-NAME}/control02.ctl
$ORACLE_BASE/oradat/{DB-NAME}/control03.ctl
 

(I also should mention that the dbca after completing the database creation,it kind of hangs ie..it shows

Clone database creation in progress...
100% completed

But i cannot exit out..i have to do Ctrl-C on command line to close the dbca application)

Also i checked initora9i.ora(i had to creat/copy initora9i.ora from init.ora due to an earlier problem where the SQL start up gave me an error :could not open parameter file '$ORACLE_HOME/dbs/initora9i.ora' ).It is specified in initora9i.ora :

control_files = (ora_control1, ora_control2)

Should i comment this out? Or should i copy the control files in ORACLE_BASE/oradat/{DB-NAME}/ to some where else?

Can any one please help me out?

Any help would be greatly appreciated.

Thanks,
Ann Received on Wed Jan 21 2004 - 13:25:34 CST