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

ORA-12154 TNS could not resolve the connect identifier specified

We have faced following  issue in some versions of oracle such as Oracle 10g and Oracle 11g Express edition. "ORA-12154: TNS: Could not resolve service name" When you try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data for the service. When this lookup fails, Oracle client show

Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error

Oracle not started-ORA-16038, ORA-19809, ORA-00312 error

When you try to start your database and it fails with the error code ORA-16038, ORA-19809, ORA-00312. You can resolve this error with the help of this tutorial. Error Message: ORA-16038: log 3 sequence# 572 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 3 thread 1: '/oradata2/data1/dbase/redo03.log' Root Cause: SQL> startup

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

ORA-28056 Writing audit records to Windows Event Log failed-01

If you get "ORA-28056: Writing audit records to Windows Event Log failed" error while connecting with Oracle Database 11g which was installed on Windows Server 2003, you can try following method to resolve the issue. Open command prompt and try to connect with SYS privileges. Go to START > RUN > type CMD and press Enter

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

ORA-00844: Parameter not taking MEMORY_TARGET into account

In our previous article you have seen how to resolve ORA-19809: limit exceeded for recovery files error. In this article we will show you step by step guide to resolve "ORA-00844: Parameter not taking MEMORY_TARGET into account" error. Error Message: ORA-01078: failure in processing system parameters ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_SIZE

Fixed – ORA-19809: limit exceeded for recovery files

ORA-19809 limit exceeded for recovery files

If you connect with Oracle Database and it throws an error message "ORA-19809: limit exceeded for recovery files", It means there is no free space available in oracle's archive destination (db_recovery_file_dest). Error Message: Following error will show you in alert log file if you try to shutdown a database or switch a log file: ORACLE

Fixed – ORA-12560: TNS: protocol adapter error

ORA-12560: TNS: protocol adapter error

This article will explain you how to resolve ORA-12560: TNS: protocol adapter error. Error Message: ORA-12560: TNS: protocol adapter error Resolution: Method-1: To resolve this issue, you need to make sure that you have set the correct oracle SID. Lets take the following example. C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error

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

ORA-01033 ORACLE initialization or shutdown in progress

ORA-01033 ORACLE initialization or shutdown in progressIn our previous article you have seen how to resolve ORA-12541: TNS no listener error. Now today we will show you how to resolve ORA-01033: ORACLE initialization or shutdown in progress error. Error Message: ORA-01033: ORACLE initialization or shutdown in progress Resolution: As a DBA, you must know the