Tag Archives: Oracle DBA Tips and Tricks

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. As a DBA, you must know that Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges. If your database 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

How to Enable/Disable Archive Log Mode in Oracle 10g/11g

Enable Archive Log Mode

It’s a prime responsibility of Oracle DBA to keep database up 24×7 but there may be some chances when your database gets crash. If your database gets crash and you want to recover it using archive log files then your database must be in archive mode. If your database is in archive made then you

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