ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file

Applies to: Database Management Software Oracle 10g and later. All platforms. Message: When starting up database following occ...

How to apply and rollback a Patch

How to apply a patch: Unzip the patch using [oracle@ ~]$ unzip .zip Go to new created folder by unzip and execute the following.   [or...

How to Find Oracle Database Patches Installed

Before installing any patch or using any command use $ORACLE_HOME/OPatch in your path variable as in below example, otherwise opatch command...

Find which users are using and how much UNDO is being used ?

Goal: How do you determine which users are using and how much UNDO is being used? Solution: select a.sid, a.serial#, a.username, b.used_u...

Step By Step Manual Database Upgrade to 11.2.0.2

Compatibility Matrix Database Upgrade are common but risky task for a DBA if not done properly. Here, I am listing detailed method of ...

Impdp over network using Network_link

Applies to:    Oracle Version: 10G and later Advantages: This is an alternate and fast approach for importing database from one databa...

ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

Applies to: Oracle Net Services - Version: 8.1.7.4.0 to 11.1.0.6.0 - Release: 8.1.7 to 11.1 Reason: The reason of this error is ...