Strange Misleading Error[XML -2018/ AC-10006] while R12 Clone

During the recent Multi Node to Single Node R12 Clone, Encountered an strange error. When doing the database portion of the clone. Below command 'adclonectx.pl' creates the Context file

$ perl adclonectx.pl contextfile=$ORACLE_HOME/appsutil/SOURCE_CONTEXT_FILE.xml template=$ORACLE_HOME/appsutil/template/adxdbctx.tmp pairsfile=$ORACLE_HOME/appsutil/clone/pairsfile.txt initialnode

When running the same command, It dumped the below error,

file:/tmp/tmpCtxClone.xml: XML-20108: (Fatal Error) Start of root element expected.

AC-10006: Exception - org.xml.sax.SAXParseException: file:/tmp/tmpCtxClone.xml: XML-20108: (Fatal Error) Start of root element expected. thrown while creating OAVars object for file: /tmp/tmpCtxClone.xml

The new database context file has been created :
/opt/oracle/product/11.1.0_SID/appsutil/SID_HostName.xml

At first site, I suspected that the issue is with format of the source xml file. Hence compared with the working XML file. Result is clean. Below portion of the error struck me

Thrown while creating OAVars object for file: /tmp//dummy.xml

Cause :

The /tmp is 100% full.

Fix:

Either remove the old files in /tmp directory OR export TEMP=/new/location where there is plenty of free space.

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.