Category Archives: Oracle DBA

Resolved ORA-12154: TNS:could not resolve the connect identifier specified

ORA 12154 Error

This issue is faced in some versions of oracle as ORA-12154: TNS: Could not resolve service name. Mostly this issue comes in Oracle 10g and Oracle 11g Express edition which i have faced. When you or any application try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data

ORA-00600: internal error code – Fixed

ORA-00600 internal error code

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. Oracle Error: ORA-00600: internal error code. How to resolve ORA-00600: internal error code? Just follow these steps to

Fixed: ORA-01722: invalid number

Ora-01722 Invalid Number

One of my friends asked me to resolve the oracle “ORA-01722: invalid number” error. He was getting this error while generating reports through an application from oracle 10g database. I suggested him the solution of this problem because I had also faced same problem few months ago. Before describing solution of this problem, it is

Fixed: ORA-28056: Writing audit records to Windows Event Log failed

Ora-28056 event log failed

Today I tried to connect with Oracle Database 11g and got ORA-28056 error. Oracle Database was installed on Windows Server 2003. I just issued the following command and got this error. START > RUN > CMD C:\>sqlplus /nolog SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 23 13:40:09 2014 Copyright (c) 1982, 2010, Oracle.  All rights

Fixed – ORA-19809: limit exceeded for recovery files

ORA-19809 limit exceeded

When you try to connect with Oracle Database and it throws an error message ORA-19809: limit exceeded for recovery files. It means archive destination (db_recovery_file_dest) has been full. Following error will appear in the alert log file if you try to shutdown a database or switch a log file: ORACLE Instance flash – Archival Error

Fixed – ORA-01033: ORACLE initialization or shutdown in progress

Ora-011033 Oracle error

When you login into Oracle Database and it throws following error message: ORA-01033: ORACLE initialization or shutdown in progress, then follow the below mentioned steps to solve this issue. The following video is a practical demonstration to resolve ORA-01033: ORACLE initialization or shutdown in progress error. As a DBA, you must know that Shutdown, Shutdown

Fixed – ORA-12560: TNS: protocol adapter error

Ora-12560 Error

When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol adapter error Then follow the below mentioned steps to solve this issue. First of all, make sure that you have set the correct ORACLE_SID: C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\>set ORACLE_SID=xe C:\>sqlplus

Fixed – ORA-00844: Parameter not taking MEMORY_TARGET into account

Ora-00844 Error

When you start your database and it throws following error: ORA-01078: failure in processing system parameters ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_SIZE 9445460234 cannot be set to more than MEMORY_TARGET 4547687648. Cause: The SGA_MAX_SIZE parameter is larger than MEMORY_TARGET parameter. May be you forgot to set the MEMORY_TARGET in the spfile after

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)