Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.

Wednesday, July 15, 2009

Upgrade Oracle E Business Suite 12.0.X to 12.1.1

This blog is about to describe the upgrading from 12.0.x to 12.1.1
This includes Challanges and issues and fixes during the process of upgrade.

This document refers to Redhat Enterprise Linux 4 update 5., Database, Forms server version and 10g AS Web server 10.1.3

Take a backup of the production before doing (Strong Recommendation)
Metalink Document to refer: 752619.1 (But many challanges ahead if you follow the document)

The as-is server is being 12.0.5 and database is of, we upgraded the Database to using Patchset 6810189
Phase I: Process of Database Upgrade:
1. Unzip the to a temporary directory which is obtained from metalink.
Source the Database Enviroment File from RDBMS_ORACLE_HOME.
Being the database is of version 10gR2 ( no need to verify the timezone using v$timezone.
2. Shut down all the application services, DB, listener, isqlplus and emctl dbconsole.
Please do remember, Take a backup of the database and inventory.
3. Go to unzipped directory and run ./runInstaller
if you are using local inventory then use
./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc

If you want to attach your home to the central inventory then do:
$ORACLE_HOME/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=(SID)_DB_HOME_Version
You will get your oracle Home attached with the central Inventory. You can verify using runInstaller -> Installed Products
Select the home and location from the OUI and then proceed to next.

Once completed, startup the database using
$sqlplus as sys user
SQL> startup upgrade;
SQL> spool 'upgrade10204.log'
SQL> @$ORACLE_HOME/rdbms/catupgrd.sql
At the end the script will return the results of upgrade validity. Verify the validity of the database after upgrade.
SQL> shut immediate;
SQL> Startup;
SQL> $ORACLE_HOME/rdbms/utlrp.sql
This will compile all the invalid objects that are added and not compiled during upgrade.
After compilation:
Shutdown the instance and apply the additional RDBMS Patches using Opatch for E Business Suite upgrade.
Please be sure to have OPatch in the PATH
To Include OPatch in the path use
Using Opatch Apply the following Patches
Don't forget to run adstats.sql from $APPL_TOP/admin again the upgrade process of APPL_TOP. 12.1.1. patchset will run it during its run.
Startup the database. (Time taken for the process to complete ~1h 15mins)
Phase II: (Upgrade 10gAS 10.1.3 to
1.Take a backup of inventory before proceeding.
2. Source the environment file from $INST_TOP/ora/10.1.3
3. Verify echo $ORACLE_HOME as $ORACLE_APPS_BASE/apps/tech_st/10.1.3
4. Ensure that all the OC4J services are up and running.
1. Unzip and Apply Patch 7272722 obtained from metalink using ./runInstaller
If you are using local inventory please use
./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
During the process, the OPMN services will be down and started up by the OUI.
When prompted please give the OC4J admin password as either 'secret' or 'oafm' (As I upgraded two instance, one (12.0.6) was successful with 'secret' and another (12.0.5) by 'oafm'.)
This will complete the 10gAS ( to be upgraded with

Time taken for this procedure ~ 1 hour.
Shutdown the services, Run Autoconfig on the apps Tier.
As per the metalink document, dont upgrade Opatch version to, it failed two times for me during the other patches. I advise you to keep the current Opatch as opatch tool.

Be sure, the path of the Opatch is present in the PATH variable.
Apply the following patches:
(if you are using local inventory, then use
Patch_Directory$opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc)
1. 6702510
(The issue is that.. being a general platform Patch, Opatch will fail at the verification of platform)
use $export OPATCH_PLATFORM_ID=0,
then rerun the opatch apply.
2. Apply 6771776 (If you are getting error during opatch as Platform as 196 then use OPATCH_PLATFORM_ID = 46)
3. 7484199
4. 7411481
5. 7139320
6. 7139339
Post Upgrade steps
Source Application environment file
Regenerate and using adadmin
Navigation: adadmin -> Choose Option 1-> Regenerate Product JAR files -> Force Option: No
Run autoconfig in application tier system.
Verify the Upgrade using:
use ./runInstaller and then select installed products, it will show you the components from WEB_OH that are all upgraded to
use opatch lsinventory -detail
Look for Oracle Application Server Patchset as as follows:
Installed Patch List:
1) Patch 7139339 applied on Fri Jul 17 20:03:46 IST 2009 [ Base Bug(s): 7139339 ]
2) Patch 7139320 applied on Fri Jul 17 20:02:23 IST 2009 [ Base Bug(s): 7139320 ]
3) Patch 7411481 applied on Fri Jul 17 20:00:42 IST 2009 [ Base Bug(s): 7411481 ]
4) Patch 6771776 applied on Fri Jul 17 19:58:55 IST 2009 [ Base Bug(s): 6771776 ]
5) Patch 6702510 applied on Fri Jul 17 19:51:41 IST 2009 [ Base Bug(s): 6702510 ]
6) Patch 5586892 applied on Sat Dec 30 08:18:37 IST 2006
[ Base Bug(s): 5586892 5126270 4689959 5238255 ]
Verification from Opatch lsinventory -detail 7139339]$ opatch lsinventory -detail -
Oracle Interim Patch Installer version
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation underOPatch/docs for usage reference. We also recommend usingthe latest OPatch version. For the latest OPatch versionand other support related issues, please refer to document293369.1 which is viewable from
Oracle Home : /oracle/ACE/apps/tech_st/10.1.3Oracle Home Inventory : /oracle/ACE/apps/tech_st/10.1.3/inventoryCentral Inventory : /oracle/ACE/inst/apps/ACE_samarth/admin/oraInventory from : /oracle/ACE/apps/tech_st/10.1.3/oraInst.locOUI location : /oracle/ACE/apps/tech_st/10.1.3/ouiOUI shared library : /oracle/ACE/apps/tech_st/10.1.3/oui/lib/linux/liboraInstaller.soJava location : /oracle/ACE/apps/tech_st/10.1.3/jre/1.4.2/bin/javaLog file location : /oracle/ACE/apps/tech_st/10.1.3/.patch_storage//*.log
Creating log file "/oracle/ACE/apps/tech_st/10.1.3/.patch_storage/LsInventory__07-17-2009_20-17-29.log"
============ =======
Agent Required Support Files Patch
Agent Required Support Files
Apache Module for Oracle Distributed Authoring and Versioning
Assistant Common Files Patch
Assistant Common Files
Bali Share
DataDirect Connect JDBC Drivers
DBJAVA Required Support Files Patch
DBJAVA Required Support Files
Documentation Required Support Files
Enterprise Manager Minimal Integration Patch
Enterprise Manager Minimal Integration
Enterprise Manager plugin Common Files
Enterprise Manager plugin Common Files
Extended Windowing Toolkit
HTTP Server Files
Oracle Application Server PatchSet
Oracle ASkernel Common
Oracle Business Rules
OPatch succeeded.

Now upgrade the Opatch using 6880880 (Unzip the patch directly into the 10.1.3 Oracle Home)
Do not Start the application services and try to login to the applications using the port. As it throws login page cannot be displayed as the variable in context are pointing to portal/AppsLogin.jsp.

This will be resolved once you complete applying the patch 7303030.

Phase 3: Upgrading the Java JDK

download jdk-6u14-linux-i586.bin
1. Be sure to shutdown all the middle tier services.
(a) Perform JDK Upgrade in IAS_ORACLE_HOME:
Navigate to $IAS_ORACLE_HOME/appsutil/
$mv jdk/ jdk_old/
$mkdir jdk/
copy the jdk-6u14-linux-i586.bin to $IAS_ORACLE_HOME/appsutil/jdk
Install the bin file using
This will install latest jdk in appsutil/jdk
Copy the *.ttf files from $FND_TOP/resource to $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts.
Important: You need to do the steps as a post upgrade step if you complete with 7303030
b) Upgrade jre in $RDBMS_ORACLE_HOME
copy the jdk-6u14-linux-i586.bin to $RDBMS_ORACLE_HOME/appsutil
Source the database environment file
1. Navigate to $ORACLE_HOME/appsutil/
2. mv jre/ jre_old/
3. mkdir jre/
Install the jdk_version_linus-i586.bin to appsutil/jre
Verification of JDK installation
$ADJVAPRG -version
[oracle@prod appl]$ $ADJVAPRG -version
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) Client VM (build 14.0-b16, mixed mode, sharing)
[oracle@prod appl]$ echo $CLASSPATH
$AFJVAPRG -version
[oracle@prod appl]$ $AFJVAPRG -version
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) Client VM (build 14.0-b16, mixed mode, sharing)
Each should reflect the paths belonging to latest JDK like this
[IAS_ORACLE_HOME]/appsutil/jdk/lib/dt.jar, [IAS_ORACLE_HOME]/appsutil/jdk/lib/tools.jar, [IAS_ORACLE_HOME]/appsutil/jdk/jre/lib/rt.jar, and [IAS_ORACLE_HOME]/appsutil/jdk/jre/lib/charsets.jar
Create an jsp file under $OA_HTML like jdktest.jsp
The JDK version is:<%= System.getProperty("java.version") %> :<%= System.getProperty("java.version") % >
compile the jdktest.jsp using ojspcompile, syntax is:
perl -x $FND_TOP/patch/115/bin/ --compile -s jdktest.jsp'
Dont check it now, as your middle tier services are down.
Check with Database Tier:
$cd $ORACLE_HOME/appsutil/jre/bin

./java -version

[oracle@prod jre]$ cd bin

[oracle@prod bin]$

./java -version

java version "1.6.0_14"

Java(TM) SE Runtime Environment (build 1.6.0_14-b08)

Java HotSpot(TM) Client VM (build 14.0-b16, mixed mode, sharing)
Run Autoconfig on both tiers
Phase 4: Forms server Upgrade
In this Phase upgradation of Forms server from to is to be done.
Backup the inventory file.
Source the application environment file
1. Unzip 5983622 and run ./runInstall
2. Supply oc4jadmin as 'secret' when prompted.
(Note here configuration assistant will fail at oc4j configuration Assistant, Simply skip and click next. This is normal behavior for E Business Upgrade)
Once completed:
Apply the Following Patches using OPatch tool from TOOLS_ORACLE_HOME (Upgrade Opatch - Skip this patch)
Note: if you face the error below during any of the Opatch or ./runInstaller: rwconverter error: like this
/ACE/apps/tech_st/10.1.2/lib//librw.a -lnsl/oracle/ACE/apps/tech_st/10.1.2//lib/
/ undefined reference to `rolgxinoci_cid'
collect2: ld returned 1 exit status
make: *** [rwbuilder] Error 1
DO the following:
Restore the file, and librw.a
from old backup to $TOOLS_ORACLE_HOME/lib and run
$TOOLS_ORACLE_HOME/reports/lib/make -f install
The result will be
/oracle/ACE/apps/tech_st/10.1.2/lib,-rpath,/oracle/ACE/apps/tech_st/10.1.2/jdk/jre/lib/i386:/lib:/usr/lib -lm `cat /oracle/ACE/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lpthread -lm -L/oracle/ACE/apps/tech_st/10.1.2/lib -L/oracle/ACE/apps/tech_st/10.1.2/lib/stubs/ -lsnls10 -lpthread -ljvm -lhpi -Wl,-rpath,/usr/X11R6/lib -L/usr/X11R6/lib -lXm -lXt -lX11 -lm -lXp -lXext /oracle/ACE/apps/tech_st/10.1.2/lib//librw.a -lnslmv rwbuilder /oracle/ACE/apps/tech_st/10.1.2/bin/rwbuilderchmod 700 /oracle/ACE/apps/tech_st/10.1.2/bin/rwbuilder
then proceed with the patch, it should complete normally.
Create formsapp.ear
$FND_TOP/bin/ -script=CfgOC4JApp
Enter Application name for re-deployment ? forms
Enter Oc4j Instance password for re-deployment ? welcome (or current password)
? No ">Run Autoconfig ? No
If you are prompted for oc4jadmin password
and is incorrect as 'secret' or 'oafm' then

Do the following:
$cp system-jazn-data.xml system-jazn-data-ori.xml
$vi system-jazn-data.xml
locate oc4j-admin section
[display-name]OC4J Administrator[/display-name]
[description]OC4J Administrator[/description]


!Welcome [Please note '!' is important]

then issue oc4jadmin password as 'Welcome'. it will pass the step.
Run Autoconfig on Apps Tier
Apply Interoperability Patch 7120543
Apply OPatch 6880880 as in the previous section to upgrade Opatch tool to

Rebuild Forms and Reports executables
cd $ORACLE_HOME/forms/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
$ make -f install
cd $ORACLE_HOME/reports/lib32
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
$ make -f install
Regenerate and using adadmin
Phase V upgrading to 12.1.1
Apply AD.B.1 Patch (7461070)
Copy adgrants.sql from patch/admin directory to $RDBMS_ORACLE_HOME/appsutil/admin directory
If it is not present create a directory /admin inside $RDBMS_ORACLE_HOME/appsutil
run adgrants.sql as sys user with syntax
$adgrants.sql apps
once finished, Apply the patch AD.B.1
Recreate grants and synonyms using adadmin
Apply the Main patch 7303030 (Contains 8 parts)
During the patch run, please expect
XDOLoader.class will fail on user xdo
(Completed within 15 hours)
Apply online Help patch 7303031 using adpatch. (It takes 28 minutes)

Apply the product specific patches as per the metalink document stated above.

Start the application services using from $ADMIN_SCRIPT_HOME

Verify the forms version using 'About Applications' from Forms session.
It should show the version as follows

To get other versions, enable about this page link in LOGINPAGE of the server
To do this please do the following:

set the profile option FND: Diagnostics = Yes

Then bounce the middle tier services, you will see a link 'About This Page' at the bottom of the web page

The output of the About this page will give all the particulars about the version upgrade.

Cheers!!! and Best of Luck!!!

1 comment:

Shivani said...

Hey ...
Great Man
It feeds everything..

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts


11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC errors out adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version