Wednesday, 24 December 2014

Oracle apps fresh installation 12.1.1 and upgrade to 12.1.3



Fresh installation R12 from below link

Upgrade Fresh installation oracle apps 12.1.1 to 12.1.3:
======================================================
After my fresh installation of oracle apps R12 which comes with 12.1.1,
We plan to upgrade to 12.1.3 so for upgrade we need to patch 9239090 ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK.

For Apply patch 9239090 from 12.1.1 to 12.1.3 you have apply prerequisite 9239089 R12.AD.B.delta.3 before applying 9239090.

Major Steps as follows.
Ø  +Stop the application

Ø  +Enable Maintenance mode.

Ø  +Apply 9239089

Ø  +Apply 9239090

Ø  +Disable Maintenance mode.

Ø  +Start the application


Detailed steps:
Step:1A
++ Source application env file and go to location $ADMIN_SCRIPTS_HOME
sh adstpall.sh

Step:1B
++ enable Maintenance mode
adadmin
AD code level: [B.1]

           AD Administration Main Menu
  --------------------------------------------------

  1.    Generate Applications Files menu

  2.    Maintain Applications Files menu

  3.    Compile/Reload Applications Database Entities menu

  4.    Maintain Applications Database Entities menu

  5.    Change Maintenance Mode

  6.    Exit AD Administration

Enter your choice [6]: 5

            Change Maintenance Mode
  ----------------------------------------

Maintenance Mode is currently: [Disabled].


Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.

Please select an option:

  1.    Enable Maintenance Mode

  2.    Disable Maintenance Mode

  3.    Return to Main Menu

Enter your choice [3] : 1

sqlplus -s &un_apps/***** @/u01/dev/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE


Step:1C:Applying patch: 9239089

Run adpatch

Enter the log file as patch no
Enter SYSTEM password
Enter apps password

Check the log.

/u01/dev/apps/apps_st/appl/admin/DEV/log/adrelink.log
/u01/dev/apps/apps_st/appl/admin/DEV/log/9239089.log

Step:2A
Apply patch 9239090 ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK

Log: APPL_TOP/admin/<SID>/log
Ignore the below error

ERROR:
++ The following Oracle Forms objects did not generate successfully:

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No]:
You should check the file
/u01/dev/apps/apps_st/appl/admin/DEV/log/9239090

For errors:
Follow the link to fix the error and restart the patch.
<< oracletechdba.blogspot.com/2014/12/adpatch-error-occurred-while-generating.html >>


Check the version of the application


++ Enable the Maintenance mode and start the application to test.

No comments: