ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [

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.

Unlock PNET user when locked

[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;

Oracle stores the data's in a place called Datablock.

A specific number of Datablocks combined together to form an Extent. This Extent is the next level of logical storage of the Oracle Database.

The next level of storage is the Segment. A Segment can store larger data than the Extent,Ofcourse a specific number of Segments combined together to form a Segment.