DATABASE

Ask Oracle finacial team to logout from system.

*********************************************************************************************************************
Prior to having the SAs initiate the cloning, issue the following:

========RUN AS ORAPRD USER

on va-financial, run as oraprd: cd /finprd01/app/oraprd/product/10.2.0/appsutil/scripts/FINPRD_va-financial
perl adpreclone.pl dbTier
Log file located at /finprd01/app/oraprd/product/10.2.0/appsutil/log/FINPRD_va-financial/StageDBTier_07301839.log

========RUN AS APPPRD USER
run as appprd: cd $COMMON_TOP/admin/scripts/FINPRD_va-financial
perl adpreclone.pl appsTier
appprd: > /finprd01/app/appprd/FINPRD/common/admin/scripts/FINPRD_va-financial $ perl adpreclone.pl appsTier
Log file located at /finprd01/app/appprd/FINPRD/admin/FINPRD_va-financial/log/StageAppsTier_07301848.log
*********************************************************************************************************************
SAs Clone Scripts
*********************************************************************************************************************
1.      Set up the environemnt files:
>       Issue: cp /findev01/app/oradev/refresh/oradev.profile $HOME/.profile
>       Issue: export ORACLE_HOME=/findev01/app/oradev/product/10.2.0
>       Issue: export PATH=$ORACLE_HOME/bin:$PATH
>         Issue: export ORA_NLS10=/findev01/app/oradev/product/10.2.0/nls/data/9idata
>       Issue: cp /findev01/app/oradev/refresh/oradev.profile /findev01/app/oradev/.profile
>       Issue: cp /findev01/app/oradev/refresh/FINDEV_va-dev-financial.env $ORACLE_HOME/FINDEV_va-dev-financial.env
>       Issue: cp /findev01/app/oradev/refresh/adautocfg.sh.findev /findev01/app/oradev/product/10.2.0/appsutil/scripts/FINDEV_va-dev-financial/adautocfg.sh

cd
cd $ORACLE_
3.      Modify /findev01/app/oradev/product/10.2.0/admin/FINDEV_va-dev-financial/pfile/initFINDEV.ora
>       Issue: cp /findev01/app/oradev/refresh/initFINDEV.ora $ORACLE_HOME/admin/FINDEV_va-dev-financial/pfile/initFINDEV.ora
>       Issue: cp /findev01/app/oradev/product/10.2.0/dbs/initFINDEV.ora /findev01/app/oradev/product/10.2.0/dbs/initFINPRD.ora
>       Issue: rm $ORACLE_HOME/dbs/spfileFINDEV.ora
>       Issue: rm $ORACLE_HOME/dbs/initFINDEV.ora
>       Issue: rm $ORACLE_HOME/dbs/FINDEV_va-dev-financial_ifile.ora
>       Issue: ln -s /findev01/app/oradev/product/10.2.0/admin/FINDEV_va-dev-financial/pfile/initFINDEV.ora $ORACLE_HOME/dbs/initFINDEV.ora
>       Issue: ln -s /findev01/app/oradev/product/10.2.0/admin/FINDEV_va-dev-financial/pfile/FINDEV_va-dev-financial_ifile.ora $ORACLE_HOME/dbs/FINDEV_va-dev-financial_ifile.ora
>       Make sure db_name in /findev01/app/oradev/product/10.2.0/dbs/initFINPRD.ora is FINPRD
>       Make sure all filesystems references in /findev01/app/oradev/product/10.2.0/dbs/initFINPRD.ora point to findev0* and not finprd0*
>       Make sure all references to va-financial are changed to va-dev-financial

4.      Rename the datafiles in the DB (make sure SID is still FINPRD)
>       Close the unix session, and start a new one
>       Issue: export ORACLE_SID=FINPRD
>       Issue: startup mount pfile='/findev01/app/oradev/product/10.2.0/dbs/initFINPRD.ora';
>       Run /findev01/app/oradev/refresh/move_dev_df.sql
>       Issue: alter database open;
>       Issue: select * from v$dbfile to make sure files were indeed moved.

5.      Change sys and system passwords:
>       Issue: alter user system identified by new_d3v;
>       Issue: alter user sys identified by new_d3vs;
>       Issue: alter user admn identified by new_d3v;
>       Issue: alter user dbsnmp identified by new_d3v;

6.      Drop and recreate temp file:
>         Run /findev01/app/oradev/refresh/reb_dev_temp.sql
>         Issue: select * from v$tempfile to make sure the tempfile is what it should be

7.      Change the DB name (make sure SID is still FINPRD):
>       Issue: shutdown immediate
>       Issue: startup mount pfile='/findev01/app/oradev/product/10.2.0/dbs/initFINPRD.ora';
>       in another window, set the environment to FINPRD and issue nid command to change the database name:
        nid TARGET=sys/clone_d3v DBNAME=FINDEV LOGFILE=/tmp/FINDEVnid.log
>       check log file to make sure there were no errors

8.      Open database (change SID to FINDEV):
>       Issue: cd $ORACLE_HOME/dbs
>       Issue: export ORACLE_SID=FINDEV
>       Issue: startup mount pfile='/findev01/app/oradev/product/10.2.0/dbs/initFINDEV.ora';
>       Issue: alter database noarchivelog;
>       Issue: alter database open resetlogs;
>       Issue: alter database rename global_name to findev.world;
>       Issue: create spfile from pfile='/findev01/app/oradev/product/10.2.0/dbs/initFINDEV.ora';
>       Issue: shutdown immediate
>       Issue: startup

9. Disable jobs in sqlplus as sys/system/admn

>       exec sys.dbms_scheduler.disable( '"ADMN"."EXPIRE_USERS"');
>       exec sys.dbms_scheduler.disable( '"ADMN"."CHECK_USER_EXPIRY"');
>       exec sys.dbms_scheduler.disable( '"ADMN"."MONITOR_FAILED_LOGINS"');

10.     Perform post-clone operations: $ORACLE_HOME/appsutil/clone/bin, run
>       Issue: cp $ORACLE_HOME/appsutil/driver/instconf.drv $ORACLE_HOME/appsutil/driver/instconf.drv.old
>       Issue: cp /findev01/app/oradev/refresh/instconf.drv.findev $ORACLE_HOME/appsutil/driver/instconf.drv
>       Make sure there are no references to FINPRD in     $ORACLE_HOME/appsutil/driver/instconf.drv
>       Issue: $ORACLE_HOME/appsutil/clone/bin/adcfgclone.pl dbTier (with production password)
>       Options to use are:
Do you want to use a virtual hostname for the target node (y/n) [n] ?:
n
Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:

Target System database name [FINPRD]:FINDEV

Target system domain name [thexchange.com]:

Target system RDBMS ORACLE_HOME directory [/finprd01/app/oraprd/product/10.2.0]:/findev01/app/oradev/product/10.2.0

Target system utl_file accessible directories list [/finprd01/app/appprd/FINPRD/common/temp2]:/findev01/app/appdev/FINDEV/common/temp2

Number of DATA_TOP's on the target system [3]:4

Target system DATA_TOP 1:/findev02/oradata/FINDEV

Target system DATA_TOP 2:/findev04/oradata/FINDEV

Target system DATA_TOP 3:/findev03/oradata/FINDEV

Target system DATA_TOP 4:/findev04/oradata/FINDEV

Do you want to preserve the Display set to va-financial:0.0 (y/n) [y] ?:n

Target system Display [va-dev-financial:0.0]:

Perl executable location is set to:
/usr/bin/perl

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
2

Log file located at /findev01/app/oradev/product/10.2.0/appsutil/log/FINDEV_va-dev-financial/ApplyDBTier_08021903.log

11. Start listener:
>       Issue: lsnrctl start FINDEV

shoevi
12. Run autoconfig with xml in: /findev01/app/oradev/product/10.2.0/appsutil/FINDEV_va-dev-financial.xml



**********************************************************END *********************************************************

Start the application.
appprd: > /finprd01/app/appprd $ /finprd01/app/appprd/FINPRD/common/admin/scripts/FINPRD_va-financial/adstrtal.sh
appprd: > /finprd01/app/appprd $ /finprd01/app/appprd/FINPRD/common/admin/scripts/FINPRD_va-financial/adstpall.sh

You are running adstrtal.sh version 115.19

alter database rename file '/finprd04/oradata/FINPRD/user_idx01.dbf' to '/findev04/oradata/:/user_idx01.dbf'
alter database rename file '/finprd04/oradata/FINPRD/redo01b.log' to '/findev04/oradata/FINDEV/redo01b.log'

$ /findev01/app/appdev/FINDEV/common/admin/scripts/FINDEV_va-dev-financial/adstrtal.sh

$ORACLE_HOME/appsutil/java/oracle/apps/ad/autoconfig
$ORACLE_HOME/appsutil/clone/jlib/java/oracle/apps/ad/autoconfig
$ORACLE_HOME/appsutil/clone/jlib/java/oracle/apps/ad/ad/autoconfig

Edited the following files to substitute prd with dev:
/findev01/app/appdev/product/8.0.6/FINDEV_va-dev-financial.env
/findev01/app/appdev/FINDEV/FINDEV_va-dev-financial.env
/findev01/app/appdev/FINDEV/APPSFINDEV_va-dev-financial.env
/findev01/app/appdev/FINDEV/FINDEV.env

APPLICATION

1.      Modify /findev01/app/appdev/.profile
>       Issue: cp /findev01/app/appdev/refresh/appdev.profile /findev01/app/appdev/.profile

2.      Modify /findev01/app/appdev/FINDEV/APPSORA.env
>       Issue: cp /findev01/app/appdev/refresh/APPSORA.env.findev /findev01/app/appdev/FINDEV/APPSORA.env

3.      Source the .profile

4.      Run the post-clone utility (make sure $COMMON_TOP/clone/bin/adchkutl.sh is executable):
cd /findev01/app/appdev/FINDEV/common/clone/bin
perl adcfgclone.pl appsTier

Input will look like this for FINDEV:
Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target system database SID [FINPRD]:FINDEV

Target system domain name [thexchange.com]:

Username for the applications file system owner [appprd]:appdev

Target system database server node [va-financial]:va-dev-financial

Target system database domain name [thexchange.com]:

Does the target system have more than one application tier server node (y/n) [n] ?:

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:

Target system APPL_TOP mount point [/finprd01/app/appprd/FINPRD]:/findev01/app/appdev/FINDEV

Target system COMMON_TOP directory [/finprd01/app/appprd/FINPRD/common]:/findev01/app/appdev/FINDEV/common

Target system 8.0.6 ORACLE_HOME directory [/finprd01/app/appprd/product/8.0.6]:/findev01/app/appdev/product/8.0.6

Target system iAS ORACLE_HOME directory [/finprd01/app/appprd/product/iAS]:/findev01/app/appdev/product/iAS

Do you want to preserve the Display set to va-financial:0.0 (y/n) [y] ?:n

Target system Display [va-dev-financial:0.0]:

Location of the JDK on the target system [/opt/jdk1.5.0_22]:

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
2

Checking the port pool 2
done: Port Pool 2 is free

Complete port information available at /findev01/app/appdev/FINDEV/admin/out/FINDEV_va-dev-financial/portpool.lst

Verifying Database Connection...

Database Connection on Port 1523: Successful

Target system proxy hostname [va-financial.thexchange.com]:va-dev-financial.thexchange.com

Target system proxy port [80]:

UTL_FILE_DIR on database tier consists of the following directories.

1. /findev01/app/appprd/FINDEV/common/temp
Choose a value which will be set as APPLPTMP value on the target node [1]:/findev01/app/appdev/FINDEV/common/temp2


Backing up /findev01/app/appdev/FINDEV/admin/FINDEV_va-dev-financial.xml to
/findev01/app/appdev/FINDEV/admin/FINDEV_va-dev-financial.xml0.bak


5. Change passwords for apps, and module schema owners using fndcpass (scripts in
/findev01/app/appdev/pw)
>       change apps password:     FNDCPASS apps/<prod password> 0 Y system/new_d3v SYSTEM APPLSYS new_d3v
>       change sysadmin password: FNDCPASS apps/new_d3v 0 Y system/new_d3v USER SYSADMIN new_d3v


6. Make sure FNDSM trigger is compiled.. if not:

CREATE OR REPLACE TRIGGER fndsm
AFTER INSERT OR UPDATE ON FND_NODES FOR EACH ROW
BEGIN
if ( :new.NODE_NAME <> 'AUTHENTICATION' ) then
if ( (:new.SUPPORT_CP='Y') or (:new.SUPPORT_FORMS='Y') or (:new.SUPPORT_WEB='Y') ) then
fnd_cp_fndsm.register_fndsm_fcq(:new.NODE_NAME);
end if;
if (:new.SUPPORT_CP = 'Y') then
fnd_cp_fndsm.register_fndim_fcq(:new.NODE_NAME);
end if;
end if;
END;
/


7. Change configuration tables
>       log into sqlplus as apps and run /findev01/app/appdev/refresh/change_dev.sql


8. Run autoconfig
>       Cleanup FND_NODES: exec FND_CONC_CLONE.SETUP_CLEAN;
>       run autoconfig