getting ORA-00205 when starting from sqlplus

From: r0 <sada_at_drgdf.net>
Date: Sat, 16 Nov 2002 11:27:04 -0500
Message-ID: <nzOdnUFltYND7EugXTWc1g_at_giganews.com>


hi, i installed oracle9i on solaris8, the installation finished fine and it started the database fine. after i rebooted, i tried starting it with dbstart.. where i get:

bash-2.03$ dbstart

Can't find init file for Database "DIA2". Database "DIA2" NOT started.
bash-2.03$

..so i..

bash-2.03$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Sat Nov 16 10:54:28 2002

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 43164544 bytes

Fixed Size                   729984 bytes
Variable Size              41943040 bytes
Database Buffers             204800 bytes
Redo Buffers                 286720 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

it seems to start, but when i 'exit' from sqlplus i do not see any oracle processes in ps -ef output.
i have set ORACLE_HOME to /opt/oracle/OraHome1 and ORACLE_SID to DB1, the name i gave the database when installing. the only other things ive done is copy $ORACLE_HOME/dbs/init.ora to initDB1.ora.

what else am i missing here?
thanks :) Received on Sat Nov 16 2002 - 17:27:04 CET

Original text of this message