Here the error that I got after upgrade the DB to 11g.
When I run the command: perl adpreclone.pl dbTier it failed on 0%.
$ perl adpreclone.pl dbTier
Running Rapid Clone with command...
perl /d01/oracle/product/11.2.0/appsutil/bin/adclone.pl java=/d01/oracle/product/11.2.0/jdk mode=stage stage=/d01/oracle/product/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/d01/oracle/product/11.2.0/appsutil/PROD_server.xml showProgress
Beginning database tier Stage - Mon Aug 13 14:23:49 2012
APPS Password : apps
Log file located at /d01/oracle/product/11.2.0/appsutil/log/PROD_server/StageDBTier_08131423.log
- 0% completed
ERROR while running Stage...
ERROR while running perl /d01/oracle/product/11.2.0/appsutil/bin/adclone.pl java=/d01/oracle/product/11.2.0/jdk mode=stage stage=/d01/oracle/product/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/d01/oracle/product/11.2.0/appsutil/PROD_server.xml showProgress ... Please check the log for more details..
In the log file:
#############################################################
Started StageDBTier at Mon Aug 13 14:05:16 IDT 2012
Version:
StageDBTier.java : 115.27
#############################################################
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : server
sDbDomain : domain
sDbPort : 1591
sDbSid : PROD
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@server.domain:1521:PROD
Connection obtained
-------------------ADX Database Utility Finished---------------
Cause: Zip executable in $ORACLE_HOME/bin have version 3.0 and need to be 2.3x
$ORACLE_HOME/bin/zip -v
Solution:
Need to change the executable to be point to /usr/bin/zip
1. mv $ORACLE_HOME/bin/zip $ORACLE_HOME/bin/zip_orig
2. ln -s /usr/bin/zip $ORACLE_HOME/bin/zip
3. $ORACLE_HOME/bin/zip -v
4. Re run perl adpreclone.pl dbTier
Good Luck ...
Dont know how worked out zip version at core of problem but thanks worked a treat.
ReplyDeleteSame as you upgraded EBS DB
from 10.2.0.4 to 11.2.0.3.6
prior to full application upgrade at later date.
My working ... including fluff
echo '--' `date` ============================
echo '--' `date` Check zip versions:
echo '--' `date` ============================
which zip
$ORACLE_HOME/bin/zip -v
ls -l $ORACLE_HOME/bin/zip
/usr/bin/zip -v
ls -l /usr/bin/zip
echo '--' `date` ============================
echo '--' `date` Backup zip:
echo '--' `date` ============================
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip*
mv $ORACLE_HOME/bin/zip $ORACLE_HOME/bin/zip_orig
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip*
echo '--' `date` ============================
echo '--' `date` Alter zip version:
echo '--' `date` ============================
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip*
ln -s /usr/bin/zip $ORACLE_HOME/bin/zip
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip
echo '--' `date` ============================
echo '--' `date` Check zip versions:
echo '--' `date` ============================
which zip
$ORACLE_HOME/bin/zip -v
ls -l $ORACLE_HOME/bin/zip
/usr/bin/zip -v
ls -l /usr/bin/zip
============================
Rerun adpreclone maually:
============================
cd ; pwd ; ls -lrt DBA_profile_11.sh ; . DBA_profile_11.sh
cd ${ORACLE_HOME}/appsutil/scripts/${ORACLE_SID}_`hostname -s` ; pwd ; ls -lrt adpreclone.pl
perl adpreclone.pl dbTier
apps
echo '--' `date` ============================
echo '--' `date` Reset zip:
echo '--' `date` ============================
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip*
ln -s /usr/bin/zip $ORACLE_HOME/bin/zip
rm /usr/bin/zip $ORACLE_HOME/bin/zip
mv $ORACLE_HOME/bin/zip_orig $ORACLE_HOME/bin/zip
echo '--' `date` ============================
echo '--' `date` Check zip versions:
echo '--' `date` ============================
which zip
$ORACLE_HOME/bin/zip -v
ls -l $ORACLE_HOME/bin/zip
/usr/bin/zip -v
ls -l /usr/bin/zip
--- correction to reset sip +
Deleteecho '--' `date` ============================
echo '--' `date` Reset zip:
echo '--' `date` ============================
cd $ORACLE_HOME/bin/ ; pwd ; ls -lrt zip*
rm $ORACLE_HOME/bin/zip
mv $ORACLE_HOME/bin/zip_orig $ORACLE_HOME/bin/zip
echo '--' `date` ============================
echo '--' `date` Check zip versions:
echo '--' `date` ============================
cd ; which zip
zip -v
$ORACLE_HOME/bin/zip -v
ls -l $ORACLE_HOME/bin/zip
/usr/bin/zip -v
ls -l /usr/bin/zip