More Home Articles:

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

Fixed – The installer is unable to instantiate the file in Oracle 11g Express

The installer is unable to instantiate the file

Today I got the following error message while installing OracleXE112_Win32 on Windows 7 Professional 64 bit machine. I installed the same version on Windows 7 Professional 32 bit machine and it was working fine. Error Message: The installer is unable to instantiate the file C:\Users\admin\AppData\Local\Temp\{67D0AF91-F288-4E94-BB16-A688CDAAE03A}\KEY_XE.reg. The file does not appear to exist. Resolution: As you

How to Hide Formula in Excel 2007, 2010 & 2013

Hide formula in Excel - Formula Entered

This tutorial will explain you how to hide formula in Excel 2007, 2010 & 2013 (Step by Step instructions with captured snapshot). Steps for hiding formula in 2007, 2010 & 2013 are same, so we have taken the example of Microsoft Excel 2007. Step-1: Open Microsoft Excel > Type any formula as shown in below

Fixed – ORA-12541: TNS no listener error

ORA-12541 TNS no listener error

Yesterday my friend asked me about this error "ORA-12541 TNS no listener error" while connecting with oracle database. I told him about the below solution and it worked very well. He suggested me to post this article on TechiesDigest so that this tutorial can help other newbie database administrators too. Error Message: ORA-12541 TNS no

Get Passport in 10 Days with Aadhaar Card in India

Get Passport in 10 Days with Aadhaar Card

If you have Aadhaar Card then it’s a good news you can get your passport in 10 days. To expedite the passport issuing system, the ministry of external affairs (MEA) has now decided to rely on Aadhaar card for identification of the applicant and on the National Crime Records Bureau (NCRB) database for validation of