Re: getting ORA-00205 when starting from sqlplus

Specify the location and name of your controlfile(s) in the init. (CONTROL_FILES= parameter)

Alex Ivascu

"r0" <sada_at_drgdf.net> wrote in message news: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 Sun Nov 17 2002 - 05:04:46 CET