Startup Error: ORA-00205

From: Florian Ungersboeck <florian.ungersboeck_at_direkt.at>
Date: Mon, 16 Aug 2004 15:15:05 GMT
Message-ID: <Zb4Uc.22886$vG5.3619@news.chello.at>

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 Received on Mon Aug 16 2004 - 10:15:05 CDT