0 Replies Latest reply: Feb 27, 2013 5:20 AM by User556398-OC RSS

    Clone/Migrate Discoverer 10g (OAS10g) from Solaris to AIX. No Upgrade is ne

      Has anyone migrate or clone Discoverer 10g (OAS10g) from solaris to AIX. I am going to try these steps listed below.

      A) Pre-clone Steps:
      1) Login on Source Discoverer (Solaris) Machine as applmgr. There is no need to shutdown the services
      $ export ORACLE_HOME=/u01/product/10gR2
      $ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
      $ cd $ORACLE_HOME/clone/bin
      $ chmod 755 prepare_clone.pl
      $ ./prepare_clone.pl
      Clone log file location: /u01/product/10gR2/clone/logs/clone.log
      Error log file location: /u01/product/10gR2/clone/logs/error.log

      2) Copy the Discoverer directory to the target machine.

      3) Get the ias_admin_old_pwd as it is necessary as input for the clone

      B. Install Oracle 10g or Copy Source (10g) Oracle Home to target
      Run Oracle Installer in silent mode to create inventory etc

      C) Copy database files from source to target (AIX).
      Use RMAN convert/transportable tablespaces to convert from Solaris to AIX format
      Startup database on Target

      D)Clone Steps
      1) Login on the AIX box on target machine as root and set the inventory locations as:
      mkdir /etc/oraInventory
      chmod -R 777 /etc/oraInventory
      chown -R applmgr:dba /etc/oraInventory
      touch /etc/oratab
      chmod a+rw /etc/oratab
      chown applmgr:dba /etc/oratab
      echo 'inventory_loc=/etc/oraInventory' > /etc/oraInst.loc
      chown applmgr:dba /etc/oraInst.loc

      2) Rename the old inventory directory, which is copied from source.
      7) Start the clone activity.
      $ export ORACLE_HOME=/u01/product/10gR2
      $ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
      $ cd $ORACLE_HOME/clone/bin
      $ perl clone.pl ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME= -instance
      -ias_admin_old_pwd welcome -ias_admin_new_pwd secret
      Note: If the error occurs during the clone, clean the oraInventory directory and restart the clone process, otherwise the clone process will fail.
      C)Post Clone Steps
      1) Remove Old dbc files from /u01/product/10gR2/discoverer/secure

      2) Copy new dbc file from the application node to /u01/product/10gR2/discoverer/secure

      3) Change the old servername to new server name in httpd.conf

      4) $ORACLE_HOME/opmn/bin/opmnctl stopall

      5) $ORACLE_HOME/opmn/bin/opmnctl startall