2

I have followed link to solve the problem.

When it is giving ORA-00600: internal error code, arguments: [kcratr1_lostwrt] then I am using:

SQL> startup mount

the above line should return ORACLE Instance started but it is showing "cannot start already-running Oracle - shut it down first".

2
  • ORA-600 => go to Oracle's support site and search for the error. If no doc is found, open a case. – Mat Aug 1 '13 at 18:07
  • This is error you will get when the DB is corrupted. I had installed it once and got the same error. And the reasons for it can be not stopping the DB while you are shutting your PC down......This is my personal experience, so just thought to share it. – Harshit Aug 1 '13 at 19:07
4

ORA-00600 is Oracle's generic message for un-handled internal exceptions i.e. bugs. Usually they require us to raise an SR with Oracle Support. This can be a problem for sites who are using Oracle without a support contract. In that situation we are thrown on the resources of the internet.

The problem you are experiencing is due to a corrupted block. The top result in Google offers a simple workaround: find out more.

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

(Of course, this is only a solution if you are running in archivelog mode, and so can recover the lost block).

1

Also I am guessing that you are running database on disks with write caching enabled. Or RAID controller with write cache enabled and no batteries or flash to preserve unwritten data.

Do not do that if you value your data!

Quite probably you will get some corruptions in case of crash reboot e.g. in case of power loss.

-3

Instead of using

SQL> alter database open; 

command use the follwing command

SQL> alter database open resetlogs;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy