Mungkin datafile anda corrupt., coba lakukan recover database Coba lihat alert log anda untuk memastikan error yang terjadi,.
mungkin seperti ini : =============================================================== 查看ALERT日志，发现 Errors in file /opt/oracle/admin/billdb/udump/billdb_ora_7186.trc: ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], [] ORA-600 signalled during: ALTER DATABASE OPEN... 打开上面提到的trace文件 Thread 1 current log 5 Scanning log 5 thread 1 sequence 67179 Scanning log 6 thread 1 sequence 67178 Cannot find online redo log for thread 1 sequence 67180 start recovery at logseq 67179, block 5453, scn 0 ----- Redo read statistics for thread 1 ----- BWR version: 0x0000.7f14c25e.01 flg: 0x04 Disk version: 0x0000.7f14c12d.01 flag: 0x04 *** 2007-10-11 10:08:49.541 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], [] Current SQL statement for this session: ALTER DATABASE OPEN Solusi : Bila anda memiliki backup yang valid,., lakukan recovery.,dengan perintah SQL > STARTUP MOUNT; SQL> RECOVER DATABASE; SQL> ALTER DATABASE OPEN; --- On Fri, 6/20/08, musisi musisi <[EMAIL PROTECTED]> wrote: From: musisi musisi <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Error ORA-01033 To: [email protected] Date: Friday, June 20, 2008, 7:37 AM setelah saya shutdown immediate lalu saya mount itu tidak ada kendala. setelah itu saya alter database open ko muncul error spt ini : SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr1_lastbwr] , [], [], [], [], [], [], [] --- On Fri, 20/6/08, Wahyudinata Herry <hwahyudinata@ yahoo.com> wrote: From: Wahyudinata Herry <hwahyudinata@ yahoo.com> Subject: Re: [indo-oracle] Error ORA-01033 To: indo-oracle@ yahoogroups. com Date: Friday, 20 June, 2008, 2:24 PM Haloo, cuma ikut share aja, untuk ORA-01033, itu disebabkan oleh , An attempt was made to log on while Oracle is being started up or shutdown, ( database nya mungkin belum Mounted atau Open) action nya, wait a few minutes then retry the operation solusinya coba perform a Shutdown Immediate di lanjutkan dengan Startup semoga agak membantu Hery --- On Fri, 6/20/08, musisi musisi <tc2681_2006@ yahoo.com. sg> wrote: From: musisi musisi <tc2681_2006@ yahoo.com. sg> Subject: [indo-oracle] Error ORA-01033 To: "Indo oracle" <indo-oracle@ yahoogroups. com> Date: Friday, June 20, 2008, 3:07 AM dear para oracle master, ada yang tahu solusi error dibawah ini ? ORA-01033; ORACLE initialization or shutdown in progress tolong bantuannya ? terima kasih Get the latest celebrity gossip - Yahoo! Singapore Search. http://sg.search. yahoo.com/ search?p= celebrity+ gossip&cs= bz&fr=fp- top [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Expand your social network today - Yahoo! Singapore Search. http://sg.search. yahoo.com/ search?p= social+networkin g+sites&cs= bz&fr=fp- top [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
