Header Ads Widget

Upgrade from R12.1.3 to R12.2



This documents contains oracle application upgrades R12.1.3 to R12.2.0 release. This is contains several steps for upgradeting EBS R12.2.0 release version.


1.    Pre-requites steps for upgrade

A.      If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media on both application and database tiers:



  1.   compat-libstdc++-296-2.96-138.i386

  2.   compat-libstdc++-33-3.2.3-61.i386
  3.   gcc-4.1.2-48.el5.x86_64
  4.   gcc-c++-4.1.2-48.el5.x86_64
  5.   glibc-2.5-49.i686 (32-bit)
  6.   glibc-2.5-49.x86_64
  7.   glibc-common-2.5-49.x86_64
  8.   glibc-devel-2.5-49.i386 (32-bit)

  9.   glibc-devel-2.5-49.x86_64

10.   libgcc-4.1.2-48.el5.i386

11.   libgcc-4.1.2-48.el5.x86_64

12.   libstdc++-devel-4.1.2-48.el5.i386

13.   libstdc++-devel-4.1.2-48.el5.x86_64

14.   libstdc++-4.1.2-48.el5.i386

15.   libstdc++-4.1.2-48.el5.x86_64

16.   libXi-1.0.1-4.el5_4.i386

17.   libXp-1.0.0-8.1.el5.i386

18.   libXp-1.0.0-8.1.el5.x86_64

19.   libaio-0.3.106-5.i386

20.   libaio-0.3.106-5.x86_64

21.   libgomp-4.4.0-6.el5.x86_64

22.   make-3.81-3.el5.x86_64

23.   gdbm-1.8.0-26.2.1.i386

24.   gdbm-1.8.0-26.2.1.x86_64

25.   redhat-lsb-3.1-12.3.EL.0.2.x86_64

26.   sysstat-7.0.2-3.el5.x86_64

27.   util-linux-2.13-0.52.el5_4.1.x86_64

28.   compat-libstdc++-33-3.2.3-61.x86_64

29.   elfutils-libelf-0.137-3.el5.x86_64

30.   elfutils-libelf-devel-0.137-3.el5.x86_64

31.   elfutils-libelf-devel-static-0.137-3.el5.x86_64

32.   libaio-devel-0.3.106-5.i386

33.   libaio-devel-0.3.106-5.x86_64

34.   unixODBC-2.2.11-7.1.i386

35.   unixODBC-devel-2.2.11-7.1.i386



B.      Take backup of whole file system and database as a cold backup.




·         Take backup of Application file system backup.


1.       Login as applmgr user.

2.       Run . APPSVISION_VIS.env

3.       Shut down  application services.  $cd $ADMIN_SCRIPTS_HOME

4.       Sh adstpal.sh apps/<password>.

5.       tar -cvzf VIS_APPLS_FILESYSTEM_10jun14.tgz tar /u01/app/



·         Take Backup of Oracle database cold backup.


1.       Login as oracle user.

2.       Run . VISION_VIS.env

3.       Shut down  database services.

4.       tar -cvzf  VIS_oradata_11June14.tgz   /u02/app/oracle/oradata/


·         Take Backup of oracle software binaries.


1.       Login as oracle user.

2.       Run . VISION_VIS.env

3.       Shut down  database services.

4.       Tar –czvf VIS_Product_11June14.tgz /u02/app/oracle/product/11.2.0/dbhome_1



·         Disk Space Requirements


1.       Application node file system                                :               64 GB

2.       Database node file system (Fresh install)             :               90 GB

3.       Database node file system (Demo database)        :               200 GB

4.       APPLPTMP                                                          :               1.6 GB



·         Add following parameter to initialize parameter file

1.        *.service_names=VISION, ebs_patch
2.       *.sec_case_sensitive_logon=FALSE

3.       *.local_listener='VISION_LOCAL'

4.       *.plsql_optimize_level=2

5.       *.job_queue_process=4 (number of CPU).

6.        *. recyclebin=off



All custom database objects that are mapped to seeded APIs/Row Handlers must be changed from LONG/LONG RAW to CLOB.



1.  SQL> SELECT package_name,object_name,argument_name,data_type FROM all_arguments WHERE (package_name,object_name) IN (SELECT call_package,call_procedure FROM hr_api_hook_calls) AND data_type = 'LONG';


2.        Checking for Duplicate Records for product hub with apps user

SQL> SELECT COUNT(1) FROM SYS.ALL_IND_COLUMNS WHERE INDEX_NAME = 'EGO_MTL_SY_ITEMS_EXT_B_U2' AND COLUMN_NAME = 'UNIQUE_VALUE'  AND INDEX_OWNER = 'EGO';


3.       Gather schema statistics login as sysdba user.



SQL>FND_STATS.GATHER_SCHEMA_STATISTICS ('ALL', 10, :parallel_degree, 'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');




 Download software for upgrade from edeliver.oracle.com


         Download software from edelivery.oracle.com save to your respective location.

md5sum --check md5sum_Linux64.txt > md5sum_result.txt

When a corrupted file is found, you can use the following to identify which part needs to be re-downloaded.

All software and patches downloads under /u02/nitin/ebs_upgrade_12_2/ location.

Run buildStage.sh (Make sure run this script as root user) 

buildStage.sh is lactated at (/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin)

                $sh buildStage.sh  

Press Enter to continue...

                      Build Stage Menu

   ------------------------------------------------------
   1.     Create new stage area
   2.     Copy patches to existing stage area
   3.     List files in TechPatches directory
   4.     Exit menu

   Enter your choice [4]: 1

            Rapid Install Platform Menu

   ------------------------------------------------------
   1.    Oracle Solaris SPARC (64-bit)
   2.    Linux x86 (64-bit)
   3.    IBM AIX on Power Systems (64-bit)
   4.    HP-UX Itanium
   5.    Exit Menu

   Enter your choice [5]: 2

Running command:


          
/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64


Specify the directory containing the zipped installation media:
/u02/nitin/ebs_upgrade_12_2/R12.2_Source
File list:
/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files is complete.
Unzip command is: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Unzipping V35230-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35231-01_1of5.zip
Unzipping V35231-01_2of5.zip
Unzipping V35231-01_3of5.zip
Unzipping V35231-01_4of5.zip
Unzipping V35231-01_5of5.zip
Unzipping V35802-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35803-01_2of3.zip
Unzipping V35803-01_3of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V35805-01_1of2.zip
Unzipping V35805-01_2of2.zip
Unzipping V35806-01_1of3.zip
Unzipping V35806-01_2of3.zip
Unzipping V35806-01_3of3.zip
Unzipping V35807-01.zip
Unzipping V35808-01.zip
Unzipping V35809-01.zip
Unzipping V35810-01.zip
Unzipping V35811-01.zip
Unzipping V35812-01.zip
Unzipping V35813-01.zip
Unzipping V29764-01.zip
Unzipping V29856-01.zip
Unzip command is: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Applying one-off patches...
All files have been unzipped successfully.
Stage area is confirmed to be complete.
Command = cp /u02/nitin/ebs_upgrade_12_2/R12.2_Source/V35813-01.zip /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

Finished unzipping shiphome.


Directory /u02/nitin/ebs_upgrade_12_2/R12.2_Source/TechPatches

Unzipping Oracle Software Delivery Cloud one-off patches...
Command: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip -d /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/..

Press Enter to continue...
Archive:  /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13877559/p13877559_111160_Generic.zip
.
.
.
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14237793/p14237793_112030_Linux-x86-64.zip
Finished unzipping Oracle Software Delivery Cloud one-off patches.

Press Enter to continue...


Stage Builder will now stage the one-off patches for Linux_x64...

Press Enter to continue...

Copying latest one-off patches to stage area...

Running command:

/u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches


Press Enter to continue...


Press Enter to continue...
Archive:  /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
   creating: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13947608/
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13947608/p13947608_111160_Generic.zip
   creating: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17325559/
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17325559/p17325559_111160_Linux-x86-64.zip
   creating: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/p16275529_10105_LINUX.zip
   creating: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16271876/
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16271876/p16271876_10123_LINUX.zip
   creating: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13579719/
 extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13579719/p13579719_10123_LINUX.zip
.
.
.
.
.
.
          extracting: /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz/bin/../../..       /../TechPatches/DB/15967134/p15967134_112030_Linux-x86-64.zip

Finished copying additional patches.


Verifying stage area...

Directory /u02/nitin/ebs_upgrade_12_2/R12.2_Source/TechInstallMedia is valid.

   ------------------------------------------------------
 1.     Create new stage area
 2.     Copy patches to existing stage area
 3.     List files in TechPatches directory
 4.     Exit menu

     Enter your choice [4]: 4
    Stage Builder exiting...




Ensure that Maintenance Mode is enabled (required)

Maintenance Mode restricts logins and the type of operations that the system can perform.

1.       $. . APPSVISION_VIS.env
2.       adadmin
3.       5. Change Maintenance Mode
4.       1 Enable Maintenance mode
5.       Exit




2. Start installation of Application of R12.2.0 as a root user.



     $ cd /u02/nitin/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz
    $./ rapidwiz




















A.      Oracle E-Business suite release 12.2.0 rapid install Wizard.

Click on Next button to proceed.






























B.      Wizard operation

Here, choose Upgrade to Oracle E-Business suite Release R12.2.0 and press Next button to continue.

























C. Oracle Configuration Manager Details Wizard.

deselect check box to avoid any updates from My Oracle support.  Click next.



























D. Select Upgrade Action wizard.

First select "Create Upgrade File System" to configuring and creating an upgrade file system or upgraded database.


























E. Global System Settings Wizard.


Specify the port pool values for port pooling and press on Edit ports for specify DB port.

























F.  Database node configuration wizard.

Fill all details about database host, SID, Port, Domain Name, DB OS User, Base Directory and RDBMS ORACLE_HOME.

Dont forget to select "User Existing Oracle Home (No New Database Home Install).
















H. Review Application User Information wizard.

Provide APPS user password details and review APPLSYSPUB and GUEST user details.


























I. Internationalization Settings Wizard.

Select your database character set and press Next.

























J. Primary Application Node wizard.

Fill all details in below wizard for application node and verify the apps base directory , instance home directory and click on Edit Services, enabled all services as Application and db are running on single server.

Press Next to continue.




























L. Application User Information

Enter weblogic handy password and application OS user password.

























M. Install Wizard Alert.

Click OK to continue.

























N. Node Information Wizard.

It will display all node information. Press Next to continue.

























O. Validate system Configuration Wizard.

This is pre-install validation steps. all must be completed with green yes mark.

If its failed any of area of the prerequisites checks, then we have to fix the issue first and press retry button.

























Q. Component Installation Review Wizard.

list of component will be installed after rapiz wizard is completed successfully.

Press Next to continue.


























R. Oracle E-Business Suite Rapid Install Wizard alert.

Wizard alert is confirmed to upgrade E-business suite to R12.2.0.

Press Yes.



























S. Install in Progress.































At 38% installation got hangs and very slow and sometimes it will through errors also.

I faced below error at 38% .

ERROR:



Error:

Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: OPatch process failed : Exit=102 See log for details. CMD= perl /u01/app/applmgr/fs2/FMW_Home/webtier/OPatch/opatch.pl apply -verbose -silent   -ocmrf /u01/app/applmgr/inst/fs2/inst/apps/VISION_VIS/temp/ASInstallHome/fnd/admin/template/txkForms_ocm.rsp  -jdk /u01/app/applmgr/fs2/FMW_Home/webtier/jdk /u01/app/applmgr/inst/fs2/inst/apps/VISION_VIS/temp/patches/7695070/7695070

at oracle.apps.fnd.txk.config.OPatchActionNode.processState(OPatchActionNode.java:296)
 at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)
 at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)
 at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)
 at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)
 at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)
 at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)
 at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)
 at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)
 
Cannot install one-off patches
RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running APPL_TOP Install Driver for VISION instance


Solutions:



RapidInstall Errors On FMW patching: RW-50010 / RW-50004 and BSU process failed (Doc ID 1675554.1)
 


























T. Installation wizard is completed.

Press Finish button to completed wizard operation.






















 









3. Apply AD R12.2 and CPU Upgrade patches

  -Download all ad patches

Patch# p18303441_R12.AD.C_R12_LINUX.zip
Patch# p17197279_R12.AD.C_R12_LINUX.zip
Patch# p10117518_R12_LINUX.zip

Merge all AD patches at /u02/nitin/ebs_upgrade_12_2/AD_source/merge_adall

1) Run environment file . APPSVISION_VIS.env
2) Go to /u02/nitin/ebs_upgrade_12_2/AD_source /merge_adall
3) $ adpatch options=nocopyportion, nogenerateportion


Run the American English upgrade patch driver

1) Run environment file of fs1 file system.
2) Go to $AU_TOP/patch/115/driver
3) adpatch options=nocopyportion, nogenerateportion

Note: this step is take too long time for apply.

Disable Maintenance mode.

1) Run environment file of application file system.
2) $adadmin
3) Select Change maintenance mode
4) Select disable maintenance mode.
5) Exit
 


4.  Configure Release R12.2 E-Business Suite Instance.



A.    Update the RDBMS ORACLE_HOME file system with Auto Config and Clone files.

1) Run environment file of application file system.
2) $perl <AD_TOP>/bin/admkappsutil.pl
3) Copy to RDMBS_HOME (DATABASE HOME)
4) unzip -o appsutil.zip


•    Generate a new database context file

1) $cd <RDBMS ORACLE_HOME>/appsutil/bin
2) $perl adbldxml.pl

•    Run AutoConfig on the database tier nodes

1) $Cd <RDBMS ORACLE_HOME>
2) $cd appsutil/bin/
3) $adconfig.sh contextfile

•    Run AutoConfig on the Apps Tier.

1) Run environment file on apps Tier.
2) Login to as apps/apps user
3) Prior to running AutoConfig check if table - ADX_PRE_AUTOCONFIG is existing in APPS schema:

    Select object_name, object_type, owner, status from dba_objects where    upper(object_name) = 'ADX_PRE_AUTOCONFIG' and object_type='TABLE' and upper(owner)='APPS';
   
4)

    Cd $AD_TOP/patch/115/sql
    Sqlplus apps/appson
    Sql> @txkDropAdxPreAutoConfig.sql

7) Run Autoconfig: go to $ADMIN_SCRIPT_HOME/
8) $sh adautocfg.sh







5. Run Rapid Install to configure Release 12.2 E-Business Suite instance


You must run Rapid Install a second time to complete the configuration using Run File System context file.











 

 





Oracle E-Business suite release 12.2.0 rapid install Wizard.




  





















Wizard Operation.

Select “upgrade to oracle E-business suite release 12.2.0” and press “next” to continue.
 
    





















Oracle configuration manager detail Wizard

Uncheck “I wish to receive security updates via my oracle support”  and press “next”.





















 






Select Upgrade Options wizard


Select an existing application context file from newly installed file system.

$INST_TOP/appl/admin/<CONTEXT_FILE_NAME>
















 
















Review Application user information


This is asking for Apps username and password and guest username and password and Weblogic admin password we have to provide password that is provided last time installation.



























Component installation Review


Rapid install wizard will now going to install and configure all components.

















Install in progress

Rapidwiz is preparing file system for configuring in progress.

 














 



Post- install checks

Check validate complete installation. press next then it’ll run Autoconfig on application tier.

















 







FINISH

In above steps is ran Autoconfig and give setting of database and Middle-tier information and with this we finished installation of configurations.

Press Finish button to complete wizard operation

















 




References:

http://docs.oracle.com/cd/E51111_01/current/acrobat/122upg12.pdf
Oracle® E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No E48839-02
Doc ID 1320300.1: Oracle E-Business Suite Release Notes, Release 12.2.
Doc ID 1378579.1 :  Troubleshooting Rapid Install for E-Business Suite Release 12.2