Sunday, July 26, 2015

Oracle E-Business Suite upgrade to 12.1.3



Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)



Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

 export ORACLE_SID=PROD
  export ORACLE_HOME=/scratch/EBS12.1.1/db/tech_st/11.1.0
  export PATH=$PATH:$ORACLE_HOME/bin
   . /scratch/EBS12.1.1/apps/apps_st/appl/APPSPROD_ofss2311720.env


To apply Oracle E-Business Suite Release 12.1.3, follow these steps:
1.    Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089, before you complete any of the other steps in this section. Do not merge this patch with any other patch. R12.AD.B.Delta.3 must be applied separately. Refer to My Oracle Support Knowledge Document 1077769.1, Oracle E-Business Suite Applications DBA Readme, Release 12.1.3 for more information about R12.AD.B.Delta.3.

2.    Use AutoPatch to apply Oracle E-Business Suite Release 12.1.3 Patch 9239090 and follow the instructions in the patch readme file.

3.    Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.

2. Installation packs

* Patch 9239089(R12.AD.B.DELTA.3)
* Patch 9239090 12.1.3 RELEASE UPDATE PACK
* Patch 9239095 Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack
* Patch 9817770 POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH
* Patch 9966055 1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED





Step1. Run utility adadmin utility and change maintenance mode to enable
Steps 2: Apply patch 9239089  (R12.AD.B.DELTA.3)
Patch R12.AD.B.delta.3: Oracle Applications DBA 12.1.3 Product Release Update Pack
Oracle E-Business Suite Applications DBA Readme, Release 12.1.3 (R12.AD.B.DELTA.3, Patch 9239089) (Doc ID 1077769.1)


Pre-install Tasks
You must shut down all Application tier services before performing the tasks in this section.
Instructions for running AD Grants
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

  Usage:

  1. Create $ORACLE_HOME/appsutil/admin on the database server.

  2. Copy adgrants.sql (UNIX) from this patch directory to
     $ORACLE_HOME/appsutil/admin.
     Or, copy adgrants_nt.sql (Windows) from this patch directory to
     %ORACLE_HOME%\appsutil\admin.

  3. Set the environment to point to ORACLE_HOME on the database server.

  4. Use SQL*Plus to run the script:

     UNIX:
     $ sqlplus /nolog
     SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>
Apply The Patch

-- Run ADAMIN utility and enable maintenance mode

Apply patch 9239089
This patch contains the following unified driver file to be applied with
AutoPatch:
    u9239089.drv (This is the unified driver)
1.  change to patch directory
2.  run utility adpatch and give above drv filename when ask.


Apply patch 9239090


Patch 12.1.3: ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK


Apply patch
This patch contains the following unified driver file to be applied with
AutoPatch:
    u9239090.drv (This is the unified driver)


Apply patch 9239095


Patch 9239095: Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack



Apply patch
This patch contains the following unified driver file to be applied with
AutoPatch:
    u9239095.drv (This is the unified driver)



Steps 5: Apply   Patch 9817770



Steps 6: Apply Patch 9966055


Steps 7: Apply patch 8919491

Step 7: Change maintenance mode

Step8: start application processes


  Post-Update Steps

1.    Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)
o    Apply mandatory Patch 9817770:R12.ATG_PF.B (POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH).
o    Apply mandatory Patch 9966055:R12.FND.B (TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED).

 

Patch 9817770: POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH

The following should be installed in the order shown before installing this patch.
1
(Install on Oracle Applications DBA)
2


Patch 9966055: 1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED

Prerequisite Patches
The following should be installed in the order shown before installing this patch.
1
(Install on Oracle Applications DBA)
2
(Install on Oracle Applications Technology Family)


Patch R12.ATG_PF.B.delta.3: Oracle Applications Technology 12.1.3 Product Family Release Update Pack
 Prerequisite Patches
(Install on Oracle Applications DBA)




-- Run ADAMIN utility and disable maintenance mode
--Start the EBS processes
--Login and check the page




SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.3

SQL>


SQL> select bug_number from ad_bugs where bug_number in ('9239089','9239090','9817770','9966055');

BUG_NUMBER
------------------------------
9239089
9239090
9817770
9966055

SQL>




   
   
   col PATCH_NAME format a10
col PATCH_TYPE format a10
col DRIVER_FILE_NAME format a15
col PLATFORM format a10
select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE,  AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID


PATCH_NAME PATCH_TYPE DRIVER_FILE_NAM CREATION_DATE      PLATFORM   LANG
---------- ---------- --------------- ------------------ ---------- ----

9239089    PATCH-SET  u9239089.drv    12-JUN-15          LINUX      US
9239090    MAINTENANC u9239090.drv    12-JUN-15          LINUX      US
           E-PACK

9817770    ONE-OFF    u9817770.drv    12-JUN-15          LINUX      US
9966055    ONE-OFF    u9966055.drv    12-JUN-15          GENERIC    US
8919491    PATCH-SET  u8919491.drv    12-JUN-15          LINUX      US
9239095    ONE-OFF    u9239095.drv    12-JUN-15          GENERIC    US




-----Troubleshooting
  

  Application Tier Startup/Shutdown Scripts
Depending on your AD Version these will be in

OAD_TOP/admin/scripts/ SID_hostname

adalnctl.sh Apps Listener Control Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier





Login page
http://ofss2311720.in.oracle.com:8001/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

Username/Password: SYSADMIN/sysadmin






[debaranw@ssssss scripts]$  ./adapcctl.sh status

You are running adapcctl.sh version 120.7.12010000.2

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

Processes in Instance: VIS_localhost.localhost.in.oracle.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |    9813 | Alive
OC4JGroup:default_group          | OC4J:forms         |    9740 | Alive
OC4JGroup:default_group          | OC4J:oacore        |    9654 | Alive
HTTP_Server                      | HTTP_Server        |    9595 | Alive


adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /scratch/EBS12.1.1/inst/apps/VIS_localhost/logs/appl/admin/log/adapcctl.txt for more information ...

[debaranw@xxxxxx scripts]$