Patching Fusion Applications (one-off Patch)

Run the following commands:

$ cd FA_ORACLE_HOME/lcm/ad/bin (eg. /oracle/CSIFUSION/fusionapps/applications/lcm/ad/bin)

$ . ./APPSORA.env

If this file does not exist yet create it first by running command:

$ lcm/ad/bin/adsetenv.sh

Patchtop:

/stagefusion/fusionpatch114/OBIEEBrokerPatch1114/p14461777_111400_Fusion_GENERIC/14461777

Validate patch first

Command for validating:

$APPL_TOP/lcm/ad/bin

fapmgr.sh validate -online -patchtop /stagefusion/fusionpatch114/OBIEEBrokerPatch1114/p14461777_111400_Fusion_GENERIC/14461777/

The validation will begin and the errors will be listed during validation. Correct them before revalidation.

Oracle Fusion Applications Patch Manager Version 11.1.4.0.0

Copyright (c) 2012 Oracle Corporation. All rights reserved.

Archiving existing log files from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/VALIDATE/20130119101613].

Started validating the Database connection.

Completed validating the Database connection.

Started validating taxonomy URL.

Completed validating taxonomy URL.

Started  checking pre-requisite bug fixes for the patch.

Completed checking pre-requisite bug fixes for the patch.

Reference number for the current Oracle Fusion Applications Patch Manager run is 24.

Started validating the Database components of the patch.

Patch validation is in progress. This might take a while.

Monitor the adpatch log file : /oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/adpatch_validate_20130119101729.log.

Validation successful.

Completed validating the Database components of the patch.

Completed running apply pre-reqs.

No actions will be performed for the middleware artifact changes in the patch because they are not required or they already exist in the system.

================================================================================

Validation of patch is SUCCESSFUL.

You can apply the patch.

================================================================================

Generating Diagnostic Report...

Diagnostics report is generated at : /oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPMgrDiagnosticsSummary_validate_20130119101729.html.

All log files location                       :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log

Oracle Fusion Applications Patch Manager log :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPatchManager_validate_20130119101729.log

Log Summary                                  :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/logsummary_validate_20130119101729.html

Oracle Fusion Applications Patch Manager completed successfully.

In the next run, the log files for this run will be moved from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/14461777/VALIDATE/24/20130119101729].

Before apply the patch,

Locate taxonomyurl from $APPL_TOP/admin/FUSION_env.properties

[oracle@fusionapp admin]$ grep TAXONOMY_URL FUSION_env.properties

TAXONOMY_URL=fusionapp:12001

[oracle@fusionapp admin]$

Apply the patch:

From $APPL_TOP/lcm/ad/bin

fapmgr.sh apply –patchtop

/stagefusion/fusionpatch114/OBIEEBrokerPatch1114/p14461777_111400_Fusion_GENERIC/14461777/ -start_adpatch_opt force_branch_order=Patch_Is_Higher -end_adpatch_opt -workers=4 -continueonerror -online -taxonomyurl fusionapp:12001

[oracle@fusionapp bin]$ fapmgr.sh apply -patchtop /stagefusion/fusionpatch114/OBIEEBrokerPatch1114/p14461777_111400_Fusion_GENERIC/14461777/ -start_adpatch_opt force_branch_order=Patch_Is_Higher -end_adpatch_opt -workers=4 -continueonerror -online -taxonomyurl fusionapp:12001

Oracle Fusion Applications Patch Manager Version 11.1.4.0.0

Copyright (c) 2012 Oracle Corporation. All rights reserved.

Archiving existing log files from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/APPLY/20130119103227].

Started validating the Database connection.

Completed validating the Database connection.

Started validating taxonomy URL.

Completed validating taxonomy URL.

Started  checking pre-requisite bug fixes for the patch.

Completed checking pre-requisite bug fixes for the patch.

Reference number for the current Oracle Fusion Applications Patch Manager run is 25.

Started validating the Database components of the patch.

Patch validation is in progress. This might take a while.

Monitor the adpatch log file : /oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/adpatch_validate_20130119103643.log.

Validation successful.

Completed validating the Database components of the patch.

Started applying the Database components of the patch.

Patch apply is in progress. This might take a while.

Monitor the adpatch log file: /oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/adpatch_apply_20130119103643.log

Completed applying the Database components of the patch.

Started identifying Post Apply tasks.

Completed identifying Post Apply tasks.

No actions will be performed for the middleware artifact changes in the patch because they are not required or they already exist in the system.

Started flexfield deployment.

Deployment is in progress. This might take a while.

Monitor the log file :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPatchManager_apply_20130119103643.log

Completed flexfield deployment.

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

Generating the data fixes XML file.

Generated patch inventory file: /oracle/CSIFUSION/fusionapps/applications/faPatchInventory/fusionAppsPatchHistory.xml

Generating Diagnostic Report...

Diagnostics report is generated at : /oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPMgrDiagnosticsSummary_apply_20130119103643.html.

All log files location                       :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log

Oracle Fusion Applications Patch Manager log :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPatchManager_apply_20130119103643.log

Log Summary                                  :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/logsummary_apply_20130119103643.html

Oracle Fusion Applications Patch Manager completed successfully.

In the next run, the log files for this run will be moved from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/14461777/APPLY/25/20130119103643].

To verify the patch applied or not:

From

$APPL_TOP/lcm/ad/bin

[oracle@fusionapp bin]$ fapmgr.sh report -listpatches

Oracle Fusion Applications Patch Manager Version 11.1.4.0.0

Copyright (c) 2012 Oracle Corporation. All rights reserved.

Archiving existing log files from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/14461777/APPLY/25/20130119103643].

Started validating the Database connection.

Completed validating the Database connection.

Report Name: Patches Applied

Report for: FUSION [/oracle/CSIFUSION/fusionapps/applications]

ProductFamily (OUI Component) :: Oracle Fusion Human Capital Management (oracle.fusionapps.hcm)

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

PATCH NO. |    LANGUAGE  |    PATCH TYPE |    DATE APPLIED                  |    BUGS FIXED          |

                     |                                                       |    (mm-dd-yyyy hh:mm:ss) |

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

1120422194|    American E|    MAINTENANCE|    04-28-2012  02:47:46  |    11204221941

1                   |    nglish           |    -PACK                 |                                            |

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

ProductFamily (OUI Component) :: Oracle Fusion Supply Chain Management (oracle.fusionapps.scm)

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

PATCH NO. |    LANGUAGE  |    PATCH TYPE |    DATE APPLIED                    |    BUGS FIXED

                     |                          |                            |    (mm-dd-yyyy hh:mm:ss) |

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

14325054  |    American E|    Standard   |    01-19-2013  10:39:50  |    14325054

                    |          nglish    |                        |                                            |

14461777  |    American E|    Standard   |    01-19-2013  10:39:50  |    14461777

                    |    nglish          |                       |                                            |

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

The report was generated on: 19-Jan-2013 10:57:49. All timestamps are in India Standard Time.

All log files location                       :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log

Oracle Fusion Applications Patch Manager log :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/FAPatchManager_report-listpatches_20130119105735.log

Log Summary                                  :/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log/logsummary_report-listpatches_20130119105735.html

Oracle Fusion Applications Patch Manager completed successfully.

In the next run, the log files for this run will be moved from [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/log] to [/oracle/CSIFUSION/fusionapps/applications/admin/FUSION/logarchive/REPORT-LISTPATCHES/20130119105735].

Cheers!!!