EBS R12.2 Cloning Step by step
1. Preclone db tier and application Tier
2. Copy the apps Tier and db home only to target server
3. Take Rman full backup and copy the backup to target server
- Prepare the Source System for application tier.
- Copy both application tier nodes from the Source System to Target
System.
- Configure the Target System for and application tier.
ls
-ltr $COMMON_TOP/clone/FMW/FMW_Home.jar
ls -ltr $COMMON_TOP/clone/FMW/WLS/EBSdomain.jar
ls -ltr $COMMON_TOP/clone/FMW/WLS/plan/moveplan.xml
ls -ltr $COMMON_TOP/clone/FMW/OHS/ohsarchive.jar
ls -ltr $COMMON_TOP/clone/FMW/OHS/moveplan.xml
FS2 patch Edition File System is cloning enter the following commands:
RUN ADCFGCLONE appsTier dualfs Steps ON APPS NODE
$ cd /apps/applmgr/r12/fs1/EBSapps/comn/clone/bin
$ perl adcfgclone.pl appsTier dualfs
apps password: apps
weblogic password: weblogic123
Do you want to add a node
(yes/no) [no] : <press
enter>
Target System Hostname (virtual
or normal) [appsebsvis] : appsebsvis
Target System Database SID : test
Target System Database Server
Node [dbebsvis] : dbebsvis
Target System Base Directory : /apps/applmgr/r12
Target System Instance Home
Directory [/apps/applmgr/r12] :
Do you want to preserve the
Display [cl12315:0.0] (y/n) : n
Target System Display [appsebsvis01:0.0]
:
Target System Root Service
[enabled] :
Target System Web Entry Point
Services [enabled] :
Target System Web Application
Services [enabled] :
Target System Batch Processing
Services [enabled] :
Target System Other Services
[disabled] : enabled
Do you want the target system to
have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 0
Target System proxy hostname
[http-proxy.amer.consind.ge.com] :
Target System proxy port [8080] :
1. /usr/tmp/TEST
Choose a value which will be set
as APPLPTMP value on the target node [1] :
Target System Other File System Instance Top set to /apps/applmgr/r12/fs2/inst/apps/test_appsebsvis
Target System Port Pool [0-99] : 1
The new APPL_TOP context file has been created :
/apps/applmgr/r12/fs1/inst/apps/ERCEBS1T_appsebsvis/appl/admin/ERCEBS1T_appsebsvis.xml
Check Clone Context logfile
/apps/applmgr/r12/fs1/EBSapps/comn/clone/bin/CloneContext_1111074006.log for
details.
Creating Patch file system context file.....
Log file located at
/apps/applmgr/r12/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1111075056.log
1. Change system password
2. Change apps password
3. Change alloracle password
4. Change sysadmin password
5. Change Site name profile
6. Change Form Color profile
7. Run cmclean.sql scripts
Connect with APPS user
update fnd_svc_comp_param_vals
set parameter_value = 'dummy@dummy.com'
where parameter_id =
( select parameter_id
from
fnd_svc_comp_params_tl
where
display_name = 'Test Address'
);
COMMIT;
select count(*) from WF_NOTIFICATIONS where status = 'OPEN'
and mail_status = 'MAIL';
update WF_NOTIFICATIONS set
status = 'CLOSED', mail_status = 'SENT', end_date = sysdate where mail_status
in ('MAIL', 'ERROR','FAILED','INVALID')
;
commit;
select count(*) from WF_NOTIFICATIONS where status = 'OPEN'
and mail_status = 'MAIL';
Run the script wfntfqup.sql to
purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the
WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue
to be sent. It will then populate the
queue with the current data in the wf_notifications table. Since you have
changed the mail_status = 'SENT" it will not enqueue these messages
again.. Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be
placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.
Example Syntax:
sqlplus apps/apps@db
@$FND_TOP/patch/115/sql/wfntfqup.sql apps <apps> applsys
Update fnd_user set
email_address = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;
Update per_people_f set email_address =
'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;
update wf_local_roles set email_address = 'TestOraUser@dummy.com'
WHERE email_address IS NOT NULL;
Update po_vendor_sites_all set email_address =
'TestOraUser@dummy.com', remittance_email = 'TestOraUser@dummy.com' WHERE
email_address IS NOT NULL or remittance_email is not null;
Update hz_parties set email_address =
'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;
Update FND_USER_PREFERENCES set
preference_value= 'QUERY' where preference_name='MAILTYPE' and
preference_value!='QUERY';
set lines 132
col PREFERENCE_VALUE format a45
SQL> select
preference_value,count(*) from fnd_user_preferences where
preference_name='MAILTYPE' group by
preference_value;
Sanjeev , This is very Nice detailed steps very useful and handy steps for 12.2 cloning
ReplyDeleteOne of the good document for cloning.. thanks Sanjeev
ReplyDeleteconcisely documented!
ReplyDeleteIs there a process / script which can update (only for information) that clone was performed on date/ time comments ?
ReplyDeleteThis should update at certain db and apps tier places and perl scripts. This is only for information.
Let me know.
Thanks
Sandip Kumar
Gracefully written information on this blog are going to support me for my coming assignments. Every point was very clear and taught me few new parameters. I would like to use this information in coming future.
ReplyDeleteTinder Clone
Please find some more oracle DBA interview question:
ReplyDeletewww.top15search.blogspot.com
Ebs R12.2 Cloning Step By Step >>>>> Download Now
ReplyDelete>>>>> Download Full
Ebs R12.2 Cloning Step By Step >>>>> Download LINK
>>>>> Download Now
Ebs R12.2 Cloning Step By Step >>>>> Download Full
>>>>> Download LINK Id
Very good article . Thanks for sharing.
ReplyDeleteSnowflake Training
Snowflake Training in Hyderabad
Snowflake Online Training
Snowflake Online Training Hyderabad
Snowflake Training Online
Snowflake Training in Ameerpet
Snowflake Training Institute in Hyderabad