SOURCE APPS SIDE:
===============
bash_profile setup:
. /u01/appps/apps/apps_st/appl/APPSUAT_tos01.env
1.go to
cd cd $ADMIN_SCRIPTS_HOME
/u01/appps/apps/inst/apps/UAT_tos01/admin/scripts
perl adpreclone.pl appsTier
NOTE:YOU CAN DOWN APPLICATION SIDE.ITS NOT MANDATORY TO DOWN.
ON UP ALSO U CN RUN THIS COMMAND.
ps -ef|grep appldev|awk '{print"kill -9 "$2}'|sh -x ;
2.make zip file
tar -cvf apps.tar apps/
send to destine apps server:
scp -r apps.tar root@192.168.1.3:/u01/appps/
3.unzip :
tar -xvf apps.tar /u01/appps/
SOURCE DB SIDE:
===============
bash_profile setup:
. /u01/db/PROD/db/tech_st/11.1.0/UAT_tos01.env
export PATH
1.go to > cd $ORACLE_HOME/appsutil/scripts/UAT_tos01
perl adpreclone.pl dbTier
2.shutdown database;(DUE TO OFFLINE/COLDBACKUP CLONING)
shut immediate:
3.tar -cvf db.tar db/
4.send this files to target/destination db server.
scp -r db/ root@192.168.1.3:/u01/dbsetup/
5.unzip command: tar -xvf db.tar /u01/db/
======================================================
TARGET DB SIDE:
****************************************************
set the environment:
export $PATH
export ORACLE_HOME=/u01/db/PROD/db/tech_st/11.1.0/
export $PATH
export PATH=/u01/db/PROD/db/tech_st/11.1.0/bin/:$PATH
2.DESTINATION SERVER DB BUILDUP;
cd /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/bin
[oradev@tos01 bin]$ perl adcfgclone.pl dbTier
Target System Hostname (virtual or normal) [tos01] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : UAT
Target System Base Directory : /u01/db/PROD/
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/PROD/db/apps_st/data] : /u01/db/PROD/db/apps_st/data/
Target System RDBMS ORACLE_HOME Directory [/u01/db/PROD/db/tech_st/11.1.0] : /u01/db/PROD/db/tech_st/11.1.0/
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [tos01:0.0] :
TNS-01151: Missing listener name, UAT, in LISTENER.ORA
listener_UAT=
(description=
(address=(protocol=tcp)(host=xxx)(port=1521)
http://www.dba-oracle.com/t_tns_01151_missing_listener_name.htm
chmod -R 775 *
to listener.ora and other file of same dir.
http://xmlandmore.blogspot.com/2014/06/cloning-listener-wont-start-after.html
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
The Solution
After trying tool such as truss or strace on Linux, it didn't help much. Then, I have found articles [3,4] which have helped me solve the issue:
bash-3.2$cd /var/tmp
bash-3.2$ ls -la .oracle
total 12
drwxrwxrwt 2 root root 4096 Mar 17 11:38 .
drwxrwxrwt 3 root root 4096 Jun 10 18:28 ..
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 s#16150.1
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 s#16150.2
srwxrwxrwx 1 oracle lock 0 Feb 24 10:17 s#32488.1
srwxrwxrwx 1 oracle lock 0 Feb 24 10:17 s#32488.2
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 sEXTPROC1521
As shown above, our new server has an existing folder named .oracle under /var/tmp, which was owned by a different user (i.e. oracle). After we have backed up our original .oracle folder, we have changed the owner of /var/tmp/.oracle to be aime1 and removed the files within it. After restarting our listener, here are the new files generated in it:
GO TO /var/tmp folfder
remove only .tmp files.
rm -rf *.tmp
as root ,
#chown -R oradev:dba .oracle
6.run autoconfig on db tier
7.clean fnd_node table.
8.run script cmclea.sql on apps tier.
9.Reset password for apps tier.
10.Purge wf .
start listener
=================
APPLICATION SIDE CONFIGURATION:
[appldev@tos01 ~]$ cd $COMMON_TOP/clone/bin/
/u01/appps/apps/apps_st/comn/clone/bin
Log file located at /u01/appps/apps/apps_st/comn/clone/bin/CloneContext_0403234342.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [tos01] :
Target System Database SID : UAT
Target System Database Server Node [tos01] :
Target System Base Directory : /u01/appps/apps/
Target System Tools ORACLE_HOME Directory [/u01/appps/apps/apps/tech_st/10.1.2] :
RC-00002: Warning: Directory /u01/appps/apps/apps/tech_st/10.1.2 not found.
Target System Tools ORACLE_HOME Directory [/u01/appps/apps/apps/tech_st/10.1.2] : /u01/appps/apps/tech_st/10.1.2
Do you want to preserve the Display [tos01:0.0] (y/n) ? : n
Target System APPL_TOP Directory [/u01/appps/apps/apps/apps_st/appl] : /u01/appps/apps/apps_st/appl
Target System COMMON_TOP Directory [/u01/appps/apps/apps/apps_st/comn] : /u01/appps/apps/apps_st/comn
Target System Instance Home Directory [/u01/appps/apps/inst] :
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] :
Do you want to preserve the Display [tos01:0.0] (y/n) ? : n
Target System Display [tos01:0.0] :
Target System Port Pool [0-99] : 2
3.run autoconfig on db tier and appstier:
OP AR_TOP AHL_TOP OZF_TOP IES_TOP CSD_TOP IGC_TOP
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/UAT/inst/apps/UAT_erp-t-ap/admin/scripts/msc
mscmatlab.sh INSTALL_SETUP 127
AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /u01/UAT/inst/apps/UAT_erp-t-ap/admin/log/ApplyAppsTier_05212313.log for details.
ApplyApplTop Completed Successfully.
# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with errors .
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Problem : unzip was not in PATH variable.
Solution: export unzip to PATH
https://tobeimpact.blogspot.in/2013/06/running-adcfgclone-on-apps-tier-fails.html
POST CLONE STEPS:
http://balajiabhi.blogspot.in/2009/01/post-clone-steps-updating-tables.html
SQL> conn apps
Enter password:
Connected.
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
http://oragurus.com/2015/10/oracle-applications-cloning-r12/
Post Clone Steps:
Shutdown the Applications.
FND_NODES Cleanup
exec fnd_conc_clone.setup_clean , to clean the source node references.
Password Change
It is recommended to change the password as the passwords are copied from the production copy.
FNDCPASS apps/<source password> 0 Y system/<source system password> SYSTEM APPLSYS <new apps password>
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new apps password>
============================
1.shutdown application services.
2.run command :FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps321
3.Run autoconfig on apps side.
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
===========================
Run Autoconfig on both database and Application nodes.
DB Tier :
cd $ORACLE_HOME/appsutils/scripts/context_name/
./adautocfg.sh
Application Tier:
cd $ADMIN_SCRIPTS_HOME/
./adaugtocfg.sh
Start the Applications
Login to the Applications to perform any post cloning steps which are specific to client.
http://appsdbaclass.blogspot.in/2011/03/cloning-from-rman-backup-using_8126.html
===============
bash_profile setup:
. /u01/appps/apps/apps_st/appl/APPSUAT_tos01.env
1.go to
cd cd $ADMIN_SCRIPTS_HOME
/u01/appps/apps/inst/apps/UAT_tos01/admin/scripts
perl adpreclone.pl appsTier
NOTE:YOU CAN DOWN APPLICATION SIDE.ITS NOT MANDATORY TO DOWN.
ON UP ALSO U CN RUN THIS COMMAND.
ps -ef|grep appldev|awk '{print"kill -9 "$2}'|sh -x ;
2.make zip file
tar -cvf apps.tar apps/
send to destine apps server:
scp -r apps.tar root@192.168.1.3:/u01/appps/
3.unzip :
tar -xvf apps.tar /u01/appps/
SOURCE DB SIDE:
===============
bash_profile setup:
. /u01/db/PROD/db/tech_st/11.1.0/UAT_tos01.env
export PATH
1.go to > cd $ORACLE_HOME/appsutil/scripts/UAT_tos01
perl adpreclone.pl dbTier
2.shutdown database;(DUE TO OFFLINE/COLDBACKUP CLONING)
shut immediate:
3.tar -cvf db.tar db/
4.send this files to target/destination db server.
scp -r db/ root@192.168.1.3:/u01/dbsetup/
5.unzip command: tar -xvf db.tar /u01/db/
======================================================
TARGET DB SIDE:
****************************************************
set the environment:
export $PATH
export ORACLE_HOME=/u01/db/PROD/db/tech_st/11.1.0/
export $PATH
export PATH=/u01/db/PROD/db/tech_st/11.1.0/bin/:$PATH
2.DESTINATION SERVER DB BUILDUP;
cd /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/bin
[oradev@tos01 bin]$ perl adcfgclone.pl dbTier
Target System Hostname (virtual or normal) [tos01] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : UAT
Target System Base Directory : /u01/db/PROD/
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/PROD/db/apps_st/data] : /u01/db/PROD/db/apps_st/data/
Target System RDBMS ORACLE_HOME Directory [/u01/db/PROD/db/tech_st/11.1.0] : /u01/db/PROD/db/tech_st/11.1.0/
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [tos01:0.0] :
TNS-01151: Missing listener name, UAT, in LISTENER.ORA
listener_UAT=
(description=
(address=(protocol=tcp)(host=xxx)(port=1521)
http://www.dba-oracle.com/t_tns_01151_missing_listener_name.htm
chmod -R 775 *
to listener.ora and other file of same dir.
http://xmlandmore.blogspot.com/2014/06/cloning-listener-wont-start-after.html
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
The Solution
After trying tool such as truss or strace on Linux, it didn't help much. Then, I have found articles [3,4] which have helped me solve the issue:
bash-3.2$cd /var/tmp
bash-3.2$ ls -la .oracle
total 12
drwxrwxrwt 2 root root 4096 Mar 17 11:38 .
drwxrwxrwt 3 root root 4096 Jun 10 18:28 ..
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 s#16150.1
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 s#16150.2
srwxrwxrwx 1 oracle lock 0 Feb 24 10:17 s#32488.1
srwxrwxrwx 1 oracle lock 0 Feb 24 10:17 s#32488.2
srwxrwxrwx 1 oracle lock 0 Mar 17 11:38 sEXTPROC1521
As shown above, our new server has an existing folder named .oracle under /var/tmp, which was owned by a different user (i.e. oracle). After we have backed up our original .oracle folder, we have changed the owner of /var/tmp/.oracle to be aime1 and removed the files within it. After restarting our listener, here are the new files generated in it:
GO TO /var/tmp folfder
remove only .tmp files.
rm -rf *.tmp
as root ,
#chown -R oradev:dba .oracle
6.run autoconfig on db tier
7.clean fnd_node table.
8.run script cmclea.sql on apps tier.
9.Reset password for apps tier.
10.Purge wf .
start listener
=================
APPLICATION SIDE CONFIGURATION:
[appldev@tos01 ~]$ cd $COMMON_TOP/clone/bin/
/u01/appps/apps/apps_st/comn/clone/bin
Log file located at /u01/appps/apps/apps_st/comn/clone/bin/CloneContext_0403234342.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [tos01] :
Target System Database SID : UAT
Target System Database Server Node [tos01] :
Target System Base Directory : /u01/appps/apps/
Target System Tools ORACLE_HOME Directory [/u01/appps/apps/apps/tech_st/10.1.2] :
RC-00002: Warning: Directory /u01/appps/apps/apps/tech_st/10.1.2 not found.
Target System Tools ORACLE_HOME Directory [/u01/appps/apps/apps/tech_st/10.1.2] : /u01/appps/apps/tech_st/10.1.2
Do you want to preserve the Display [tos01:0.0] (y/n) ? : n
Target System APPL_TOP Directory [/u01/appps/apps/apps/apps_st/appl] : /u01/appps/apps/apps_st/appl
Target System COMMON_TOP Directory [/u01/appps/apps/apps/apps_st/comn] : /u01/appps/apps/apps_st/comn
Target System Instance Home Directory [/u01/appps/apps/inst] :
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] :
Do you want to preserve the Display [tos01:0.0] (y/n) ? : n
Target System Display [tos01:0.0] :
Target System Port Pool [0-99] : 2
3.run autoconfig on db tier and appstier:
OP AR_TOP AHL_TOP OZF_TOP IES_TOP CSD_TOP IGC_TOP
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/UAT/inst/apps/UAT_erp-t-ap/admin/scripts/msc
mscmatlab.sh INSTALL_SETUP 127
AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /u01/UAT/inst/apps/UAT_erp-t-ap/admin/log/ApplyAppsTier_05212313.log for details.
ApplyApplTop Completed Successfully.
# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with errors .
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Problem : unzip was not in PATH variable.
Solution: export unzip to PATH
https://tobeimpact.blogspot.in/2013/06/running-adcfgclone-on-apps-tier-fails.html
POST CLONE STEPS:
http://balajiabhi.blogspot.in/2009/01/post-clone-steps-updating-tables.html
SQL> conn apps
Enter password:
Connected.
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
http://oragurus.com/2015/10/oracle-applications-cloning-r12/
Post Clone Steps:
Shutdown the Applications.
FND_NODES Cleanup
exec fnd_conc_clone.setup_clean , to clean the source node references.
Password Change
It is recommended to change the password as the passwords are copied from the production copy.
FNDCPASS apps/<source password> 0 Y system/<source system password> SYSTEM APPLSYS <new apps password>
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new apps password>
============================
1.shutdown application services.
2.run command :FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps321
3.Run autoconfig on apps side.
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
===========================
Run Autoconfig on both database and Application nodes.
DB Tier :
cd $ORACLE_HOME/appsutils/scripts/context_name/
./adautocfg.sh
Application Tier:
cd $ADMIN_SCRIPTS_HOME/
./adaugtocfg.sh
Start the Applications
Login to the Applications to perform any post cloning steps which are specific to client.
http://appsdbaclass.blogspot.in/2011/03/cloning-from-rman-backup-using_8126.html
No comments:
Post a Comment