Database Cloning Issue in R12

Currently doing a R12 Single Instance Clone from PROD to TEST

I removed the Target ORACLE_HOME Direcories and untar'd the Source Oracle Home.I haven't touched the Oracle Inventory as it already had the Target Environment Details as its more of a refresh.

Though we know the ORACLE_HOME is already there.I tried adding it using the below command.

export ORACLE_HOME=/oracle/home/directory/11.1.0

cd $ORACLE_HOME/clone/bin

perl clone.pl ORACLE_HOME="/oracle/home/directory/11.1.0" ORACLE_HOME_NAME="11g_RDBMS_EE_" ORACLE_BASE="/opt/oracle"

It errored with the following message.

SEVERE:OUI-10197:Unable to create a new Oracle Home at /opt/oracle/product/11.1.0_IOFD. Oracle Home already exists at this location. Select another location.

Hence i went ahead and start doing the RMAN Restoration.While logging into 'sqlplus'.it throwed the bizzare error.

Enter user-name:

exec(): 0509-036 Cannot load program oracleIOFD because of the following errors:

0509-150 Dependent module libskgxp11.so could not be loaded.

0509-022 Cannot load module libskgxp11.so.

0509-026 System error: A file or directory in the path name does not exist.

ERROR:

ORA-12547: TNS:lost contact

Action Taken:

Did a relink.using relink all. After that i was able to login to sqlplus without any issue.However there were many errors with the relink .

Hence dettached the ORACLE_HOME from the Inventory and re-added as follow.

To De-attach Oracle Home from Inventory :

cd /oracle/home/directory/11.1.0/oui/bin

./runInstaller -silent -detachHome ORACLE_HOME="/oracle/home/directory/11.1.0" ORACLE_HOME_NAME="11g_RDBMS_EE_"

To Attach:

export ORACLE_HOME=/oracle/home/directory/11.1.0

cd $ORACLE_HOME/clone/bin

perl clone.pl ORACLE_HOME="/oracle/home/directory/11.1.0" ORACLE_HOME_NAME="11g_RDBMS_EE_" ORACLE_BASE="/opt/oracle"

This is has fixed the issue.