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;

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.