Some time we encounter this error while starting the database. Below is the solution for recovering through this error.
Error:
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1264916 bytes
Variable Size 264241900 bytes
Database Buffers 801112064 bytes
Redo Buffers 7122944 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
Encountered in : 10.2.0.2.0 Database
Cause:
Oracle is unable to perform instance recover but it works when is invoked manually.
Solution:
SQL> startup mount
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1264916 bytes
Variable Size 264241900 bytes
Database Buffers 801112064 bytes
Redo Buffers 7122944 bytes
Database mounted.
SQL> recover database
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
References
Metalink note ID: 393984.1
was very useful.Thanks
Thank u! very much! this info helped me!
Thanks, it did help
thanks..
thanks buddy
Thank you very much, you cannot imagine how it helped me
Thanks a lot. It is a big help, just solved my problem in one minute.
Thanks a lot, it was a great help, it resloved my problem !!!
Buddy! You Save my Job. God Bless You.
Thanks a lot.
wow..
thanks yow…
Great article,
Thanks a lot
Thanks it works
But i want to knw wat that command exactly doing
RECOVER DATABASE
thks it works
keep the good work going on
hey buddy. thanks a million.
Hi,
Thanks!
I resolved this issue.
It is working perfectly.
Wao !.. Fantastic .. this solved my problem
Hi Actually I was stuck up with the Disp+work.exe process stopped in SAP MMC ,there by I wasnt able to connect to the SAP web applicatino Server. went through all the traces like dev_w0 , alerts and dev_trace files. There the files was explaining that some problem with the Db_connect .
then started exploring online and found this simple steps.
Now I am able to log in my SAP.
Thanks