First Upgrade R12.1.3 to R12.2.0 After that Upgrade R12.2.0 to R12.2.4..
Step:-1
Upgrade Oracle EBS R12.1.3 to R12.2.0
http://sujeetdba.blogspot.in/2015/07/upgrade-oracle-ebs-r1213-to-r1220.html
Step:-2
Upgrade Oracle EBS R12.2.0 to R12.2.4
- Oracle strongly recommends that you always obtain the latest OPatch utility available from My Oracle Support via Patch 6880880.
- Technology bug fixes can be provided by different patch types: for example, Bundle Patch, Merge Patch, and Database Patch Set Update. A given patch may include more than one fix.
- In certain cases, you may be able to obtain the recommended technology patches as part of a set of patches (such as a Critical Patch Update, Database Patch Set Update, or Exadata Bundle) that includes them.
- Some technology bug fixes such as Daylight Saving may have a later version that can be installed as an alternative.
- If you see a notice that a patch is obsolete or superseded, apply the replacement patch.
- The installation path chosen determines which additional patches need to be applied:
- For installations that used a startCD which was also used to install the Oracle Database, you only need to apply patches that were made available in any later startCDs.
- For installations that used a startCD which was not used to create the Oracle E-Business Suite Release 12.2 Database (an existing Oracle Database was used), you need to obtain and install all the patches listed in Section 2, Table 1.
- More information on patching the technology Oracle Homes is available in My Oracle Support Knowledge Document 1355068.1.
- You must ensure that all technology patches are fully applied. Refer to each individual patch readme file for additional details on how to apply that patch; this includes post-install steps that must be run, and any known warnings that can be ignored.
- In the event of a patch failure that cannot be resolved, you must contact Oracle Support for assistance.
Environment: Oracle Enterprise Linux 6.5 (64-Bit)
EBS Version : Oracle EBS R12.2.0 (using start CD 12.2.0.48)
EBS Version : Oracle EBS R12.2.0 (using start CD 12.2.0.48)
Database – 11.2.0.3
Architecture – Single Node
RAM:- 20 GB
Hard-disk:- 2 TB <Dell server>
CPU:- 6
Oracle EBS using start CD R12.2.0.48 then you need to Install minimum number of patches in order to upgrade to R12.2.4.
Step:1
we have need to apply the below patches sequence according to Doc. ID 1594274.1
Note:- Before starting database upgrade, please confirm the below steps.
1.) Application should be down.
2.) Database should be down.
3.) export PATH=$ORACLE_HOME/OPatch:$PATH
4.) which opatch
5.) Skip all those patch which are already applied
check by below command:
$ opatch lsinventory
DATABASE Patch 12.2.0.48 & not included in any startCD
Install Oracle RDBMS patches:
[ora@sujeet 16989137]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/ora_test/11.2.0
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/16989137_Oct_28_2014_14_29_47/apply2014-10-28_14-29-47PM_1.log
Applying interim patch '16989137' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Backing up files...
Patching component oracle.ctx, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Patch 16989137 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/16989137_Oct_28_2014_14_29_47/apply2014-10-28_14-29-47PM_1.log
OPatch succeeded.
[ora@sujeet 17875948]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/17875948_Oct_28_2014_14_33_15/apply2014-10-28_14-33-15PM_1.log
Applying interim patch '17875948' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
Interim patch 17875948 is a superset of the patch(es) [ 16587934 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given
patch.
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
y
User Responded with: Y
Backing up files...
Rolling back interim patch '16587934' from OH
'/u01/ora_test/11.2.0'
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
RollbackSession removing interim patch '16587934' from
inventory
OPatch back to application of the patch '17875948' after
auto-rollback.
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Patch 17875948 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/17875948_Oct_28_2014_14_33_15/apply2014-10-28_14-33-15PM_1.log
OPatch succeeded.
Step:3
[ora@sujeet 17875948]$
[ora@sujeet 17912217]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/ora_test/11.2.0
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/17912217_Oct_28_2014_14_38_04/apply2014-10-28_14-38-04PM_1.log
Applying interim patch '17912217' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patch 17912217 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/17912217_Oct_28_2014_14_38_04/apply2014-10-28_14-38-04PM_1.log
OPatch succeeded.
Step:4
[ora@sujeet 17912217]$
[ora@sujeet 18419770]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/ora_test/11.2.0
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18419770_Oct_28_2014_14_40_02/apply2014-10-28_14-40-02PM_1.log
Applying interim patch '18419770' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patch 18419770 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18419770_Oct_28_2014_14_40_02/apply2014-10-28_14-40-02PM_1.log
OPatch succeeded.
Step:5
[ora@sujeet 18419770]$
[ora@sujeet 18614015]$ pwd
/u01/patch_stage/database/DB/18614015
[ora@sujeet 18614015]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/ora_test/11.2.0
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18614015_Oct_28_2014_14_42_00/apply2014-10-28_14-41-59PM_1.log
Applying interim patch '18614015' to OH '/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Backing up files...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Patch 18614015 successfully applied
Log file location: /u01/ora_test/11.2.0/cfgtoollogs/opatch/18614015_Oct_28_2014_14_42_00/apply2014-10-28_14-41-59PM_1.log
OPatch succeeded.
Step:6
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/ora_test/11.2.0
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location : /u01/ora_test/11.2.0/cfgtoollogs/opatch/18685209_Oct_28_2014_14_44_11/apply2014-10-28_14-44-10PM_1.log
Applying interim patch '18685209' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patch 18685209 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18685209_Oct_28_2014_14_44_11/apply2014-10-28_14-44-10PM_1.log
OPatch succeeded.
Step:7
As per footnote-11 patch "18259911" was Installed.
So we need to rollback this patch first Installing patch "19078951".
[ora@sujeet DB]$ opatch lsinventory | grep 18259911
Patch 18259911 : applied on Mon Oct 27 21:54:20 AST 2014
[ora@sujeet DB]$ opatch lsinventory | grep 17461865
[ora@sujeet DB]$ opatch rollback -id 18259911
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version :
11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18259911_Oct_28_2014_14_53_03/rollback2014-10-28_14-53-03PM_1.log
RollbackSession rolling back interim patch '18259911' from
OH '/u01/ora_test/11.2.0'
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '18259911' from
inventory
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/18259911_Oct_28_2014_14_53_03/rollback2014-10-28_14-53-03PM_1.log
OPatch succeeded.
[ora@sujeet 19078951]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/ora_test/11.2.0/oraInst.loc
OPatch version :
11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location :
/u01/ora_test/11.2.0/cfgtoollogs/opatch/19078951_Oct_28_2014_15_00_03/apply2014-10-28_15-00-03PM_1.log
Applying interim patch '19078951' to OH
'/u01/ora_test/11.2.0'
Verifying environment and performing prerequisite checks...
Interim patch 19078951 is a superset of the patch(es) [ 14751895 12849688 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given
patch.
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/ora_test/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Rolling back interim patch '14751895' from OH
'/u01/ora_test/11.2.0'
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
RollbackSession removing interim patch '14751895' from
inventory
Rolling back interim patch '12849688' from OH
'/u01/ora_test/11.2.0'
Patching component oracle.rdbms, 11.2.0.3.0...
RollbackSession removing interim patch '12849688' from
inventory
OPatch back to application of the patch '19078951' after
auto-rollback.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patch 19078951 successfully applied
Log file location:
/u01/ora_test/11.2.0/cfgtoollogs/opatch/19078951_Oct_28_2014_15_00_03/apply2014-10-28_15-00-03PM_1.log
OPatch succeeded.
Perform post Installation of all patches after
applying all RDBMS Patches:
SQL> @?/sqlpatch/16989137/postinstall.sql
Session altered.
SQL> @?/sqlpatch/17875948/postinstall.sql
Package body created.
No errors.
Calling rdbms/admin/prvtmet2.plb on 28-OCT-14
03.14.49.012276 PM +03:00
SQL>
@?/sqlpatch/18614015/postinstall.sql
Calling rdbms/admin/prvtutil.plb on 28-OCT-14
03.24.58.515625 PM +03:00
Install Oracle Fusion Middleware 11.1.1.6 patches
Set oracle home for FMW (11.1.1.6)
[appl@sujeet ~]$ export
ORACLE_HOME=/u01/appl_test/fs1/FMW_Home/webtier
[appl@sujeet ~]$ export
PATH=/u01/appl_test/fs1/FMW_Home/webtier/OPatch:$PATH
Verify the opatch is set from the proper Oracle Home
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/appl_test/fs1/FMW_Home/webtier
Central Inventory : /u01/ora_prod/oraInventory
from :
/u01/appl_test/fs1/FMW_Home/webtier/oraInst.loc
OPatch version :
11.1.0.9.9
OUI version :
11.1.0.9.0
Log file location :
/u01/appl_test/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2014-10-28_16-05-24PM_1.log
OPatch detects the Middleware Home as
"/u01/appl_test/fs1/FMW_Home"
Lsinventory Output file location :
/u01/appl_test/fs1/FMW_Home/webtier/cfgtoollogs/opatch/lsinv/lsinventory2014-10-28_16-05-24PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle WebTier and Utilities CD
11.1.1.6.0
There are 1 products installed in this Oracle Home.
Interim patches (7) :
Patch 16199894 : applied on Tue Oct 28 02:29:40 AST 2014
Unique Patch ID:
16066707
Created on 6 Mar
2013, 12:42:03 hrs US/Pacific
Bugs fixed:
16199894
Patch 14616819 : applied on Tue Oct 28 02:29:23 AST 2014
Unique Patch ID:
15565088
Created on 11 Oct
2012, 12:30:28 hrs US/Pacific
Bugs fixed:
14616819
Patch 10638758 : applied on Tue Oct 28 02:29:05 AST 2014
Unique Patch ID:
14860855
Created on 15 May
2012, 05:32:01 hrs PST8PDT
Bugs fixed:
10638758
Patch 17325559 : applied on Tue Oct 28 02:28:46 AST 2014
Unique Patch ID:
16698102
Created on 19 Aug
2013, 16:11:34 hrs US/Pacific
Bugs fixed:
16856341,
13837241, 13025456, 14110089, 16021044, 14386112, 14345153
14003476,
12959202
Patch 13643211 : applied on Tue Oct 28 02:28:27 AST 2014
Unique Patch ID:
14814441
Created on 2 May
2012, 11:34:23 hrs
Bugs fixed:
13588565,
13104787, 13637410
Patch 12949905 : applied on Tue Oct 28 02:28:07 AST 2014
Unique Patch ID:
14148563
Created on 29 Sep
2011, 11:48:28 hrs PST8PDT
Bugs fixed:
12949905
Patch 7695070 : applied on Tue Oct 28 02:27:50 AST 2014
Unique Patch ID:
11421601
Created on 16 Jun
2009, 21:13:15 hrs PST8PDT
Bugs fixed:
7695070
OPatch succeeded.
Apply patches on 11.1.1.6 FMW Home
[appl@sujeet ~]$ cd
/u01/patch_stage/Apps/Pre_REQS_Apps/17639414
[appl@sujeet 17639414]$ ls
etc files README.txt
[appl@sujeet 17639414]$ opatch apply -jre
$ORACLE_HOME/jdk/jre
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/appl_test/fs1/FMW_Home/webtier
Central Inventory : /u01/ora_prod/oraInventory
from :
/u01/appl_test/fs1/FMW_Home/webtier/oraInst.loc
OPatch version :
11.1.0.9.9
OUI version :
11.1.0.9.0
Log file location : /u01/appl_test/fs1/FMW_Home/webtier/cfgtoollogs/opatch/17639414_Oct_28_2014_16_06_40/apply2014-10-28_16-06-39PM_1.log
OPatch detects the Middleware Home as
"/u01/appl_test/fs1/FMW_Home"
Applying interim patch '17639414' to OH
'/u01/appl_test/fs1/FMW_Home/webtier'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Backing up files...
Patching component oracle.as.clone.ohs, 11.1.1.6.0...
Verifying the update...
Patch 17639414 successfully applied
Log file location:
/u01/appl_test/fs1/FMW_Home/webtier/cfgtoollogs/opatch/17639414_Oct_28_2014_16_06_40/apply2014-10-28_16-06-39PM_1.log
OPatch succeeded.
[appl@sujeet 18989444]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/appl_test/fs1/FMW_Home/oracle_common
Central Inventory : /u01/ora_prod/oraInventory
from :
/u01/appl_test/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version :
11.1.0.9.9
OUI version :
11.1.0.9.0
Log file location :
/u01/appl_test/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/18989444_Oct_28_2014_16_12_31/apply2014-10-28_16-12-31PM_1.log
OPatch detects the Middleware Home as
"/u01/appl_test/fs1/FMW_Home"
Applying interim patch '18989444' to OH
'/u01/appl_test/fs1/FMW_Home/oracle_common'
Verifying environment and performing prerequisite checks...
Interim patch 18989444 is a superset of the patch(es) [ 13947608 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given
patch.
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/u01/appl_test/fs1/FMW_Home/oracle_common')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Rolling back interim patch '13947608' from OH
'/u01/appl_test/fs1/FMW_Home/oracle_common'
Patching component oracle.jrf.opss, 11.1.1.6.0...
RollbackSession removing interim patch '13947608' from
inventory
OPatch back to application of the patch '18989444' after
auto-rollback.
Patching component oracle.jrf.opss, 11.1.1.6.0...
Verifying the update...
Patch 18989444 successfully applied
Log file location:
/u01/appl_test/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/18989444_Oct_28_2014_16_12_31/apply2014-10-28_16-12-31PM_1.log
OPatch succeeded.
[appl@sujeet 19462638]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/appl_test/fs1/FMW_Home/oracle_common
Central Inventory : /u01/ora_prod/oraInventory
from : /u01/appl_test/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version :
11.1.0.9.9
OUI version :
11.1.0.9.0
Log file location :
/u01/appl_test/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/19462638_Oct_28_2014_16_16_48/apply2014-10-28_16-16-47PM_1.log
OPatch detects the Middleware Home as
"/u01/appl_test/fs1/FMW_Home"
Applying interim patch '19462638' to OH
'/u01/appl_test/fs1/FMW_Home/oracle_common'
Verifying environment and performing prerequisite checks...
Interim patch 19462638 is a superset of the patch(es) [ 14588599 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given
patch.
All checks passed.
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Backing up files...
Rolling back interim patch '14588599' from OH
'/u01/appl_test/fs1/FMW_Home/oracle_common'
Patching component oracle.as.common.clone, 11.1.1.6.0...
Updating jar file
"/u01/appl_test/fs1/FMW_Home/oracle_common/jlib/cloningclient.jar"
with
"/u01/appl_test/fs1/FMW_Home/oracle_common/.patch_storage/14588599_Sep_27_2012_15_42_28/files//jlib/cloningclient.jar/oracle/as/clone/cloner/component/j2ee/constants/J2EEIntrospectorConstants.class"
Updating jar file
"/u01/appl_test/fs1/FMW_Home/oracle_common/jlib/cloningclient.jar"
with
"/u01/appl_test/fs1/FMW_Home/oracle_common/.patch_storage/14588599_Sep_27_2012_15_42_28/files//jlib/cloningclient.jar/oracle/as/clone/cloner/component/j2ee/introspector/SecurityPolicyIntrospector.class"
RollbackSession removing interim patch '14588599' from
inventory
OPatch back to application of the patch '19462638' after
auto-rollback.
Verifying the update...
Patch 19462638 successfully applied
Log file location:
/u01/appl_test/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/19462638_Oct_28_2014_16_16_48/apply2014-10-28_16-16-47PM_1.log
OPatch succeeded.
Set the Environment variable for 10.1.2 ORACLE HOME
/u01/patch_stage/Apps/Pre_REQS_Apps/18186693
[appl@sujeet 18186693]$ opatch apply
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the
OPatch/docs
directory for usage. For information about the latest OPatch
and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support
(https://myoraclesupport.oracle.com)
Oracle Home
: /u01/appl_test/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u01/appl_test/fs1/EBSapps/10.1.2/inventory
Central Inventory
: /u01/ora_prod/oraInventory
from : /etc/oraInst.loc
OUI location
: /u01/appl_test/fs1/EBSapps/10.1.2/oui
OUI shared library
: /u01/appl_test/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInstaller.so
Java location
: /u01/appl_test/fs1/EBSapps/10.1.2/jdk/jre/bin/java
Log file location
: /u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage//*.log
Creating log file
"/u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage/18186693/Apply_18186693_10-28-2014_15-40-55.log"
Invoking fuser to check for active processes.
Patch "18186693" overlays " 14825718 ".
Conflict check between them is skipped.
Subset patches: 17303472,
The fixes for Patch 17303472, are included in the patch currently
being installed (18186693).
OPatch will roll back the subset patch(es) and
install the new patch (18186693).
Provide your email address to be informed of security
issues, install and
initiate Oracle Configuration Manager. Easier for you if you
use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for
details.
Email address/User Name:
You have not provided an email address for notification of
security issues.
Do you wish to remain uninformed of security issues ([Y]es,
[N]o) [N]: Y
Oracle Configuration Manager has been installed but not
configured. OCM enables
Oracle to provide superior, proactive support for our
customers. Oracle
strongly recommends customers configure OCM. To complete the
configuration of
OCM, refer to the OCM Installation and Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory
and will patch the local system only.
Please shut down Oracle instances running out of this
ORACLE_HOME
(Oracle Home = /u01/appl_test/fs1/EBSapps/10.1.2)
Is this system ready for updating?
Please respond Y|N >
Y
Rolling back patch 17303472...
Creating log file
"/u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage/17303472/RollBack_17303472_10-28-2014_15-41-47.log"
Rolling back with all-node mode.
OPatch detected non-cluster Oracle Home from the inventory
and will patch the local system only.
Oracle instances have been shut down, proceeding with
auto-rollback.
Removing patch 17303472...
Restoring archive files...
OPatch found "/u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage/17303472/lib/ixdn.o_libix.a_opatch_new_17303472". So, deleting the file from the archive.
OPatch found
"/u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage/17303472/lib/ixvw.o_libix.a_opatch_new_17303472". So, deleting the file from the archive.
OPatch found
"/u01/appl_test/fs1/EBSapps/10.1.2/.patch_storage/17303472/lib/ixwn.o_libix.a_opatch_new_17303472". So, deleting the file from the archive.
Restoring copied files...
Running make for target
sharedlib.
Running make for target
install.
Running make for target sharedlibs.
Running make for target install.
Inventory is good and does not have any dangling patches.
Backing up comps.xml ...
OPatch succeeded.
Copy and unzip Patches in weblogic server
"cache_dir"
[appl@sujeet cache_dir]$ cp
/u01/patch_stage/Apps/Pre_REQS_Apps/p17893334_1036_Generic.zip .
[appl@sujeet cache_dir]$ ls
32I2.jar
LL4G.jar
patch-catalog_17260.xml patch-catalog_18408.xml patch-catalog_19461.xml S9MN.jar
YHJK.jar
CIH8.jar
p17893334_1036_Generic.zip
patch-catalog_18030.xml
patch-catalog_19037.xml
patch-catalog_20352.xml
TTEM.jar YIJF.jar
D33T.jar
patch-catalog_16936.xml
patch-catalog_18239.xml
patch-catalog_19345.xml
patch-catalog.xml VFS8.jar
[appl@sujeet cache_dir]$
[appl@sujeet cache_dir]$ unzip p17893334_1036_Generic.zip
Archive:
p17893334_1036_Generic.zip
inflating:
7FC9.jar
inflating: README.txt
inflating:
patch-catalog_21169.xml
[appl@sujeet cache_dir]$
Install "7FC9.jar" jar file on weblogic server
using bsu
- Set proper GUI enable display variable
- Execute script "bsu.sh" from FMW_HOME/utils/bsu
This is the list of patch which is not applied on Server. Install this patch on weblogic Server.
The Patch has been successfully Installed
Install EBS Application patches:
All application patches should be Installed using "adop" online patching utility.
Install patch "17204589"
[applebs@erpnode3 Pre_REQS_Apps]$ cp -rf 17204589 /u01/appl_test/fs_ne/EBSapps/patch
[applebs@erpnode3 Pre_REQS_Apps]$ adop phase=apply patches=17204589 hotpatch=yes
Enter the APPS password: *****
Enter the SYSTEM password: *****
Enter the WLSADMIN password: ******
Please wait. Validating credentials...
Enter the RUN file system context file name [/u01/appl_test/fs1/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml]:
Install patch "18283295"
Run "adgrants.sql" script on APPS schema from patch directory before Installing the patch.
[oraebs@sujeet db_scripts]$ cp /u01/EBS_patches/Apps_pre_1224/18283295/admin/adgrants.sql .
[oraebs@sujeet db_scripts]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 4 21:13:14 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> @adgrants.sql APPS
Connected.
---------------------------------------------------
--- adgrants.sql started at 2014-11-04 21:13:26
Creating PL/SQL profiler objects.
Package created.
Package body created.
Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Install all remaining patches with adop patch utility.
Execute adop fs_clone to synchronize file systems
- Source environment variable for run file system
- Make sure admin server is up and running
[appl@sujeet appl_test]$ ls
EBSapps.env fs1 fs2 fs_ne
[appl@sujeet appl_test]$ . EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/appl_test/fs1/EBSapps/appl
PATCH File System : /u01/appl_test/fs2/EBSapps/appl
Non-Editioned File System : /u01/appl_test/fs_ne
DB Host: sujeet.oralabs.com Service/SID: test
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[appl@sujeet appl_test]$ adop phase=fs_clone
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/appl_test/fs1/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
PATCH file system context file: /u01/appl_test/fs2/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
Execute SYSTEM command : df /u01/appl_test/fs2
adop phase=fs_clone - Completed Successfully
Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/7/adop_20141105_201909.log
adop exiting with status = 0 (Success)
Step:21
Upgrade:
- Shutdown all application services
- Perform full application and database backup
- Install patch in a "downtime" mode
[appl@sujeet scripts]$ adadminsrvctl.sh stop
You are running adadminsrvctl.sh version 120.10.12020000.9
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Stopping WLS Admin Server...
Refer /u01/appl_test/fs1/inst/apps/test_erpnode3/logs/appl/admin/log/adadminsrvctl.txt for details
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u01/appl_test/fs1/inst/apps/test_erpnode3/logs/appl/admin/log/adadminsrvctl.txt for more information ...
[appl@sujeet scripts]$ adnodemgrctl.sh stop
You are running adnodemgrctl.sh version 120.11.12020000.11
Enter the WebLogic Admin password:
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /u01/appl_test/fs1/inst/apps/test_erpnode3/logs/appl/admin/log/adnodemgrctl.txt for more information ...
Check Release of existing system
Start Installation of patch. I have used 12 workers and you can use it according to available resources.
Step:22
[appl@sujeet patch]$ adop phase=apply apply_mode=downtime patches=17919161 workers=12
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/appl_test/fs1/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
PATCH file system context file: /u01/appl_test/fs2/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
Execute SYSTEM command : df /u01/appl_test/fs2
Worker count determination...
[END 2014/11/07 13:17:29] Generating Post Apply Reports
[END 2014/11/07 13:17:29] adzdoptl.pl run
adop phase=apply - Completed Successfully
Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/8/adop_20141106_182058.log
adop exiting with status = 0 (Success)
Step:23
After Successful Installation of Patch start all Application services
[appl@sujeet appl_test]$ . EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/appl_test/fs1/EBSapps/appl
PATCH File System : /u01/appl_test/fs2/EBSapps/appl
Non-Editioned File System : /u01/appl_test/fs_ne
DB Host: sujeet.oralabs.com Service/SID: test
Sourcing the RUN File System ...
[appl@sujeet appl_test]$ adstrtal.sh apps/apps
Execute cleanup and clone operations on file system
[appl@sujeet ~]$ adop phase=cleanup
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/appl_test/fs1/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
PATCH file system context file: /u01/appl_test/fs2/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
Execute SYSTEM command : df /u01/appl_test/fs2
Worker count determination...
[END 2014/11/08 06:56:19] adzdoptl.pl run
adop phase=cleanup - Completed Successfully
Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/8/adop_20141108_061727.log
adop exiting with status = 0 (Success)
Step:24
[appl@sujeet ~]$ adop phase=fs_clone
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/appl_test/fs1/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
PATCH file system context file: /u01/appl_test/fs2/inst/apps/test_erpnode3/appl/admin/test_erpnode3.xml
Execute SYSTEM command : df /u01/appl_test/fs2
Worker count determination...
Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[END 2014/11/08 12:45:52] adzdoptl.pl run
adop phase=fs_clone - Completed Successfully
Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/9/adop_20141108_070728.log
adop exiting with status = 0 (Success)
[appl@sujeet ~]$
The upgrade form 12.2.0 to 12.2.4 completed.
Step:25
Verify the version of applications after upgrade:
Post Upgrade:
- Install online help patch "17919162" using adop
- verify all application services are up and running
- check the status of managed serves
- Install online help patch "17919162" using adop
- verify all application services are up and running
- check the status of managed serves
References:
- Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1)
- Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
- Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
- Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
- Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1)
- Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
- Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
- Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
No comments:
Post a Comment