Post Clone Steps on EBS Environment
---------------------------------------------
1) Drop the Private Database link using apps user( ie these db link names are depend on your environment, just for example)
drop database link XXTEST.NIZAMAPPSDBA.COM;
drop database link XXTEST1.NIZAMAPPSDBA.COM;
2) Drop the Private Database link using sys user( ie these db link names are depend on your environment, just for example)
exec dropschema_dblinks('NIZAMAPPSDBA);
exec dropschema_dblinks('APPS');
3) Update the Worflow tables and FND table on Clone Environment(depend on your environment, just for example below)
Update apps.wf_systems (This should show the target Instance and not the source Instance)
select name,display_name from apps.wf_systems;
update apps.wf_systems set name=’<SID>’,display_name=’ <SID>.<hostname.domainname>’;
COMMIT;
eg: update apps.wf_systems set name='TEST.NIZAMAPPSDBA.COM',display_name='TEST.AU123.NIZAMAPPSDBA.COM’;
update apps.wf_systems set name='UATTEST.NIZAMAPPSDBA.COM',display_name='UATEST.DX123.NIZAMAPPSDBA.COM’;
UPDATE wf_notifications SET status ='CLOSED',mail_status ='SENT', end_date ='26-JAN-16' WHERE mail_status in ('MAIL','INVALID','OPEN');
update wf_agents set address = replace (address,'PROD','DEV') ;
eg: update wf_agents set address = replace (address,'HRD','TEST') ;
update wf_agents set address = replace (address,'HRD','UATTEST') ;
select name ,display_name from wf_systems;
update wf_systems set DISPLAY_NAME = replace (DISPLAY_NAME,'PROD.DBALOUNGE.COM','DEV.DBALOUNGE.COM');
eg:update wf_systems set DISPLAY_NAME = replace (DISPLAY_NAME,'PROD.NIZAMAPPSDBA.COM','TEST.NIZAMAPPSDBA.COM');
update wf_systems set DISPLAY_NAME = replace (DISPLAY_NAME,'PROD.NIZAMAPPSDBA.COM','UATTEST.NIZAMAPPSDBA.COM');
Commit;
Update the target node in CM fnd_concurrent_queues table using below post_clone.sql script. values will be different and it is based on our environment
WHENEVER SQLERROR EXIT FAILURE
WHENEVER OSERROR EXIT FAILURE
SET echo OFF
SET linesize 150
set verify off
SET show OFF
define Backup_date = "&Backup_Date"
UPDATE fnd_profile_option_values
SET profile_option_value = 'Production Copy '||'&BACKUP_DATE'
WHERE profile_option_id=125;
UPDATE fnd_concurrent_queues
SET node_name='TEST1243'
WHERE node_name in('PROD252','PROD253','PROD214','PROD215','PROD258','PROD259','PROD250','PROD251');
UPDATE fnd_concurrent_queues
SET node_name2='TEST1243'
WHERE node_name2 in('PROD252','PROD253','PROD214','PROD215','PROD258','PROD259','PROD250','PROD251');
UPDATE fnd_concurrent_queues
SET node_name2='TEST1243'
WHERE node_name2 in('PROD252','PROD253','PROD214','PROD215','PROD258','PROD259','PROD250','PROD251');
UPDATE fnd_concurrent_queues
SET target_node='TEST1243'
WHERE target_node in('PROD252','PROD253','PROD214','PROD215','PROD258','PROD259','PROD250','PROD251');
UPDATE fnd_concurrent_queues
SET target_node='TEST1243'
WHERE target_node in('PROD252','PROD253','PROD214','PROD215','PROD258','PROD259','PROD250','PROD251');
commit;
4) Cleaning the Clone Setup and Change the password in Clone Environment
FNDCPASS apps/****** 0 Y system/**** SYSTEM APPLSYS apps
FNDCPASS apps/***** 0 Y system/****** USER sysadmin Welcome123456789
perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl
exec FND_CONC_CLONE.SETUP_CLEAN;
Run cmclean.sql
1. Change the value for context variables s_url_protocol, s_local_url_protocol,s_webentryurlprotocol in context file from https to http.
3. Change the value of s_help_web_agent, s_login_page, s_external_url context variables to point to http url and the port in the url refers to s_webport.
4. Change the value of s_enable_sslterminator to - <sslterminator oa_var="s_enable_sslterminator">#</sslterminator>
AUTOCONFIG
-----------
Run adautocfg.sql in DB and Apps Tier
$FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes -appspass=apps
Run adautocfg.pl in DB and Apps Tier
Start the application services.
5) Profile change if SSO to disabled on Clone Environment
------------------------------------------------------
Application Authenticate Agent to NULL
Applications SSO Type to SSWA
Applications SSO Login Types to Local
Applications Single Sign On Hint Cookie Name to ORASSO_AUTH_HINT
Application SSO LDAP Synchronization to NULL
Applications SSO Auto Link User to NULL
Applications SSO User Creation and Updation Allowed to NULL
6) Disable_concurrent_request on Clone Environment
--------------------------------------------------
update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where status_code in ('Q','I','P','R')
and requested_start_date > SYSDATE
and hold_flag = 'N';
update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where requested_start_date > SYSDATE
and hold_flag = 'N';
update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X';
define Backup_date = "&Backup_Date"
UPDATE fnd_profile_option_values
SET profile_option_value = 'Production Copy '||'&BACKUP_DATE'
WHERE profile_option_id=125;
7) Data Masking on Clone Environment, ie it depend on the evironment and organization requirement
-------------------------------------------------------------------------------------------------
login to database using HR schema, run below scripts
create table Per_all_people_f_nomask as select *from Per_all_people_f;
update Per_all_people_f
set full_name=dbms_random.string('U', 20),
first_name=dbms_random.string('U', 20),
last_name=dbms_random.string('U', 20),
middle_names=dbms_random.string('U', 20),
global_name=dbms_random.string('U', 20),
local_name=dbms_random.string('U', 20);
create table per_phones_nomask as select *from per_phones;
update per_phones
set phone_number=trunc(dbms_random.value(1000000000,9999999999));
create table per_analysis_criteria_no_mask as select *from per_analysis_criteria;
update per_analysis_criteria
set segment1=trunc(dbms_random.value(1000000000,9999999999)),
segment5=trunc(dbms_random.value(1000000000,9999999999)),
segment6=trunc(dbms_random.value(1000000000,9999999999));
