4 Replies Latest reply on Jan 10, 2016 8:57 AM by Bashar.

    Preclone issue

    Ibrahim Malek

      Good Morning Dear Friends

       

      i've a dbTier server that had 380 G DB as prod db i need to clone it into a new hardware  as i know the Tar file doesn't support more than 100 G

       

      the os is solaris 10

       

      DB oracle 10.2.3

       

       

      this is the log of the preclone 

       

      it didn't take much time & i can't see any error please have a look

       

       

      Sun Jan 10 07:30:17 2016

      -bash-3.2$ vi /oracle/prod/d01/db/tech_st/10.2.0/appsutil/log/PROD_srvhqon16/StageDBTier_01100730.log

      "/oracle/prod/d01/db/tech_st/10.2.0/appsutil/log/PROD_srvhqon16/StageDBTier_01100730.log" 275 lines, 15280 characters

      #############################################################

      Started StageDBTier at Sun Jan 10 07:30:06 AST 2016

      Version:

              StageDBTier.java        :       120.6.12000000.3

      #############################################################

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

      ZIP used: Zip 2.3 (November 29th 1999). Usage:

      # Calling StageDBTechStack...

      Evaluated internal cloning stage: /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone

      Creating Staging Area

      Creating bin directory

      Copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil//template/adxdbctx.tmp to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//context/db/adxdbctx.tmp

      Creating html directory

      Creating jre directory

      Cloning Stage Area already exists, updating existing area.

      Creating jlib directory

      Copied /oracle/prod/d01/db/tech_st/10.2.0/lib/xmlparserv2.jar to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar

      Copied /oracle/prod/d01/db/tech_st/10.2.0/appsutil/java/oracle/apps/ad to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/java/oracle/apps

      Copied /oracle/prod/d01/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar

      Copying file from /oracle/prod/d01/db/tech_st/10.2.0/appsutil/bin to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/bin

      Copy OUI from /oracle/prod/d01/db/tech_st/10.2.0/oui/jlib to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui/

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/xmlparserv2.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/jewt4.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_zh_TW.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/share.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_ko.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/oracle_ice.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_fr.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_ja.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/orai18n-collation.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/emCfg.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_zh_CN.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/help4-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3-swingaccess.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_de.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/jewt4-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/xml.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/orai18n-mapping.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_pt_BR.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/oneclick.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraPrereqChecks.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/help4.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/srvm.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstImages.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ojmisc.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_es.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraPrereq.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/swingaccess.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ouica.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_it.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraInstaller.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/classes12.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraInstallerNet.jar

      Copy OUI from /oracle/prod/d01/db/tech_st/10.2.0/oui/lib to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//oui/

      Make Home Clonable

      Updating ORACLE_HOME clone drivers: /oracle/prod/d01/db/tech_st/10.2.0/

      Completed update to ORACLE_HOME clone drivers. Sun Jan 10 07:30:10 AST 2016

      Running ORACLE_HOME clone drivers: /oracle/prod/d01/db/tech_st/10.2.0/appsutil/driver/preclone.drv

      instantiate file:

         source : /oracle/prod/d01/db/tech_st/10.2.0/appsutil/template/adregdb.drv

         dest   : /oracle/prod/d01/db/tech_st/10.2.0/appsutil/driver/regclone.drv

         backup : /oracle/prod/d01/db/tech_st/10.2.0/appsutil/driver/regclone.drv to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/regclone33.drv

         setting permissions: 700

         setting ownership: oraprod:dba

      Completed update to ORACLE_HOME clone drivers. Sun Jan 10 07:30:10 AST 2016

      Done...

      # Calling StageDatabase...

      Evaluated internal cloning stage: /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone

      Creating Staging Area

      Creating bin directory

      Copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil//template/adxdbctx.tmp to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//context/db/adxdbctx.tmp

      Creating html directory

      Creating jre directory

      Cloning Stage Area already exists, updating existing area.

      Creating jlib directory

      Copied /oracle/prod/d01/db/tech_st/10.2.0/lib/xmlparserv2.jar to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar

      Copied /oracle/prod/d01/db/tech_st/10.2.0/appsutil/java/oracle/apps/ad to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/java/oracle/apps

      Copied /oracle/prod/d01/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar

      Copying file from /oracle/prod/d01/db/tech_st/10.2.0/appsutil/bin to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/bin

      Copy OUI from /oracle/prod/d01/db/tech_st/10.2.0/oui/jlib to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui/

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/srvm.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/help4.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_ja.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_de.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/oneclick.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ouica.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_ko.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/oracle_ice.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_pt_BR.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_fr.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/help4-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/jewt4-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/xmlparserv2.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3-nls.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ewt3-swingaccess.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraPrereqChecks.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_zh_CN.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_it.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_es.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/jewt4.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/xml.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstImages.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/swingaccess.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/share.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/orai18n-mapping.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraPrereq.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/InstHelp_zh_TW.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraInstallerNet.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/OraInstaller.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/orai18n-collation.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/emCfg.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/ojmisc.jar

      copying /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//jlib/oui//jlib/classes12.jar

      Copy OUI from /oracle/prod/d01/db/tech_st/10.2.0/oui/lib to /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone//oui/

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

      Generating Create Control file script adcrdbclone.sql

      Checking if listener is already up for PROD...

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnectionUsingAppsJDBCConnector() -->

          APPS_JDBC_URL='null'

          Trying to get connection using SID based connect descriptor

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

      Net8 listener Started...

       

       

      Connecting to the Database PROD to create dbinfo.lst and adcrdbclone.sql

       

       

      ---------------------------------------------------------------

                         ADX Database Utility

      ---------------------------------------------------------------

       

       

      getConnection() -->

          sDbHost    : srvhqon16

          sDbDomain  : chamber.org.sa

          sDbPort    : 1526

          sDbSid     : PROD

          sDbUser    : APPS

          Trying to connect using SID...

      getConnectionUsingSID() -->

          JDBC URL: jdbc:oracle:thin:@srvhqon16.chamber.org.sa:1526:PROD

          Connection obtained

       

       

      -------------------ADX Database Utility Finished---------------

       

       

      /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/dbfinfo.lst created Successfully.

      Generating /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/addbhomsrc.xml which will contain the unique mount points

       

       

      No of parameters for Object: REGISTER_DBNODE in Package: FND_NET_SERVICES is :29

      NODE_ID Column Availability: true

      Node Id Column is available. dbfinfo.lst will contain the node list

      Host Column Availability: true

      Generated /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/addbhomsrc.xml successfully.

      /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/adcrdbclone.sql created Successfully.

      Disconnected from Database.

       

       

      Zip2 - Start of native zipping array sh -c "cd /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/; zip  -q  -y /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clo

      ne/data/stage/adcrdb.zip -@ ; echo ERRORCODE = $? ERRORCODE_END"

      Zip2

      ERRORCODE = 0 ERRORCODE_END

      .end std out.

       

       

      .end err out.

       

       

       

       

      Zip2 - Completed native zipping sh -c "cd /oracle/prod/d01/db/tech_st/10.2.0/appsutil/out/PROD_srvhqon16/; zip  -q  -y /oracle/prod/d01/db/tech_st/10.2.0/appsutil/clone/da

      ta/stage/adcrdb.zip -@ ; echo ERRORCODE = $? ERRORCODE_END"

      Done...

       

       

       

       

      #############################################################

      StageDBTier Finished at Sun Jan 10 07:30:14 AST 2016

      Status: Completed Successfully

      #############################################################