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
Like this:
Be the first to like this post.
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