Menu

14 Nisan 2011 Perşembe

ORA-00205: error in identifying controlfile, check alert log for more info

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

Total System Global Area  839282688 bytes
Fixed Size                  2217992 bytes
Variable Size             494929912 bytes
Database Buffers          339738624 bytes
Redo Buffers                2396160 bytes
ORA-00205: error in identifying control file, check alert log for more info

Eger sizde benim gibi yukaridaki hatayi aldiysaniz. sorun ORACLE_SID `nin ASM olmamasidir.

Çözüm; Oracle SID'sini ASM'ye çevirmek..

sqlplus / as sysdba
SQL>shutdown immediate;
exit
2.export ORACLE_SID=+ASM
SQL> startup

yada

SQL> startup force
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2217992 bytes
Variable Size             494929912 bytes
Database Buffers          339738624 bytes
Redo Buffers                2396160 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE
SQL>

1 yorum:

  1. Nice blog here! Also your site loads up very fast!
    What web host are you using? Can I get your affiliate link
    to your host? I wish my web site loaded up as quickly as yours lol

    My page: Things to steer clear of whenever going through man boobs therapy

    YanıtlaSil