Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, August 22, 2008

adpreclone 0% completed Error while running Stage...

Boda pinged me today and reported this error:

perl adpreclone.pl dbTier
Running Rapid Clone with command...
perl /erp11i/oracle/10.2.0/appsutil/bin/adclone.pl java=/erp11i/oracle/10.2.0/jdk mode=stage stage=/erp11i/oracle/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/erp11i/oracle/10.2.0/appsutil/ORPROD01_arctic.xml showProgress

Beginning database tier Stage - Fri Aug 22 09:32:45 2008
APPS Password : apps
Log file located at /erp11i/oracle/10.2.0/appsutil/log/ORPROD01_arctic/StageDBTier_08220932.log
| 0% completed
ERROR while running Stage...

ERROR while running perl /erp11i/oracle/10.2.0/appsutil/bin/adclone.pl java=/erp11i/oracle/10.2.0/jdk mode=stage stage=/erp11i/oracle/10.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/erp11i/oracle/10.2.0/appsutil/ORPROD01_arctic.xml showProgress ... Please check the log for more details..

The log file didn't have any details. Oracle advised on an SR to set this environment variable before re-executing adpreclone:

TIMEDPROCESS_DEBUG=YES
export TIMEDPROCESS_DEBUG

After setting the above and re-executing it we found that zip 2.2 was in path. As it is well known one of the pre-requisites of cloning is that you should be on zip 2.3, we modified the path so that zip 2.3 was in path first. However running adpreclone.pl still showed that zip 2.2 was being used. This was happening when the .env file was being sourced. When you logged in as oracle, zip was 2.3. But as soon as you sourced the $CONTEXT_NAME.env file the path changed and zip was 2.2. We corrected this in the .env file after which we got perl errors. So we changed

The DB was upgraded to 10.2.0.4 and no $ORACLE_HOME/Apache directory was present. So we pointed the PERL5LIB to the perl inside the IAS_ORACLE_HOME

PERL5LIB= $IAS_ORACLE_HOME/Apache/perl/lib/5.00503:$IAS_ORACLE_HOME/Apache/perl/lib/site_perl/5.005:$ORACLE_HOME/appsutil/perl
export PERL5LIB
ADPERLPRG=$IAS_ORACLE_HOME/Apache/perl/bin/perl
export ADPERLPRG

The same changes were also made in the context file variables s_adperlprg for ADPERLPRG and s_perl5lib for PERL5LIB so that these values remain correct after autoconfig.

adpreclone.pl succeeded after these changes.

1 comment:

Vikram Das said...

Thanks to ssingh for pointing out that I had left in the apps password in the post. I have now removed it and replaced with default password which is apps