Re: Startup Error: ORA-00205

On Mon, 16 Aug 2004 15:15:05 GMT, Florian Ungersboeck <florian.ungersboeck_at_direkt.at> wrote:

>Hello,
>
>I'm a student, new to Oracle, and I try to set up a sample database using Oracle9i (9.2.0.4 Devoloper's Release) for Linux (64bit).
>
>The Installation was quite simple by reading the "Release notes" and the "Oracle9i Database Administrator's Guide".
>
>According to the "Oracle9i Database Administrator's Guide" I created the init****.ora file and created a sample-DB using Oracle managed files
>and a server parameter file. The files are there, but when I try to start the database, I receive the following error-message:
>
>SQL> connect sys/password as sysdba
>Connected.
>SQL> startup mount
>ORACLE instance started.
>
>Total System Global Area 127371024 bytes
>Fixed Size 743184 bytes
>Variable Size 109051904 bytes
>Database Buffers 16777216 bytes
>Redo Buffers 798720 bytes
>ORA-00205: error in identifying controlfile, check alert log for more info
>
>SQL>
>
>Can anybody tell me which step is missing here. For further information I copied same outputs from the screen.
>
>---------------------------------------------------------------------------------
>--------------------------------- SCREENOUTPUTS ---------------------------------
>---------------------------------------------------------------------------------
>
>$ORACLE_HOME=/u01/oracle/9.2.0.4
>
>
>15:48:31 [oracle] /u01/oracle/9.2.0.4/oradata $ ls -l
>total 616140
>drwxr-xr-x 2 oracle dba 4096 2004-08-16 15:34 .
>drwxr-xr-x 25 oracle dba 4096 2004-08-12 15:23 ..
>-rw-r----- 1 oracle dba 831488 2004-08-13 11:35 o1_mf_0krzc82k_.ctl
>-rw-r----- 1 oracle dba 104858112 2004-08-13 11:35 o1_mf_1_0krzc85v_.log
>-rw-r----- 1 oracle dba 104858112 2004-08-13 11:18 o1_mf_2_0krzcgqc_.log
>-rw-r----- 1 oracle dba 104861696 2004-08-13 11:35 o1_mf_indextbs_0ks085px_.dbf
>-rw-r----- 1 oracle dba 154341376 2004-08-13 11:35 o1_mf_system_0krzcwxm_.dbf
>-rw-r----- 1 oracle dba 104861696 2004-08-13 10:38 o1_mf_tempts_0krzhbmr_.tmp
>-rw-r----- 1 oracle dba 55578624 2004-08-13 11:35 o1_mf_undotbs_0krzgq40_.dbf
>-rw-r----- 1 oracle dba 104861696 2004-08-13 11:35 o1_mf_usertbs_0ks06dgv_.dbf
>15:48:38 [oracle] /u01/oracle/9.2.0.4/oradata $
>
>
>15:49:12 [oracle] /u01/oracle/9.2.0.4/dbs $ ls -l
>total 40
>drwxr-xr-x 2 oracle dba 4096 2004-08-16 15:40 .
>drwxr-xr-x 25 oracle dba 4096 2004-08-12 15:23 ..
>-rwxr-xr-x 1 oracle dba 12920 2003-11-21 21:38 initdw.ora
>-rw-r--r-- 1 oracle dba 2396 2004-08-16 15:40 initiseries.ora
>-rw-rw---- 1 oracle dba 24 2004-08-16 15:45 lkISERIES
>-rwSr----- 1 oracle dba 1536 2004-08-13 10:38 orapwiseries
>-rw-r----- 1 oracle dba 2560 2004-08-13 11:30 spfileiseries.ora
>15:49:15 [oracle] /u01/oracle/9.2.0.4/dbs $
>
>
>--- CREATE DATABASE STATEMENT---
>
>CREATE DATABASE iseries
>USER SYS IDENTIFIED BY v5r3i810
>USER SYSTEM IDENTIFIED BY v5r3i810
>MAXINSTANCES 1
>CHARACTER SET WE8ISO8859P15
>EXTENT MANAGEMENT LOCAL
>DEFAULT TEMPORARY TABLESPACE tempts
>UNDO TABLESPACE undotbs;
>
>
>
>
>thanks in advance
>--
>Florian Ungersboeck | Email : florian.ungersboeck_at_direkt.at

Hi Florian,

If you used the spfile spfileiseries.ora for DB creation, then the control file o1_mf_0krzc82k_.ctl should automaticallyl be added to the control_files parameter here.

Check v$parameter (it's available in nomount state) to see if control_files = '/u01/oracle/9.2.0.4/oradata/o1_mf_0krzc82k_.ctl'. If not, add it with
alter system set
control_files='/u01/oracle/9.2.0.4/oradata/o1_mf_0krzc82k_.ctl' scope = both;

• Kennet Koenraadt