Davis Apps DBA

Problem : ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ due to sudden power failure. when try to startup Oracle 10g database. it shows that database mounted and then followed by this error SQL> startup ORACLE instance started. Total System Global Area 197772160 bytes Fixed Size 1347876 bytes Variable Size 71304572 bytes Database Buffers 88080384 bytes Redo Buffers 7139328 bytes Database mounted. ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], [] Solution: This problem can be solved by using below commands 1. Shutdown the server Sql> Shutdown Immediate 2. Start the database with MOUNT option Sql> Startup Mount 3. Recovery the database using below command Sql> Recover Database 4. Open the database Sql> Alter Database Open Above steps will resolve above problem.

[root@oraapps ~]# su - oracle [oracle@oraapps ~]$ sqlplus '/as sysdba' SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 27 17:56:12 2013 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> select username,account_status from dba_users where account_status like '%LOCKED%'; SQL> alter user PNET account unlock;