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
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
.
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.
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