Fixed – ORA-00600: internal error code

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.

Subscribe to get free tech advice, tips and in-depth articles.


Start Your Dream Website Today & Earn Money Online

To Start a dream website, choose a Domain Name & Reliable Hosting Provider, Self-hosted Blogging Platform, WordPress Theme, Email Marketing and SEO Tool for traffic.

SiteGround Hosting Discount - 60% OFF
ConvertKit The Best Email Marketing Software
Free SEMRush SEM and SEO Tool
Get Your Hosting Package with SiteGround, Increase new email subscribers with ConvertKit and Research Keywords with SEMRush to Boost Organic Traffic.





Leave a Reply

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