ORA-00600: internal error code, arguments


Facing below issue when database server down due to power outage.

SQL > startup

Error :-
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []


Cause:- 

This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

1. Timeouts
2. File corruption
3. Failed data checks in memory
4. Hardware, memory, or I/O errors
5. Incorrectly restored files



Solution :- 


SQL> shutdown immediate
SQL> startup mount
SQL>alter database recover database;
SQL> alter database open

No comments:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...