Fixed – ORA-00600: internal error code

SiteGround Hosting Discount

In our previous article you have seen how to fix ORA-19809: limit exceeded for recovery files and ORA-12541: TNS no listener error. In this article we will show you how to fix ORA-00600: internal error code.

Oracle Error:

ORA-00600: internal error code.

How to resolve ORA-00600: internal error code?

Just follow these simple steps to resolve the issue.


Step-1:

Open command prompt and enter following command.

C:\>sqlplus sys/sys@xe as sysdba

SQL*Plus: Release 11.2.0.2.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 11.2.0.2.0 - Production
SQL>

Step-2:

Now shutdown the database.


SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

Step-3:

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.

Step-4:

Enter recover command to recover database.

SQL> recover database;
Media recovery complete.

Step-5:

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.

I use SEMRush for Keyword Research & Boost Organic Traffic. Do You?

Highly recommended SEM & SEO Tool for overview of Traffic, Keywords, Backlinks and more. You can search your competitors URL to analyze keywords & crush your competition.



Leave a Reply

Your email address will not be published. Required fields are marked *