Hi DBAs,
For a multi-node system with a shared application tier file system patching time will be reduce,as we apply patch only once – on the primary node.This ensures minimal downtime as all adpatch actions are performed only once.
Below are the steps which I follow to apply patch to Oracle EBS R12 Applications for 2 nodes Applications where SHARED APPL_TOP is enabled
along with PCP setup.This is RAC Oracle 11g Database.
We need to find out the primary node in the PCP(Parallel concurrent Processing) Concurrent managers set up.
Below link can be used for it:
http://rafioracledba.blogspot.com/search?q=primary
Step 1: Before applying patch:(check invalid objects in DB):
SQL> select name from v$database;
NAME
---------
TESTDB
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;
OWNER COUNT(*)
------------------------------ ----------
PUBLIC 1
APPS 158
SYS 3
Step 2:Enable Maintainance mode
ebstest:applmgr::/home/applmgr>echo $TWO_TASK
TESTDB
Use 'adadmin' to enable maintainance mode before patching.
5. Change Maintenance Mode
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Backing up restart files, if any......Done.
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Step 3:Applying patch using 'adpatch'(auto patch utility):Note:Review the readme file twice before proceeding with 'adpatch' session.
It is very important to review the readme.txt in unix vi editor before applying applying patch
and follow the instruction as given in the readme.txt file and apply any pre-requistics patch
if required.autoconfig run also not required unless it is specified after patch installation in readme.txt file.
Go to the patch top directory,where all driver and required ldt files are present with the application
filesystem owner,makes sure all files have read,write and execute permission.
As described below:
ebstest1:applmgr::/stage/patches/8845580>ls -altr
total 12432
-rwxrwxrwx 1 applmgr dba 2931 Oct 29 2007 u8845580.drv
-rwxrwxrwx 1 applmgr dba 1173 Oct 29 2007 f8845580.ldt
-rwxrwxrwx 1 applmgr dba 6323692 Oct 29 2007 b8845580.ldt
-rwxrwxrwx 1 applmgr dba 37 Oct 29 2007 marker1.txt
-rwxrwxrwx 1 applmgr dba 2852 Oct 29 2007 README.txt
-rwxrwxrwx 1 applmgr dba 5502 Oct 29 2007 README.html
drwxrwxrwx 5 applmgr dba 256 Feb 21 01:21 po
drwxrwxrwx 54 root dba 12288 Feb 21 01:21 ..
drwxr-xr-x 3 applmgr dba 256 Feb 21 01:21 .
ebstest:applmgr::/stage/patches/8845580>adpatch
Review the README for pre-requisite information.
Your default directory is '/d21/TESTDB/apps/appl'.
Is this the correct APPL_TOP [Yes] ?
Verify the log file after applying patch.Below is the 'adpatch' session.
ebstest1:/tmp/rafi/8845580>adpatch
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AutoPatch
Version 12.0.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.
Your default directory is '/product/app/TESTDB/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?
AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adpatch.log] : 8845580_05Jan2014.log
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [TESTDB] : TESTDB *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [ebstest2] : ebstest2 *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'TESTDB'
using ORACLE executables in '/product/app/TESTDB/apps/tech_st/10.1.2'.
Is this the correct database [Yes] ?
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Identifier for the current session is 44869
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/zfaprod.txt
does not exist for product "zfa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/zsaprod.txt
does not exist for product "zsa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/jtsprod.txt
does not exist for product "jts".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [B.3]
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
No baseline bug-fixes info available. Will attempt next time.
**************** S T A R T O F U P L O A D ****************
Start date: Sun Jan 05 2014 09:15:26
0 "left over" javaupdates.txt files uploaded to DB: Sun Jan 05 2014 09:15:26
0 patches uploaded from the ADPSV format patch history files: Sun Jan 05 2014 09:15:26
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Sun Jan 05 2014 09:15:26
****************** E N D O F U P L O A D ******************
End date: Sun Jan 05 2014 09:15:26
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/tmp/rafi/8845580] :
Please enter the name of your AutoPatch driver file : u8845580.drv
Done with Invoker's Rights processing.
Telling workers to quit...
1 worker has quit. Waiting for 47 more.
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
AD_DEFERRED_JOBS table dropped.
Updating the checkfile repository if necessary...
Processing the last batch...
Done updating the checkfile repository...
Done running SQL scripts and EXEC commands.
Compiling invalid objects...
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 48 0 NONE FALSE
Number of invalid objects: 141
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/44869_postenv.*
Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports for Specified driver
since no such action is present for this driver file
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 0 action history records for this bug (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 0 action history records for this bug (total).
Updating the current-view snapshot...
Done saving Patch History information.
About to do IREP processing...
Attempting to process IREP files ...
Successfully processed IREP files.
Done IREP processing.
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/TESTDB/applterr.txt to admin/applterr.txt.
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 44869 adt44869
A job timing report has been generated for the current session.
You should check the file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/out/adt44869.lst
for details.
Purging timing information for prior sessions.
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/8845580_05Jan2014.lgi
Errors and warnings are listed in the log file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/8845580_05Jan2014.log
and in other log files in the same directory.
Step 4: Disable Maintainance mode again by using 'adadmin' utility:
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
Enter your choice [6] : 5
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 2
sqlplus -s &un_apps/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
Successfully disabled Maintenance Mode.
sqlplus -s &un_apps/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
Successfully disabled Maintenance Mode.
Step 5: Bounce application after applying patch :
Step 5 a:Stop the Concurrent Managers in PCP setup:
In the PCP set use the below steps to Stop the Concurrent Managers.
Identify the Primary node,In our case Nodeapp01 is the prmary node of PCP setup.
a) stop apps listener on node1(Nodeapp01)
=>APPS_TEST
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adalnctl.sh stop
adalnctl.sh version 120.3
Shutting down listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adalnctl.txt for more information ...
b)Stop apps listener on node2(Nodeapp02)
Node2 /product/app/TEST/inst/apps/TESTX2_icmpapp02/admin/scripts >./adalnctl.sh stop
adalnctl.sh version 120.3
Shutting down listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX2_icmpapp02/logs/appl/admin/log/adalnctl.txt for more information ...
c)Stop the apps concurrent managers from node1
===============================================
SinceTEST_R12is having PCP setup,stop the Concurrent managers from node1(Primary node)
Node1:Nodeapp01
/product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adcmctl.sh stop
You are running adcmctl.sh version 120.17.12010000.5
Enter the APPS username : APPS
Enter the APPS password :
Shutting down concurrent managers for TEST_CM2 ...
ORACLE Password:
Submitted request 2532852 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adcmctl.txt for more information ...
step d): Check and Kill all processes by finding the concurrent processes:
On Node 1 and Node 2 make sure no concurrent manager process is running.
Node1: Nodeapp01
ps -ef|grep FNDLIBR|grep applmgr
ps -ef|grep FNDSM|grep applmgr
kill -9 pid
Node 2: icmpapp02
Node2: icmpapp02
ps -ef|grep FNDLIBR|grep applmgr
ps -ef|grep FNDSM|grep applmgr
kill -9 pid
Step e:Run cmclean.sql
Run cmclean.sql from application node by going to $ADMIN_SCRIPTS_HOME or $INST_TOP/admin/scripts
Note:Stop the Concurrent manager services on both the apps node and than run cmclean on any one apps node.
Note:If we don't have cmclean.sql script than we can download and copy it to any of the application node.
TESTEBS2:/product/app/TESTDB/inst/apps/TESTEBS2/admin/scripts>sqlplus
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Jan 5 10:07:50 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: apps
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @cmclean.sql
DOC>
DOC>WARNING : Do not run this script without explicit instructions
DOC>from Oracle Support
DOC>
DOC>
DOC>*** Make sure that the managers are shut down ***
DOC>*** before running this script ***
DOC>
DOC>*** If the concurrent managers are NOT shut down, ***
DOC>*** exit this script now !! ***
DOC>
DOC>#
If you wish to continue type the word 'dual': dual
-----------------------------------------------------------------------
-- Updating invalid process status codes in FND_CONCURRENT_PROCESSES
Manager short name Process id Status code
-------------------- ---------- ------------
FNDICM 606912 A
FNDCPOPP 606924 U
FNDOPP18288 606929 U
606930 U
4 rows updated.
-----------------------------------------------------------------------
-- Updating running processes in FND_CONCURRENT_QUEUES
-- Setting running_processes = 0 and max_processes = 0 for all managers
51 rows updated.
-----------------------------------------------------------------------
-- Updating invalid control_codes in FND_CONCURRENT_QUEUES
0 rows updated.
51 rows updated.
-----------------------------------------------------------------------
-- Updating any Running or Terminating requests to Completed/Error
0 rows updated.
-----------------------------------------------------------------------
-- Updating any Runalone flags to 'N'
Updated 0 rows of runalone_flag in fnd_conflicts_domain to 'N'
-----------------------------------------------------------------------
Updates complete.
Type commit now to commit these updates, or rollback to cancel.
-----------------------------------------------------------------------
SQL> commit;
Commit complete.
Step f:Stop the apps tier servies on node1 and node2:
ebstest:applmgr::/u01/TESTDB/apps/comn/admin/scripts/TESTDB_ebstest>./adstpall.sh
You are running adstpall.sh version 115.22
Enter the APPS username: apps
Step f:Make sure no 'applmgr' processes is running on node1 and node2
Make sure no 'applmgr' processes or else kill it with kill -9 pid.
On both the nodes check the FNDLIBR and FNDSM processes.
Node 1:Nodeapp01:
-----------------
applmgr@[Nodeapp01]-> ps -ef|grep appmgr
applmgr 4794 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4784 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4782 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4789 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4792 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4786 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
kill -9 4794 4784
applmgr@[Nodeapp01]-> ps -ef|grep applmgr
Node 2:Nodeapps02:
------------------
applmgr@[Nodeapp02]-> ps -ef|grep applmgr
applmgr 4794 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4784 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4782 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4789 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4792 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4786 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
kill -9 4794 4784
applmgr@[Nodeapp02]-> ps -ef|grep applmgr
Step g:Start apps listener on node1 and node2
Node 1:
-------------
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adalnctl.sh start
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adalnctl.txt for more information ...
Node 2:
--------
Node2 /product/app/TEST/inst/apps/TESTX2_icmpapp02/admin/scripts >./adalnctl.sh start
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX2_icmpapp02/logs/appl/admin/log/adalnctl.txt for more information ...
Step h:Start the concurrent manager from node 1(Nodeapp01)
Since TEST_R12 is having PCP setup start the Concurrent managers from node1(Primary node)
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adcmctl.sh start
You are running adcmctl.sh version 120.17.12010000.5
Enter the APPS username : APPS
Enter the APPS password :
Starting concurrent manager for TEST_CM1 ...
Starting TEST_0216@TEST_CM1 Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
Step i:Start applications using adstrtal.sh
ebstest:applmgr::/u01/TESTDB/apps/comn/admin/scripts/TESTDB_ebstest>./adstrtal.sh
You are running adstrtal.sh version 115.22
Step 6:After applying PATCH:
Step a:Verify the patch is applied successfully:
SQL> select name from v$database;
NAME
---------
TESTDB
SQL> select bug_number,creation_date from ad_bugs where bug_number='8845580';
BUG_NUMBER CREATION_DATE
------------------------------ ---------------
5549427 12-FEB-13
Note 1:We run cmclean after clonning also to make sure the node name is updated in the FND_NODES Table correctly
Note 2:In Oracle 11i the cmclean scripts can be found in $COMMON_TOP/admin/scipts/TESTDB_ebstest
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;
OWNER COUNT(*)
------------------------------ ----------
SYS 1
TEST_USER1 2
TEST_USER2 5
APPS 22
Step b:After finishing the installation of this patch, please perform the
normal post-install steps like :
1. (Re)compiling all the database objects
2. (Re)generating message files
3. (Re)generating forms etc.
4. Clear the middle tier cache for Oracle Incentive
Compensation.
5. Bouncing the middle tier by following steps mentioned in Step 5.
Note 1:We can use 'adadmin' utility for Completing Step 2 and Step 3.
Note 2:For clearing the Middle tier cache use the below linK:
http://rafioracledba.blogspot.com/2014/01/how-to-clear-cache-for-oracle-ebs-r12.html
Step c:Check the version of the file after it is applied by verifying the .lgi (log information file)
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>echo $CN_TOP
/product/app/TEST/apps/apps_st/appl/cn/12.0.0
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>grep '$Header' $CN_TOP/patch/115/sql/cnvrpgps.pls
/* $Header: cnvrpgps.pls 120.3.12010000.1 2008/07/24 11:06:30 appldev ship $ */
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>grep '$Header' $CN_TOP/patch/115/sql/cnvrpgpb.pls
/* $Header: cnvrpgpb.pls 120.11.12010000.3 2009/10/09 23:42:54 rnagired ship $ */
Step d:Do the Health Check of Oracle EBS Application
Login TESTDB application by using Home page URL
Note :We can get HOME page URL by using below query:
SQL>Select Home_URL from icx_parameter;
http://ebstest.abccomp.com:8035 with sysadmin/welcome123
Health check completed successfully by submitting active user Concurrent request REQUEST ID 28758820.
Step e:Intimate end User
Make sure you intimate the end User or release your application to the end User.
Enjoy Apps DBA tasks.
Best regards,
Rafi.
Note:Check www.orasols.com for the services we offer.
For a multi-node system with a shared application tier file system patching time will be reduce,as we apply patch only once – on the primary node.This ensures minimal downtime as all adpatch actions are performed only once.
Below are the steps which I follow to apply patch to Oracle EBS R12 Applications for 2 nodes Applications where SHARED APPL_TOP is enabled
along with PCP setup.This is RAC Oracle 11g Database.
We need to find out the primary node in the PCP(Parallel concurrent Processing) Concurrent managers set up.
Below link can be used for it:
http://rafioracledba.blogspot.com/search?q=primary
Step 1: Before applying patch:(check invalid objects in DB):
SQL> select name from v$database;
NAME
---------
TESTDB
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;
OWNER COUNT(*)
------------------------------ ----------
PUBLIC 1
APPS 158
SYS 3
Step 2:Enable Maintainance mode
ebstest:applmgr::/home/applmgr>echo $TWO_TASK
TESTDB
Use 'adadmin' to enable maintainance mode before patching.
5. Change Maintenance Mode
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Backing up restart files, if any......Done.
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Step 3:Applying patch using 'adpatch'(auto patch utility):Note:Review the readme file twice before proceeding with 'adpatch' session.
It is very important to review the readme.txt in unix vi editor before applying applying patch
and follow the instruction as given in the readme.txt file and apply any pre-requistics patch
if required.autoconfig run also not required unless it is specified after patch installation in readme.txt file.
Go to the patch top directory,where all driver and required ldt files are present with the application
filesystem owner,makes sure all files have read,write and execute permission.
As described below:
ebstest1:applmgr::/stage/patches/8845580>ls -altr
total 12432
-rwxrwxrwx 1 applmgr dba 2931 Oct 29 2007 u8845580.drv
-rwxrwxrwx 1 applmgr dba 1173 Oct 29 2007 f8845580.ldt
-rwxrwxrwx 1 applmgr dba 6323692 Oct 29 2007 b8845580.ldt
-rwxrwxrwx 1 applmgr dba 37 Oct 29 2007 marker1.txt
-rwxrwxrwx 1 applmgr dba 2852 Oct 29 2007 README.txt
-rwxrwxrwx 1 applmgr dba 5502 Oct 29 2007 README.html
drwxrwxrwx 5 applmgr dba 256 Feb 21 01:21 po
drwxrwxrwx 54 root dba 12288 Feb 21 01:21 ..
drwxr-xr-x 3 applmgr dba 256 Feb 21 01:21 .
ebstest:applmgr::/stage/patches/8845580>adpatch
Review the README for pre-requisite information.
Your default directory is '/d21/TESTDB/apps/appl'.
Is this the correct APPL_TOP [Yes] ?
Verify the log file after applying patch.Below is the 'adpatch' session.
ebstest1:/tmp/rafi/8845580>adpatch
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AutoPatch
Version 12.0.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.
Your default directory is '/product/app/TESTDB/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?
AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adpatch.log] : 8845580_05Jan2014.log
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [TESTDB] : TESTDB *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [ebstest2] : ebstest2 *
You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'TESTDB'
using ORACLE executables in '/product/app/TESTDB/apps/tech_st/10.1.2'.
Is this the correct database [Yes] ?
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Identifier for the current session is 44869
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/zfaprod.txt
does not exist for product "zfa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/zsaprod.txt
does not exist for product "zsa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
AutoPatch warning:
Product Data File
/product/app/TESTDB/apps/apps_st/appl/admin/jtsprod.txt
does not exist for product "jts".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [B.3]
Trying to obtain a lock...
Attempting to instantiate the current-view snapshot...
No baseline bug-fixes info available. Will attempt next time.
**************** S T A R T O F U P L O A D ****************
Start date: Sun Jan 05 2014 09:15:26
0 "left over" javaupdates.txt files uploaded to DB: Sun Jan 05 2014 09:15:26
0 patches uploaded from the ADPSV format patch history files: Sun Jan 05 2014 09:15:26
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Sun Jan 05 2014 09:15:26
****************** E N D O F U P L O A D ******************
End date: Sun Jan 05 2014 09:15:26
Enter the directory where your Oracle Applications patch has been unloaded
The default directory is [/tmp/rafi/8845580] :
Please enter the name of your AutoPatch driver file : u8845580.drv
Done with Invoker's Rights processing.
Telling workers to quit...
1 worker has quit. Waiting for 47 more.
All workers have quit.
Dropping FND_INSTALL_PROCESSES table...
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
AD_DEFERRED_JOBS table dropped.
Updating the checkfile repository if necessary...
Processing the last batch...
Done updating the checkfile repository...
Done running SQL scripts and EXEC commands.
Compiling invalid objects...
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 48 0 NONE FALSE
Number of invalid objects: 141
Getting list of invalid objects in APPS schema.
Invalid object reports are recorded in
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/44869_postenv.*
Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file
Skipping...
Generate forms for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file
Skipping...
Generate reports for Specified driver
since no such action is present for this driver file
Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file
Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file
Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.
Saving Patch History information to Database...
Trying to obtain a lock...
> Inserted 1 patch history records (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 0 action history records for this bug (total).
Gathering Statistics for AD_PATCH_HIST_TEMP
Done Gathering Statistics for AD_PATCH_HIST_TEMP
>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 0 action history records for this bug (total).
Updating the current-view snapshot...
Done saving Patch History information.
About to do IREP processing...
Attempting to process IREP files ...
Successfully processed IREP files.
Done IREP processing.
Copying applprod.tmp to applprod.txt (if needed)...
Did not need to copy applprod.tmp to applprod.txt.
Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
Did not need to copy admin/TESTDB/applterr.txt to admin/applterr.txt.
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 44869 adt44869
A job timing report has been generated for the current session.
You should check the file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/out/adt44869.lst
for details.
Purging timing information for prior sessions.
sqlplus -s APPS/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000
Done purging timing information for prior sessions.
AutoPatch is complete.
AutoPatch may have written informational messages to the file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/8845580_05Jan2014.lgi
Errors and warnings are listed in the log file
/product/app/TESTDB/apps/apps_st/appl/admin/TESTDB/log/8845580_05Jan2014.log
and in other log files in the same directory.
Step 4: Disable Maintainance mode again by using 'adadmin' utility:
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
Enter your choice [6] : 5
Change Maintenance Mode
----------------------------------------
Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Enter your choice [3] : 2
sqlplus -s &un_apps/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
Successfully disabled Maintenance Mode.
sqlplus -s &un_apps/***** @/product/app/TESTDB/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
Successfully disabled Maintenance Mode.
Step 5: Bounce application after applying patch :
Step 5 a:Stop the Concurrent Managers in PCP setup:
In the PCP set use the below steps to Stop the Concurrent Managers.
Identify the Primary node,In our case Nodeapp01 is the prmary node of PCP setup.
a) stop apps listener on node1(Nodeapp01)
=>APPS_TEST
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adalnctl.sh stop
adalnctl.sh version 120.3
Shutting down listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adalnctl.txt for more information ...
b)Stop apps listener on node2(Nodeapp02)
Node2 /product/app/TEST/inst/apps/TESTX2_icmpapp02/admin/scripts >./adalnctl.sh stop
adalnctl.sh version 120.3
Shutting down listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX2_icmpapp02/logs/appl/admin/log/adalnctl.txt for more information ...
c)Stop the apps concurrent managers from node1
===============================================
SinceTEST_R12is having PCP setup,stop the Concurrent managers from node1(Primary node)
Node1:Nodeapp01
/product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adcmctl.sh stop
You are running adcmctl.sh version 120.17.12010000.5
Enter the APPS username : APPS
Enter the APPS password :
Shutting down concurrent managers for TEST_CM2 ...
ORACLE Password:
Submitted request 2532852 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adcmctl.txt for more information ...
step d): Check and Kill all processes by finding the concurrent processes:
On Node 1 and Node 2 make sure no concurrent manager process is running.
Node1: Nodeapp01
ps -ef|grep FNDLIBR|grep applmgr
ps -ef|grep FNDSM|grep applmgr
kill -9 pid
Node 2: icmpapp02
Node2: icmpapp02
ps -ef|grep FNDLIBR|grep applmgr
ps -ef|grep FNDSM|grep applmgr
kill -9 pid
Step e:Run cmclean.sql
Run cmclean.sql from application node by going to $ADMIN_SCRIPTS_HOME or $INST_TOP/admin/scripts
Note:Stop the Concurrent manager services on both the apps node and than run cmclean on any one apps node.
Note:If we don't have cmclean.sql script than we can download and copy it to any of the application node.
TESTEBS2:/product/app/TESTDB/inst/apps/TESTEBS2/admin/scripts>sqlplus
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Jan 5 10:07:50 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: apps
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @cmclean.sql
DOC>
DOC>WARNING : Do not run this script without explicit instructions
DOC>from Oracle Support
DOC>
DOC>
DOC>*** Make sure that the managers are shut down ***
DOC>*** before running this script ***
DOC>
DOC>*** If the concurrent managers are NOT shut down, ***
DOC>*** exit this script now !! ***
DOC>
DOC>#
If you wish to continue type the word 'dual': dual
-----------------------------------------------------------------------
-- Updating invalid process status codes in FND_CONCURRENT_PROCESSES
Manager short name Process id Status code
-------------------- ---------- ------------
FNDICM 606912 A
FNDCPOPP 606924 U
FNDOPP18288 606929 U
606930 U
4 rows updated.
-----------------------------------------------------------------------
-- Updating running processes in FND_CONCURRENT_QUEUES
-- Setting running_processes = 0 and max_processes = 0 for all managers
51 rows updated.
-----------------------------------------------------------------------
-- Updating invalid control_codes in FND_CONCURRENT_QUEUES
0 rows updated.
51 rows updated.
-----------------------------------------------------------------------
-- Updating any Running or Terminating requests to Completed/Error
0 rows updated.
-----------------------------------------------------------------------
-- Updating any Runalone flags to 'N'
Updated 0 rows of runalone_flag in fnd_conflicts_domain to 'N'
-----------------------------------------------------------------------
Updates complete.
Type commit now to commit these updates, or rollback to cancel.
-----------------------------------------------------------------------
SQL> commit;
Commit complete.
Step f:Stop the apps tier servies on node1 and node2:
ebstest:applmgr::/u01/TESTDB/apps/comn/admin/scripts/TESTDB_ebstest>./adstpall.sh
You are running adstpall.sh version 115.22
Enter the APPS username: apps
Step f:Make sure no 'applmgr' processes is running on node1 and node2
Make sure no 'applmgr' processes or else kill it with kill -9 pid.
On both the nodes check the FNDLIBR and FNDSM processes.
Node 1:Nodeapp01:
-----------------
applmgr@[Nodeapp01]-> ps -ef|grep appmgr
applmgr 4794 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4784 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4782 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4789 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4792 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4786 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
kill -9 4794 4784
applmgr@[Nodeapp01]-> ps -ef|grep applmgr
Node 2:Nodeapps02:
------------------
applmgr@[Nodeapp02]-> ps -ef|grep applmgr
applmgr 4794 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4784 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4782 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4789 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4792 1 0 20:16:05 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
applmgr 4786 1 0 20:16:04 ? 0:01 FNDLIBR FND Concurrent_Processor MANAGE OLOGIN="APPS/ZGB44E179A7BC94375178D975C
kill -9 4794 4784
applmgr@[Nodeapp02]-> ps -ef|grep applmgr
Step g:Start apps listener on node1 and node2
Node 1:
-------------
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adalnctl.sh start
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX1_Nodeapp01/logs/appl/admin/log/adalnctl.txt for more information ...
Node 2:
--------
Node2 /product/app/TEST/inst/apps/TESTX2_icmpapp02/admin/scripts >./adalnctl.sh start
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_TEST.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /product/app/TEST/inst/apps/TESTX2_icmpapp02/logs/appl/admin/log/adalnctl.txt for more information ...
Step h:Start the concurrent manager from node 1(Nodeapp01)
Since TEST_R12 is having PCP setup start the Concurrent managers from node1(Primary node)
Node1 /product/app/TEST/inst/apps/TESTX1_Nodeapp01/admin/scripts >./adcmctl.sh start
You are running adcmctl.sh version 120.17.12010000.5
Enter the APPS username : APPS
Enter the APPS password :
Starting concurrent manager for TEST_CM1 ...
Starting TEST_0216@TEST_CM1 Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
Step i:Start applications using adstrtal.sh
ebstest:applmgr::/u01/TESTDB/apps/comn/admin/scripts/TESTDB_ebstest>./adstrtal.sh
You are running adstrtal.sh version 115.22
Step 6:After applying PATCH:
Step a:Verify the patch is applied successfully:
SQL> select name from v$database;
NAME
---------
TESTDB
SQL> select bug_number,creation_date from ad_bugs where bug_number='8845580';
BUG_NUMBER CREATION_DATE
------------------------------ ---------------
5549427 12-FEB-13
Note 1:We run cmclean after clonning also to make sure the node name is updated in the FND_NODES Table correctly
Note 2:In Oracle 11i the cmclean scripts can be found in $COMMON_TOP/admin/scipts/TESTDB_ebstest
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;
OWNER COUNT(*)
------------------------------ ----------
SYS 1
TEST_USER1 2
TEST_USER2 5
APPS 22
Step b:After finishing the installation of this patch, please perform the
normal post-install steps like :
1. (Re)compiling all the database objects
2. (Re)generating message files
3. (Re)generating forms etc.
4. Clear the middle tier cache for Oracle Incentive
Compensation.
5. Bouncing the middle tier by following steps mentioned in Step 5.
Note 1:We can use 'adadmin' utility for Completing Step 2 and Step 3.
Note 2:For clearing the Middle tier cache use the below linK:
http://rafioracledba.blogspot.com/2014/01/how-to-clear-cache-for-oracle-ebs-r12.html
Step c:Check the version of the file after it is applied by verifying the .lgi (log information file)
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>echo $CN_TOP
/product/app/TEST/apps/apps_st/appl/cn/12.0.0
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>grep '$Header' $CN_TOP/patch/115/sql/cnvrpgps.pls
/* $Header: cnvrpgps.pls 120.3.12010000.1 2008/07/24 11:06:30 appldev ship $ */
EBSTtest1:/product/app/TEST/inst/apps/TEST_EBSTtest1/admin/scripts>grep '$Header' $CN_TOP/patch/115/sql/cnvrpgpb.pls
/* $Header: cnvrpgpb.pls 120.11.12010000.3 2009/10/09 23:42:54 rnagired ship $ */
Step d:Do the Health Check of Oracle EBS Application
Login TESTDB application by using Home page URL
Note :We can get HOME page URL by using below query:
SQL>Select Home_URL from icx_parameter;
http://ebstest.abccomp.com:8035 with sysadmin/welcome123
Health check completed successfully by submitting active user Concurrent request REQUEST ID 28758820.
Step e:Intimate end User
Make sure you intimate the end User or release your application to the end User.
Enjoy Apps DBA tasks.
Best regards,
Rafi.
Note:Check www.orasols.com for the services we offer.
