Saturday, October 17, 2015

Oracle Apps R12.2 Online patching


For 12.2 patching have to use 'ADOP' utility instead of 'ADADMIN'.
'ADOP' is the new ad utility given by Oracle for patching the Oracle Apps R12.2 environments.

Application tier technology patches are applied to the patch file system and the changes are propagated to the run file system as part of an Online Patching cycle

Steps for Online patching

1. Download any required technology patches and unzip them into the $NE_BASE/EBSapps/patch directory.

2. Prepare for patching
$ . <EBS_ROOT>/EBSapps.env
$ adop phase=prepare
3. Apply Technology patches
$ adop phase=apply patches=<patch number>
4. Finalize patch application
$ adop phase=finalize
5. Perform cutover
$ adop phase=cutover
6. Cleanup obsolete objects
$ . <EBS_ROOT>/EBSapps.env run
$ adop phase=cleanup
7. Synchronize the technology level between patch and run file systems
$ adop phase=fs_clone

Online Patching Cycle

Reference : Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

Tuesday, October 13, 2015

Step by Step Cloning - R12.2

DB Tier Cloning

1. Prepare source node for cloning
cd /u01/PROD/fs1/inst/apps/PROD_oracle/admin/scripts
perl adpreclone.pl appsTier
cd /u01/PROD/db/11.2.0/appsutil/scripts/PROD_oracle
perl adpreclone.pl dbTier
2. Shutdown Application and DB
cd /u01/PROD/fs1/inst/apps/PROD_oracle/admin/scripts
./adstpall.sh 
sqlplus / as sysdba
shutdown immediate; 
3. Copy db directory from source to target
scp -r /u01/PROD/db <targetIP>:/u01/DEV/
4. Set permission for db filesystem
chmod -R 775 /u01/DEV/db
chown -R oracle:dba u01/DEV/db
5. Switch user who own the db binary file system
su - oracle
6. Configure target DB Tier
cd /u01/DEV/db/11.2.0/appsutil/clone/bin
perl adcfgclone.pl dbTier

Apps Tier Cloning



1. Create following directories on target host
mkdir /u01/DEV/fs1 -p
mkdir /u01/DEV/fs2 -p
mkdir /u01/DEV/fs_ne -p
2. Copy EBSapps directory from source to target (no need to copy FMW_Home and inst Directories)
scp -r /u01/PROD/fs1/EBSapps <targetIP>:/u01/DEV/fs1
3. Set permission for Apps file system
chmod -R 775 /u01/DEV/fs1
chown -R oracle:dba u01/DEV/fs1
4. Switch user who own the db binary file system
su - oracle
5. Configure target run file system
cd /u01/DEV/fs1/EBSapps/comn/clone/bin
perl adcfgclone.pl appsTier
6. After startup target application server, prepare system for patch file system
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
perl adpreclone.pl appsTier
7. Shutdown application Server
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
./adstpall.sh
8. Copy EBSapps directory from run file system to patch file system on target host
cp -r /u01/DEV/fs1/EBSapps /u01/DEV/fs2
9. Configure target patch file system
cd /u01/DEV/fs2/EBSapps/comn/clone/bin
perl adcfgclone.pl appsTier
10. If all goes well, then start application Server
cd /u01/DEV/fs1/inst/apps/PROD_oracle/admin/scripts
./adstrtal.sh

Wednesday, October 7, 2015

'Host key verification failed' Error when scp from one host to another in linux


Problem

When Try to copy file from one host to another below error occur
[root@backup u01]# scp -r RPM_oel6/ 192.168.22.4:/u01
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that the RSA host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
ea:d6:b9:ac:45:e5:4a:46:ff:71:0b:84:a6:24:de:b2.
Please contact your system administrator.
Add correct host key in /root/.ssh/known_hosts to get rid of this message.
Offending key in /root/.ssh/known_hosts:2
RSA host key for 192.168.22.4 has changed and you have requested strict checking.
Host key verification failed.
lost connection

Solution

Please execute below command and copy again to overcome the issue
sed -i '2d' /root/.ssh/known_hosts 
Where '2d' is line number. If the line number is different then use the same