Monday, January 30, 2017

Webinar: Install Oracle Binaries or Clone Oracle Home

Oracle supports cloning and users can easily clone existing Oracle installations. But you need to understand why cloning is useful.

Date and time: Friday, Feb 24th 2017 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

This Webinar covers following Topics.
  • When cloning useful 
  • Different methods of Cloning 
  • How to perform Cloning 
  • References 
  • Q&A 
To register for this Webinar, please send an email to
Note that registrations are limited and first come and first serve basis.

You will receive an email confirmation with meeting session link.

For Presentation link "Click here"

Satishbabu Gunukula, Oracle ACE

Thursday, January 19, 2017

RMAN-06023 and Specification does not match any backup

If you come across a situation that you want to use RMAN to restore but there is a backup without using RMAN.

When you try to restore using RMAN you will receive the error message as below
RMAN-06023: no backup or copy of datafile xx found to restore

When you query catalog you will get below message as no backups in repository.

Specification does not match any backup in the repository

If you want to use the backups taken using HOT backup mode or copy, you must register all data files, archive logs into RMAN catalog.

Use below command to register.
RMAN> catalog start with '/ora-backup/ORCL/arch-bkp/' noprompt;
RMAN> catalog start with '/ora-backup/ORCL/data-bkp/' noprompt;

If your archive logs and data files are in same location then you need to run only once.

Once all backup copies are registered in RAM you can follow below link to restore

Satishbabu Gunukula, Oracle ACE

error in invoking target 'agent nmhs' of makefile

I come across a situation that servers & Operating systems are (O/S) are getting upgraded and we cannot perform in place upgrade for easy roll backing capability.

Also new O/S does not support the Database version.

We need to restore the Oracle database into unsupported Server version. We have copied the Database binaries and during the Database upgrade we got below error.

error in invoking target 'agent nmhs' of makefile

During upgrade or clone  you will get this error when relink is running

Here is the workaround 
ls $ORACLE_HOME/sysman/lib/

Search for the line 
Change it to:

Goto Database upgrade window and click on "Retry" and upgrade should run successfully.

Satishbabu Gunukula, Oracle ACE

SUSPEND and RELEASE background Jobs in SAP

To Suspend all Background jobs follow below steps. Normally uses will do this before upgrade or maintenance activity.

SE38 --> Program: BTCTRNS1 --> Run

SE38 --> Program: BTCTRNS2 --> Run

Satishbabu Gunukula, Oracle ACE

OPatch failed with error code 73

If users copy the ORACLE_HOME from one system to another unix system, make sure you run the clone command. If not the ORACLE_HOME information will not be registered in the oraInventory.

Some times users may get below errors when they copy ORACLE_HOME, ORACLE Inventory from a different system. Note that the path and SID may not be same.

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

By running ORACLE_HOME "Clone" command will create new inventory (if missing) and also takes care of re-linking of libraries..etc

$ORACLE_HOME/oui/bin/runInstaller -clone ORACLE_HOME="/home/oracle/product/v11203" ORACLE_HOME_NAME="Ora11203_home1" ORACLE_BASE="/oracle" oracle.sysman.ccr:PRE_REQUISITE=true

Before you run above command make sure you have /etc/oraInst.loc file with inventory_loc and inst_group.

Note that there are many parameters available and full list of parameters visit