Tuesday, August 14, 2012

adpreclone.pl dbTier failed on 0%

Hi All

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 ...

4 comments:

  1. Dont know how worked out zip version at core of problem but thanks worked a treat.
    Same 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

    ReplyDelete
    Replies
    1. --- correction to reset sip +
      echo '--' `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

      Delete
  2. If you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you must watch this video
    right away...

    (VIDEO) Why your ex will NEVER come back...

    ReplyDelete
  3. BlueHost is ultimately one of the best hosting provider with plans for any hosting requirements.

    ReplyDelete