ORA-00600: internal error code – Fixed
In my previous articles you have learned how to fix ORA-01722: invalid number and ORA-28056: Writing audit records to Windows Event Log failed. In this article i will show you how to fix ORA-00600: internal error code.
ORA-00600: internal error code.
How to resolve ORA-00600: internal error code?
Just follow these steps to resolve the issue.
Open command prompt and enter following command.
C:\>sqlplus sys/sys@xe as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Wed Jan 28 20:41:12 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 220.127.116.11.0 - Production SQL>
Now shutdown the database.
SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down.
Mount the database using below command.
SQL> startup mount; ORACLE instance started. Total System Global Area 376635392 bytes Fixed Size 1383692 bytes Variable Size 285213428 bytes Database Buffers 83886080 bytes Redo Buffers 6152192 bytes Database mounted.
Enter recover command to recover database.
SQL> recover database; Media recovery complete.
Now open database with alter database open command.
SQL> alter database open; Database altered. SQL>
I hope this will help you to resolve your problem. If you are still unable to resolve this issue, write in comment section, we will definitely help you.
For latest updates, please join our free e-mailing list.
Get Free Blogging Tips & Technology updates in your Email !!!
Latest posts by Anil Verma (see all)
- Top 3 Custom Sidebar WordPress Plugins for Post & Pages - October 17, 2015
- Bluehost Coupon Codes Up To 75% OFF – August 2015 - August 25, 2015
- Make Money Online: $50-$100 Daily with Affiliate Marketing - August 10, 2015