Sunday, November 17, 2013

Oracle EBS 12.2.2 complete installation diary

12.2.2 installation diary

The new EBS 12.2.2 installation is not so simple as an old EBS, it contains many steps from many notes and based on a partially complete installation media.

In this blog post I will show you my latest 12.2.2 installation, through a "complete" diary.
So what will the post contains?
  • all required installation documents and notes
  • installation media files - complete list
  • installation steps
  • detected problems

Documents and notes

The following documents are what I have used during the installation
Name Location Id, note number
Oracle E-Business Suite Installation Guide Using Rapid Install OTN E22950-14
Oracle E-Business Suite Upgrade Guide Release Release 12.0 and 12.1 to 12.2 OTN E48839-02
Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2 Upgrade Support 1349240.1
Oracle E-Business Suite Release 12.2.2 Readme Support 1506669.1
Apply the 12.2.2 AD and TXK Release Update Packs Support 1560906.1
Oracle E-Business Suite NLS Release Notes, Release 12.2 Support 1314621.1
Oracle E-Business Suite Release Notes, Release 12.2 Support 1320300.1
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for - platform specific Support 1330701.1, 1330702.1, 1330703.1, 1330704.1
Troubleshooting Rapid Install for E-Business Suite Release 12.2 Support 1378579.1
Important Notice: Issues with Downloading Oracle E-Business Suite Release 12.2 Media Packs Support 1588372.1

Installation media files

What installation media files do you need? Do you think so, that the is enough for a fresh 12.2 system? No, the edelivery media files, you will need access for a complete installation, there are many patches, that required for completion the install and start the 12.2 system (12.2.2 too)

So these files and patches need to download

Name Location Id, patch number
Oracle E-Business Suite Release 12.2.2 Media Pack for Linux x86-64-bit edelivery B74476-01
Database Patches Support, edelivery 16702016, 16924879, 17047617, 17184721
Online Patching Enablement patch Support 13543062
R12.AD.C.DELTA.2 Support 15955263
R12.TXK.C.DELTA.2 Support 15946788
Oracle E-Business Suite Release 12.2.2 Online Help Support 16207673

Creating stage area

For installing a 12.2 version it is a very important step. If you don't create it well, the 12.2.0 installation will goes to error and you couldn't complete the installation.

Create the main 12.2.0 installation stage directory

Only the following components should be downloaded to a Oracle E-Business Suite 12.2 stage directory:

  • Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here
  • Oracle E-Business Suite Release 12.2.0 Rapid Install (All Disks and Parts)
  • Oracle E-Business Suite Release 12.2.0 for <Platform> Rapid Install Technology One-Off Patches
  • Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence
  • Oracle Fusion Middleware Web Tier Utilities 11g Patch Set 5 ( for <Platform>

Create additional stage directories

For a later installation steps I mention to create these additional stage directories

  • One for 12.2.2 patch
  • One for NLS 12.2.2 patch
  • One for the remaining ones

Installation steps

A 12.2.2 version installation is pretty similar as an 12.1.3 installation. You should install a base version then a big RUP patch with many small other steps.
These main steps required for installing a 12.2.2 system

  1. Install a base 12.2.0 system
  2. Enable Online patching
    1. install mandatory database patches
    2. prepare system for online patching
    3. apply online patching patch
    4. check system
  3. Apply AD and TXK RUP patches
  4. Install 12.2.2 patch
  5. Post 12.2.2 steps
    1. Adding languages
    2. Legislation data
    3. Grant flexfield value set access
    4. Install online help
Let's go into the details.

Install a base 12.2.0 system

This is the "simpliest" step. If you have create well the 12.2.0 source stage directory, prepared well your system (as release note mentioned for you platform) the installation will be an easy work.

So the steps
  1. Prepare your operating system for EBS installation. Use the suitable release notes. 
  2. Create the stage area, don't unzip the zipped media files, it will done by a shell script.
    1. unzip only the startCD into the new directory (V35215-01 zip files)
    2. cd <stage dir>/startCD/Disk1/rapidwiz/bin/
    3. run as root
      1. choose "Create new stage area" option and your platform
      2. wait until the script unzip the files and verify the directories (sadly if you have put other zip files into the source directory the verify process will not goes to error...)
  3. Run rapidwiz program as root - you will need and X server (for example vnc)
    1. Fulfill the parameters throug the Rapid Wizard, for example
      1. choose between "create new configuration" and "saved configuration" - at this version you could store the rapidwiz configuration in a database too.
      2. choose port pools (yes, pools because you have to choose a port pool for "file system 1" and an other for the "file system 2", remember run and patch edition)
      3. give the right parameters for database node. New in this version that you could select for database destination your earlier installed RAC system.
      4. choose licensing type then licensed modules, parameters
      5. select languages and then set parameters for languages (for examples character sets)
      6. set parameters for application nodes. Think before you choose value for "applog distribution" parameter, read guides before you accept the defaulted value.
      7. give passwords. New in this version that you have to give password for weblogic user (username is depends on you) and you could add new password for all database users to (APPS, SYSTEM, products schemas)
      8. wait for check, correct the problems and start the installation
    2. Wait for completion, meantime follow the log files, they could be helpful in understanding the new 12.2 system.
  4. Do the post installation steps, at least these
    1. Install 12415211 if you are on RHEL, OEL 6 OS.
    2. Check workflow settings in the wf tables, for example the wf_agents table still contain wrong values in the address column.
    3. Add new redo log groups - if you don't add later patch steps could be goes to error or will be very, very slow
    4. set aq_tm_processes=2;
    5. set job_queue_processes=10;
    6. If you are not user Project module disable PALIBR (PA Streamline Manager) manager. It is extremly slow down the application tier shutdown.

Enable online patching

This is the most "interesting" step. When I read first time this step in the installation guides I don't believe it. You know one of the most "marketinged" feature is the online patching and the base 12.2 system doesn't contain in? It's unbelievable...

For enabling online patching do these steps
  1. Apply the following database patches mentioned by the guide an the 1349240.1 note. Most of them already under the unzipped startCD folder.
    1. 16702016 - ORA-7445 [KGLOBCL()+487]
    3. 17047617 - MERGE REQUEST ON TOP OF FOR BUGS 15967134 12657924
  2. Prepare you EBS system for enabling online patching, the following should be done the applmgr user and source the run edition enviroment.
    1. Create the online patching log file location and set it as the current directory
      1. mkdir $LOG_HOME/appl/op
      2. cd $LOG_HOME/appl/op – not necessary, just for report
    2. Verify database tablespace free space
      1. Set the HOSTNAME environment variable before executing the online patching tool adop. Hostname should be like this: HOSTNAME=<your-hostname-without-domain>
      2. Run the following report to retrieve the current tablespace free space
        1. perl $AD_TOP/bin/ apps
          1. Select option 3 - 'Other Generic Reports'
          2. Select the next option - 'Free Space in Important Tablespaces'
          3. Enter the password when prompted.
          4. Check the output and correct any problem.
    3. Run the Online Patching Enablement - Status Report
      1. Set the current directory to $LOG_HOME/appl/op:
        1. cd $LOG_HOME/appl/op
      2. Run the report using the following command.
        1. sqlplus <apps username> @$AD_TOP/sql/ADZDEXRPT.sql
        2. Enter the apps password when prompted.
        3. Check the output and correct any problem.
      3. Save the output as pre_dbprep for future reference, such as:
        1. mv adzdexrpt.txt adzdexrpt_pre_dbprep.txt
    4. Apply the Online Patching Enablement patch. Download and apply the Online Patching Enablement patch: 13543062:R12.AD.C.  Use Autopatch in hotpatch mode to apply the patch
      1. If you have stopped the system start at least the weblogic admin server before applying the patch. 
        1. $ADMIN_SCRIPT_HOME/ start
      2. unzip 13543062 patch into the PATCH_TOP directory. (PATCH_TOP is allways under the non edition file system's directory, fs_ne/EBSapps/patch). The adop tool will search for patch files under PATCH_TOP if you not specify the patch's directory in the command prompt.
      3. run the adop tool in hotpatch mode
        1. cd <patch_top>/13543062
        2. adop hotpatch=yes
        3. enter the required parameters
      4. Monitor the Online Patching Enablement patch application.
        1. sqlplus <apps Username> @$AD_TOP/sql/ADZDSHOWDDLS.sql
      5. When adop tool finish 
        1. Compile Invalid Objects (if any)
        2. Run the Online Patching Enablement Status Report after the Online Patching Enablement patch has been applied
        3. Re-run the Online Patching Enablement Readiness Report after the Online Patching Enablement patch has been applied – with SYSTEM user!!!
        4. Run the Online Patching Database Compliance Checker report to check for coding standards violations
        5. The above report will contain error messages on an very new empty system too. I have ignored them, it is recommended to check the support site for every error messages.

Apply AD and TXK RUP patches

Apply the 12.2.2 AD and TXK Release Update Packs. Use the 1560906.1 note. First download patches (15955263, 15946788) if you don't do it already.

Apply 15955263, 15946788 patch. 

  1. prepare with adop
  2. copy out adgrants.sql from 15955263 into db tier's oracle home. (put it under appsutil/admin directory)
  3. run adgrants.sql as oracle user
  4. unzip both patch zip files into PATCH_TOP (fs_ne/EBSApps/patches)
  5. apply both patch with adop
    1. adop phase=apply patches=15955263
    2. adop phase=apply patches=15946788
  6. finalize
  7. cutover
  8. cleanup
At a fresh install the above adop commands takes more time as usual. (beaware after the cutover the run and patch edition will be inverted, the cleanup should be done with the same session as cutover's session)

Install 12.2.2 patch

Now you could apply the main 12.2.2 suite wide RUP patch.
Unzip 16207672 patch into a directory. I don't recommend to unzip this patch into PATCH_TOP, because it's huge size. 
After unzipping apply the patch.
  1. prepare the system with adop
  2. apply 16207672 with adop, if you unzipped the patch into an other one as PATCH_TOP then use this example command
    1. adop phase=apply patchtop=<directory that contain the 160207672 dir> patches=16207672
    2. there were some error during running XDOLoader and other tasks, but the automatic retry solved the problem (or not…, but not stopped with error…)
  3. Source the patch edition environment file and run this commands
    1. $ADJVAPRG \
      -e $CONTEXT_FILE \
      -d $FND_TOP/admin/driver/ohstmpl.drv \
      -tmpl $FND_TOP/admin/template/ssl_conf_FMW.tmp
    2. $ADJVAPRG \
      -e $CONTEXT_FILE \
      -d $FND_TOP/admin/driver/ohstmpl.drv \
      -tmpl $FND_TOP/admin/template/mod_wl_ohs_conf_FMW.tmp
  4. Source the run edition environment file
  5. finalize
  6. cutover
  7. cleanup
  8. fs_clone - it's recommended at a later step, but why not now?

Post 12.2.2 steps

So let's finalize the 12.2.2 system.
  1. adding new languages - if you need
    1. From Oracle Applications Manager, go to License Manager and activate or change your base language to a new one.
    2. From AD Administration, run Maintain Multi-lingual Tables (AD Administration Main Menu > Maintain Applications Database Entities Menu).
    3. Prepare the system 
    4. Apply R12.2 NLS Patch 10124646 for each of the new languages in the system.
    5. Apply 16207672  NLS patches
    6. Apply 15955263, 15946788 NLS patches
    7. finalize
    8. cutover
    9. cleanup
  2. If your are using HR module then apply latest legislation data update.
  3. Grant flexfield value set access to specific users.
  4. Install Online Help

No comments:

Post a Comment