Oracle Apps DBA

My Photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Friday, 14 November 2014

[INS-21003] Installer has detected that an invalid inventory pointer location file was specified - Oracle 12c

I was installing Oracle 12.1.0.1 Database  software in a preparation of upgrading Oracle EBS R12.2 Database from version 11.2.0.3 to 12.1.0.1. When i started Installer from the stage location then it encountered error related to Inventory "[INS-21003] Installer has detected that an invalid inventory pointer location file was specified.."




Error Stack from the Installation log file:

INFO: Setting value for the property:id in the bean:configcmd
INFO: Setting value for the property:platformcmdmap in the bean:configcmd
INFO: Setting value for the property:id in the bean:configcmd
INFO: Setting value for the property:platformcmdmap in the bean:configcmd
INFO: Setting value for the property:id in the bean:configcmd
INFO: Setting value for the property:platformcmdmap in the bean:configcmd
INFO: Setting value for the property:id in the bean:configcmd
INFO: Setting value for the property:platformcmdmap in the bean:configcmd
INFO: Setting value for the property:configcmds in the bean:configcmdmappings
SEVERE: [FATAL] [INS-10102] Installer initialization failed.
   CAUSE: An unexpected error occured while initializing the Installer.
   ACTION: Contact Oracle Support Services or refer logs
   SUMMARY:
       - [INS-21003] Installer has detected that an invalid inventory pointer location file was specified..
Refer associated stacktrace #oracle.install.commons.util.exception.DefaultErrorAdvisor:37
INFO: Advice is ABORT
SEVERE: Unconditional Exit
INFO: Adding ExitStatus FAILURE to the exit status set
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is -1
INFO: Shutdown Oracle Database 12c Release 1 Installer




Cause:

Installer is looking for additional information in a central Inventory.  Parameter "inst_group" is missing from the file "/etc/oraInst.loc"


Solution:

Add the valid group  for "inst_group" in "/etc/oraInst.loc"

[root@erpnode3 ora_test]# cat /etc/oraInst.loc 
#inventory_loc=/u01/ora_prod/oraInventory
inventory_loc=/u01/ora_test/oraInventory
inst_group=dbaerp
[root@erpnode3 ora_test]# 

This issue can occur on machine where earlier oracle software is Installed and has a missing entry of "inst_group" parameter in central Inventory "/etc/oraInst.loc"

After adding this parameter Installer proceeds without any Issue.



thanks,
X A H E E R



Thursday, 13 November 2014

Change Weblogic admin password in Oracle EBS R12.2

In Oracle E-Business suite R12.2 there many changes in Tech Stack components. Oracle 10.1.3 Application server is now replaced by Oracle Weblogic server. The default admin user name "weblogic" will be created during Installation and it will use the same password that has been configured during Installation.

As per the security policies and business requirement you may require to change the weblogic admin password. There are two supported options for changing the weblogic admin password. First if the you know the password and want to change for security reasons (or) If you lost/forgotten the weblogic amdin domain password.

In this demonstration i will show how to change the weblogic admin user password if the password is known.

==> Login to weblogic to server console:


- Login using the current weblogic admin username and  password.





- Select the lock and edit button



- Click on Domain link

- Click on Security TAB



- Click on "Advanced" TAB



- Provide the new password which you want to configure for weblogic admin user


- Click on "save"

- Verify settings updated successfully and then click on "Activate changes"



- Verify all changes has been activated successfully.



- Now click on "Security Realms"



- Click on "myrealm"


-  select "users and groups" and select weblogic User:


- Provide same password as we have provided above for node manager.



- Make sure the settings has been updated successfully.


After this we need to edit the configuration file "boot.properties" for all managed and admin server  using text editor and update the password field with the above configured password ( new password)

- take  backup of the following files:


$FMW_HOME/user_projects/domains/EBS_domain_/servers/AdminServer/security/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_/servers/forms-c4ws_server1/data/nodemanager/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_/servers/forms_server1/data/nodemanager/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_/servers/oacore_server1/data/nodemanager/boot.properties
$FMW_HOME/user_projects/domains/EBS_domain_/servers/oafm_server1/data/nodemanager/boot.properties


"$FMW_HOME/user_projects/domains/EBS_domain_" is the absolute PATH for your EBS weblogic domain.


PATH ="/d01/appl_prod/appl/PROD/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/"


[applR12@erpnode2 nodemanager]$ cat boot.properties 
#Tue Oct 22 05:16:35 AST 2013
TrustKeyStore=DemoTrust
password=oracle12345
username={AES}svCfxC1/zM76552t7otwoOMiQNApJavwuur0OfMqsrk\=
[applR12@erpnode2 nodemanager]$ cat orig.boot.properties 
#Tue Oct 22 05:16:35 AST 2013
TrustKeyStore=DemoTrust
password={AES}kwT8uzUoZs78Mb9glRKksdfp+w+JKf5EogRPliLHLPE\=
username={AES}svCfxC1/zM76552t7otwoOMiQNApJavwuur0OfMqsrk\=
[applR12@erpnode2 nodemanager]$ 


The above is an example of boot.properties file of one the managed server. "orig.boot.properties" is an original file and the password in that file is encrypted. We have to change the password using text editor and provide the one configured in previous steps.

After editing all the above mentioned files we need to restart the application services using adstpall.sh and adstrtal.sh scripts.

After restarting of services make sure all application services are started successfully. Verify that you are able to access weblogic server console and access ERP application.

The password edited in the above files will again become in non human readable format.

Hope it helps :)

thanks for reading.

regards,
X A H E E R








Monday, 10 November 2014

Upgrade Oracle EBS R12.2.0 to R12.2.4

The latest available version of  Oracle E-Business suite is R12.2.0 and the latest available. In this article I will demonstrate upgrading Oracle EBS from R12.2.0 to R12.2.4.

This post will be helpful for those who are performing a fresh Installation and planning to upgrade it  to R12.2.4. The latest available version of start CD is R12.2.0.48 and it can be downloaded via patch "Patch 18086193 "

If you Install 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

The below upgrade has been performed on a virtual machine configured with 12GB RAM and 6 core processors.

Environment: Oracle Enterprise Linux 5.7 (64-Bit)
EBS Version :  Oracle EBS R12.2.0 (using start CD 12.2.0.48)

The following are the list of patches need to be Installed on Oracle EBS Tech Stack components before proceeding with the upgrade:


If used other version of start CD during Installation then there will be some other patches you need to Install before proceeding with the upgrade. The above list of patches are applicable and only available pre-requisites currently. This list might get also change in future. So please refer MOS tech note "Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)"  to check for latest updates,

These patch number are specific to Linux-64 bit. Different OS will have different patch numbers. So please refer above listed tech note.



For fresh Installation of R12.2  refer:

http://appsdbaworkshop.blogspot.com/2013/10/oracle-applications-r122-installation.html

For using start CD R12.2.0.48 refer:

http://appsdbaworkshop.blogspot.com/2014/10/using-start-cd-122048-with-r122-stage.html


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)

R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)


R12.2.4 Upgrade Steps:
  • Prepare for upgrade
  • Upgrade 
  • Post upgrade

>>> Prepare for Upgrade:

1 - Install Oracle RDBMS patches:

Perform backup of database and RDBMS Oracle_Home before applying these patches.


[oraebs@erpnode3 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.
[oraebs@erpnode3 16989137]$ 


[oraebs@erpnode3 17875948]$ 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/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')


Is the local system ready for patching? [y|n]
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.
[oraebs@erpnode3 17875948]$ 


[oraebs@erpnode3 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.
[oraebs@erpnode3 17912217]$ 


[oraebs@erpnode3 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.
[oraebs@erpnode3 18419770]$ 


[oraebs@erpnode3 18614015]$ pwd
/u01/patch_stage/database/DB/18614015
[oraebs@erpnode3 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.
[oraebs@erpnode3 18614015]$ 


[oraebs@erpnode3 18685209]$ 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/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.
[oraebs@erpnode3 18685209]$ 



As per footnote-11 patch "18259911" was Installed. So we need to rollback this patch first Installing patch "19078951".

[oraebs@erpnode3 DB]$ opatch lsinventory | grep 18259911
Patch  18259911     : applied on Mon Oct 27 21:54:20 AST 2014
[oraebs@erpnode3 DB]$ opatch lsinventory | grep 17461865
[oraebs@erpnode3 DB]$



[oraebs@erpnode3 DB]$ opatch rollback -id 18259911
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/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.
[oraebs@erpnode3 DB]$ 


[oraebs@erpnode3 19078951]$ 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/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.
[oraebs@erpnode3 19078951]$ 


= > Perform post Installation of all patches after applying all RDBMS Patches:


SQL> @?/sqlpatch/16989137/postinstall.sql

Session altered.


Grant succeeded.


Session altered.

Calling ctx/admin/driacc.plb on 28-OCT-14 03.06.10.208289 PM +03:00


Package body created.

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


Package body created.

Calling rdbms/admin/catmet2.sql on 28-OCT-14 03.14.49.548401 PM +03:00


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

------------------------------------------

SQL>  @?/sqlpatch/18614015/postinstall.sql
Calling rdbms/admin/prvtutil.plb on 28-OCT-14 03.24.58.515625 PM +03:00


Package body created.

SQL> 



2 - Install Oracle Fusion Middleware 11.1.1.6 patches

- Set oracle home for FMW (11.1.1.6)


[applebs@erpnode3 ~]$ export ORACLE_HOME=/u01/appl_test/fs1/FMW_Home/webtier
[applebs@erpnode3 ~]$ export PATH=/u01/appl_test/fs1/FMW_Home/webtier/OPatch:$PATH

- Verify the opatch is set from the proper Oracle Home


[applebs@erpnode3 ~]$ opatch lsinventory
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.
[applebs@erpnode3 ~]$ 


- Apply patches on 11.1.1.6 FMW Home


[applebs@erpnode3 ~]$ cd /u01/patch_stage/Apps/Pre_REQS_Apps/17639414
[applebs@erpnode3 17639414]$ ls
etc  files  README.txt
[applebs@erpnode3 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.
[applebs@erpnode3 17639414]$ 



[applebs@erpnode3 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.
[applebs@erpnode3 18989444]$ 



[applebs@erpnode3 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.


Patching component oracle.as.common.clone, 11.1.1.6.0...

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.
[applebs@erpnode3 19462638]$ 


3 - Install Oracle 10.1.2.3 Forms & Reports Patches

- Set the Environment variable for 10.1.2 ORACLE HOME


[applebs@erpnode3 18186693]$ pwd
/u01/patch_stage/Apps/Pre_REQS_Apps/18186693
[applebs@erpnode3 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.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[applebs@erpnode3 18186693]$ 



4 - Install Oracle Weblogic server (10.3.6) Patches

- Copy and unzip Patches in weblogic server "cache_dir"



[applebs@erpnode3 cache_dir]$ cp /u01/patch_stage/Apps/Pre_REQS_Apps/p17893334_1036_Generic.zip .
[applebs@erpnode3 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
[applebs@erpnode3 cache_dir]$ 



[applebs@erpnode3 cache_dir]$ unzip p17893334_1036_Generic.zip 
Archive:  p17893334_1036_Generic.zip
  inflating: 7FC9.jar                
  inflating: README.txt              
  inflating: patch-catalog_21169.xml  
[applebs@erpnode3 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

5 - 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@erpnode3 db_scripts]$ cp /u01/EBS_patches/Apps_pre_1224/18283295/admin/adgrants.sql .
[oraebs@erpnode3 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.



---------------------------------------------------
--- profload.sql started at 2014-11-04 21:13:26 ---


Package created.


Grant succeeded.


Synonym created.


Library created.


Package body created.

Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.

PL/SQL procedure successfully completed.



-----------------------------------------------------
--- profload.sql completed at 2014-11-04 21:13:31 ---



--------------------------------------------------
--- proftab.sql started at 2014-11-04 21:13:31 ---


Table dropped.


Table dropped.


Table dropped.


Sequence dropped.


Table created.


Comment created.


Table created.


Comment created.


Table created.


Comment created.


Sequence created.



-----------------------------------------------------
--- profltab.sql completed at 2014-11-04 21:13:35 ---


Installing Hierarchical Profiler.


Table dropped.


Table dropped.


Table dropped.


Sequence dropped.


Table created.


Comment created.


Table created.


Comment created.


Table created.


Comment created.


Sequence created.


Package created.


Synonym created.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Loading Stylesheets if missing


PL/SQL procedure successfully completed.


Start of Creating AD_JAR context


PL/SQL procedure successfully completed.


End of Creating AD_JAR context


Creating PL/SQL Package AD_DBMS_METADATA.


Package created.


Package body created.


End of Creating PL/SQL Package AD_DBMS_METADATA.


Creating PL/SQL Package AD_ZD_SYS.


Package created.


Package body created.


End of Creating PL/SQL Package AD_ZD_SYS.

Start of giving grants. This may take few minutes.

PL/SQL procedure successfully completed.


Start of PURGE DBA_RECYCLEBIN.


PL/SQL procedure successfully completed.


End of PURGE DBA_RECYCLEBIN.


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
[oraebs@erpnode3 db_scripts]$ 



=> 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


[applebs@erpnode3 appl_test]$ ls
EBSapps.env  fs1  fs2  fs_ne
[applebs@erpnode3 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: erpnode3.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 ...

[applebs@erpnode3 appl_test]$ 




[applebs@erpnode3 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 

Worker count determination...

Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
------------------------------------------------------------------------
-----------------------------------------------------------------------------
Program :  completed @ Thu Nov  6 00:59:07 2014

        [EVENT]     [END   2014/11/06 00:59:07] CLONE Patch File System from Run File System
        [EVENT]     Calling task: "Releasing ports on erpnode3"; script: "/u01/appl_test/fs1/inst/apps/test_erpnode3/admin/install/txkCloneAcquirePort.pl"; args: " -option=close -server=erpnode3.oralabs.com -ports=5565,7010,7610,7410,7210,7810,6109,6209 -log=/u01/appl_test/fs_ne/EBSapps/log/adop/7/fs_clone_20141105_201909/test_erpnode3/txkCloneAcquirePort.log"
        [EVENT]     [START 2014/11/06 00:59:07] Releasing ports on erpnode3
          [EVENT]     Calling: /u01/appl_test/fs1/inst/apps/test_erpnode3/admin/install/txkCloneAcquirePort.pl
        [EVENT]     [END   2014/11/06 00:59:08] Releasing ports on erpnode3
        [EVENT]     [START 2014/11/06 00:59:09] Check and Stop Patch FS Admin Server

You are running adadminsrvctl.sh version 120.10.12020000.9

Stopping WLS Admin Server...
Refer /u01/appl_test/fs2/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/fs2/inst/apps/test_erpnode3/logs/appl/admin/log/adadminsrvctl.txt for more information ...  

        [EVENT]     [END   2014/11/06 00:59:24] Check and Stop Patch FS Admin Server
        [EVENT]     [START 2014/11/06 00:59:25] Check and Stop Patch Node Manager

You are running adnodemgrctl.sh version 120.11.12020000.11


The Node Manager is already shutdown

adnodemgrctl.sh: exiting with status 2

adnodemgrctl.sh: check the logfile /u01/appl_test/fs2/inst/apps/test_erpnode3/logs/appl/admin/log/adnodemgrctl.txt for more information ...  

        [EVENT]     [END   2014/11/06 00:59:32] Check and Stop Patch Node Manager
    [EVENT]     [START 2014/11/06 00:59:32] Generating AD_ZD_LOGS Report
      [EVENT]     Report: /u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

      [EVENT]     Output: /u01/appl_test/fs_ne/EBSapps/log/adop/7/fs_clone_20141105_201909/test_erpnode3/adzdshowlog.out

    [EVENT]     [END   2014/11/06 00:59:59] Generating AD_ZD_LOGS Report
  [END   2014/11/06 00:59:59] adzdoptl.pl run
  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)


Upgrade:

- Shutdown all application services
- Perform full application and database backup
- Install patch in a "downtime" mode


[applebs@erpnode3 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 ...  

[applebs@erpnode3 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 ...  

[applebs@erpnode3 scripts]$ 



- Check Release of existing system



- Start Installation of patch. I have used 12 workers and you can use it according to available resources.


[applebs@erpnode3 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...

Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[START 2014/11/06 18:21:16] Check if services are down
  [STATEMENT]  Application services are down.
[END   2014/11/06 18:21:19] Check if services are down
[EVENT]     [START 2014/11/06 18:21:19] Performing database sanity checks
[EVENT]     [END   2014/11/06 18:21:19] Finished performing database sanity checks
  [START 2014/11/06 18:21:21] adzdoptl.pl run
    ADOP Session ID: 8
    Phase: apply
    Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/8/adop_20141106_182058.log
    [START 2014/11/06 18:21:22] apply phase 
        Calling: adpatch  workers=12   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appl_test/fs1/EBSapps/appl/admin/test/adalldefaults.txt patchtop=/u01/appl_test/fs_ne/EBSapps/patch/17919161 driver=u17919161.drv logfile=u17919161.log
        ADPATCH Log directory: /u01/appl_test/fs_ne/EBSapps/log/adop/8/apply_20141106_182058/test_erpnode3/17919161/log
        [EVENT]     [START 2014/11/07 13:09:22] Running finalize since in downtime mode
        [EVENT]     [END   2014/11/07 13:13:44] Running finalize since in downtime mode
          Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=12 restart=no abandon=yes defaultsfile=/u01/appl_test/fs1/EBSapps/appl/admin/test/adalldefaults.txt patchtop=/u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv
          ADPATCH Log directory: /u01/appl_test/fs_ne/EBSapps/log/adop/8/apply_20141106_182058/test_erpnode3/log
        [EVENT]     [START 2014/11/07 13:17:01] Running cutover since in downtime mode
        [EVENT]     [END   2014/11/07 13:17:01] Running cutover since in downtime mode
      [END   2014/11/07 13:17:02] apply phase 
      [START 2014/11/07 13:17:02] Generating Post Apply Reports 
        [EVENT]     [START 2014/11/07 13:17:03] Generating AD_ZD_LOGS Report
          [EVENT]     Report: /u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

          [EVENT]     Output: /u01/appl_test/fs_ne/EBSapps/log/adop/8/apply_20141106_182058/test_erpnode3/adzdshowlog.out

        [EVENT]     [END   2014/11/07 13:17:29] Generating AD_ZD_LOGS Report
      [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)


- After Successful Installation of Patch start all Application services:


[applebs@erpnode3 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: erpnode3.oralabs.com  Service/SID: test


  Sourcing the RUN File System ...

[applebs@erpnode3 appl_test]$ adstrtal.sh apps/apps



- Execute cleanup and clone operations on file system


[applebs@erpnode3 ~]$ 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...

Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[EVENT]     [START 2014/11/08 06:52:39] Performing database sanity checks
[EVENT]     [END   2014/11/08 06:52:40] Finished performing database sanity checks
  [START 2014/11/08 06:52:42] adzdoptl.pl run
    ADOP Session ID: 8
    Phase: cleanup
    Log file: /u01/appl_test/fs_ne/EBSapps/log/adop/8/adop_20141108_061727.log
    [START 2014/11/08 06:52:43] cleanup phase
      [EVENT]     [START 2014/11/08 06:52:44] Performing Cleanup steps 
        [EVENT]     [START 2014/11/08 06:52:44] Running stored CLEANUP actions 
          Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=6 restart=no abandon=yes defaultsfile=/u01/appl_test/fs1/EBSapps/appl/admin/test/adalldefaults.txt patchtop=/u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
          ADPATCH Log directory: /u01/appl_test/fs_ne/EBSapps/log/adop/8/cleanup_20141108_061727/test_erpnode3/log
        [EVENT]     [END   2014/11/08 06:54:01] Running stored CLEANUP actions 
        [START 2014/11/08 06:54:01] Generating All DDL Report
            [EVENT]     Report: /u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

            [EVENT]     Output: /u01/appl_test/fs_ne/EBSapps/log/adop/8/cleanup_20141108_061727/test_erpnode3

        [END   2014/11/08 06:54:21] Generating All DDL Report
        [EVENT]     Calling cleanup in STANDARD mode
        [WARNING]   Cleanup may take a while. Please wait.
      [EVENT]     [END   2014/11/08 06:55:18] Performing Cleanup steps 
    [END   2014/11/08 06:55:18] cleanup phase 
    [EVENT]     [START 2014/11/08 06:55:19] Generating AD_ZD_LOGS Report
      [EVENT]     Report: /u01/appl_test/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

      [EVENT]     Output: /u01/appl_test/fs_ne/EBSapps/log/adop/8/cleanup_20141108_061727/test_erpnode3/adzdshowlog.out

    [EVENT]     [END   2014/11/08 06:56:18] Generating AD_ZD_LOGS Report
  [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)
[applebs@erpnode3 ~]$ 



[applebs@erpnode3 ~]$ 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)
[applebs@erpnode3 ~]$ 


The upgrade form 12.2.0 to 12.2.4 completed.

- 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





All manged servers are up and running. If you have any queries/comments then update me. Thanks for reading.

regards,
X A H E E R