Monday, July 25, 2011

FMW 11g Upgrade : MiddleTire Configuration Assistance - Part 7

FMW 11g Upgrade Master Index

After installing the MiddleTire software necessary for Portal and Discoverer , now it is the time to configure the system.

Under ORACLE_HOME/bin/ is the utility which is helping to configure the system.

Configuration Assistant

Create a Domain using the Configuration Assistance

Provide the necessary SCHEMA details and OID Details , then the installer takes to the Configuration Screen

Make sure that there are no errors during the configuration process.

The configuration assistance creates the Domain , Managed Servers for Portal and Discoverer.
The next process would be to upgrade the 10g Portal and Discoverer to 11g FMW

FMW 11g Upgrade : Installing Portal and Discoverer MiddleTire - Part 6

FMW 11g Upgrade Master Index

Download the following software's for Portal and Discoverer
Portal, Forms, Reports and Discoverer (
Portal, Forms, Reports and Discoverer ( 
Portal, Forms, Reports and Discoverer (

We can apply and then apply the patchset. But there was bug when using the upgrading assistance to upgrade the discoverer component. I will post the details of the bug here(to be documented).
So the plan is as follows
- apply with install software only option
- apply patchset with install software only option
- run configuration assistance
- run upgrade assistance 
- upgrade the system to or the latest patchset available.

The above steps might be completely replaced with is available as it would be a one time installation.

A screenshot after applying

A screenshot from patchset installer

I did not install Portal and Discoverer to since there were some issues with the Upgrade Assistance.

Wednesday, July 20, 2011

FMW 11g Upgrade : WebLogic Installation for Portal and Discoverer MiddleTire - Part 5

FMW 11g Upgrade Master Index

Depending on the Fusion Middleware version download the WebLogic Server Installation Software.
Ex: In my case I am installing Portal and Discoverer version and so I downloaded WebLogic 10.3.4

Export the JDK Home on to a environment variable.
export JDK_HOME=/app/tst/ora/as/app/products/java/jdk1.6.0_26
$JDK_HOME/bin/java -d64 -jar wls1034_generic.jar
Extracting 0%.......................................................................................

Select the MiddleTire Home where the WebLogic has to be Installed.

De-Select the QuickStart and complete the Installation.

FMW 11g Upgrade : JDK Installation - Part 4

FMW 11g Upgrade Master Index

Download the latest JDK which is certified with the version of fusion middleware getting installed.

Go to the JDK Staging Area
Run as oracle user ./ jdk-6u26-linux-x64.bin
This process will unzip the JDK under a folder in the same directory
Move the directory to the JDK desired location

oracle@testas[]$ pwd
oracle@testas[]$ mv jdk1.6.0_26 /app/tst/ora/as/app/products/java

Verify the Java Version and look it is compatible with 64bit

oracle@testas[]$ cd /app/dev/ora/as/app/products/jdk
oracle@testas[]$ cd bin
oracle@testas[]$ ./java -d64 -fullversion
java full version "1.6.0_26-b03"

Monday, July 18, 2011

FMW 11g Upgrade : RCU for Discoverer 11g - Part 3

FMW 11g Upgrade Master Index

Before starting with the RCU I wanted to share that Discoverer is the latest supported version. In the future a new version will be available and so RCU utility has to be download accordingly.

The DISCOVERER5 schema in 10g AS will be replaced with a new schema , but the PORTAL schema will not have any change and the same schema will be used.

After installing the RCU you should see TST_DISCOVERER schema in the database.

Monday, July 11, 2011

FMW 11g Upgrade : Portal Schema Validation Pre-Requisite Check - Part 2

FMW 11g Upgrade Master Index

Portal Schema has to be validated before the FMW 11g upgrade. I am installing the SVU patch but it fails that OUI is not compatablie.

oracle@devas[MiddleTire]$ opatch apply /dev/ora/as/app/products/mid/work/patch/10302032 -pre -s portal -p xxxxxxxxxx -c devserver:1524:infdb1 -opatch_pre_end -post -s portal -p xxxxxxxxxxxxxx -c infdb1

Oracle Interim Patch Installer version
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (

Oracle Home : /dev/ora/as/app/products/mid
Oracle Home Inventory : /dev/ora/as/app/products/mid/inventory
Central Inventory : /home/ouastst/oraInventory
from : /etc/oraInst.loc
OUI location : /dev/ora/as/app/products/mid/oui
OUI shared library : /dev/ora/as/app/products/mid/oui/lib/linux/
Java location : /dev/ora/as/app/products/mid/jre/1.4.2/bin/java
Log file location : /dev/ora/as/app/products/mid/.patch_storage//*.log

Creating log file "/dev/ora/as/app/products/mid/.patch_storage/10302032/Apply_10302032_04-21-2011_11-41-18.log"

OPatch requires OUI 10.1 or earlier.
Cannot set up OUI inventory session.

ERROR: OPatch failed because of Inventory problem.

There are two paths now to go further with the SVU either fix it following note 736658.1 or do a manual run.

OPatch failed because of Inventory problem (Doc ID 736658.1)

Oracle Universal Installer 10.1.0.x.x is the default installer in Oracle Application Server 10.1.2.x.x and includes OPatch utility However, since upgrading the Oracle Universal Installer in the middle-tier to10.2.0.4.x, the OPatch utility is also upgraded to

Above error is reported because of incompatibility between the newer versions of Oracle Universal Installer and the OPatch utility. This error is a result of a pre-check executed by the OPatch utility to determine the Oracle Universal Installer prior to updating the patch information to the Inventory.


Downgrade the Oracle Universal Installer to default version bundled with the Oracle Application Server or install the latest version of Oracle Universal Installer compatible with the version of Oracle Application Server.

If this is not possible, install the Portal patch manually. Contact Oracle Support if manual installation of Portal patch is a viable option.

Since the downgrade would take sometime and not sure if that would lead to a successful patch, so I decided to run the suv report manually.

Followed instruction on note SCHEMA VALIDATION UTILITY (SVU) [ID 286619.1]

After running the cleanup script now the database portal schema is ready for the upgrade.

Friday, July 8, 2011

FMW 11g Upgrade Changing the Characterset to AL32UTF8 - Part 1

FMW 11g Upgrade Master Index

One of the pre-requisite task in moving to fusion middleware 11g is converting the existing 10g Infrastructure Database to AL32UTF8 character set.

This document has all the information to do it.

Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) [ID 260192.1]

I had to follow the instructions as per the above doc.
There were two issues for me

1. Package PORTAL.WWCTX_API_PROXY and ORASSO.WWCTX_API_PROXY has to be dropped and recreated after the upgrade.
Solution to solve this is drop the packages and convert the database to AL32UTF8 character set. Then recreate it using note 751442.1

2. Some Portal Tables and ODS Tables were marked as CONVERTABLE by the CSSCAN utility.
Proposed solution as per the document is to export the tables , truncate the rows , convert the database and then import the tables back.

Looks simple but I was worried since some tables where from PORTAL and ODS


Here is what I did
- exported the tables using expdp
- portal tables were giving zero rows in the export
- security policy was stopping from expdp to export the rows
- ran "grant exempt access policy to system;"
- exported the portal tables as system user
- tried to truncate the tables but constraints were stopping me
- so disabled all the constraints for the relevant tables
- truncated the rows
- converted the database to AL32UTF8 characterset
- imported the tables using impdp with exist action as truncate
- all tables went fine except WWV_THINGS
- there were some triggers on that table so disabled them
- re-imported wwv_things
- verified the exported and imported tables row count
- enabled the triggers
- enabled all the constraints that were disabled
- started the middletire
- validated portal and oid

Infra DB Looks good now for the FMW Upgrade 11g.

Fusion Middleware 11g Upgrade

I am recently working on a Fusion Middleware 11g Upgrade Project and in the up coming posts I will share my experience on the same.

Here I will highlight some of the tasks

Current System
- Oracle Application Server 10.1.2
- Discoverer
- Portal
- Oracle Internet Directory

Proposed System
- Weblogic 11g
- Discoverer
- Portal
- Oracle Internet Directory
- Oracle Access Manager ( later moved to Oracle Access Manager because of BUGs)

Moving higher version means more complex the environment as Fusion Middleware 11g has a complete new architecture.

I did the upgrade on the development system and the upgrade process was long. There were a lot of bugs and it took a lot of time to resolve them with Oracle Support. But overall the upgrade is a success. The documented procedures and work around would help me to do the upgrade on Test and Production in a short time frame.

Here are the list of tasks
Part 1. Converting the existing 10g Infrastructure Database to AL32UTF8 Character Set
Part 2. Portal Schema Validation Pre-Requisite Check
Part 3. Discoverer 11g Schema creation with RCU
Part 4. Setting up JDK
Part 5. WebLogic Setup for Portal and Discoverer Middletire
Part 6. Installing Portal and Discoverer Middletire
Part 7. Running Middletire Configuration Assistance
Part 8. Middletire Upgrade Assistance
Part 9. Middletire Schema Upgrade Assistance
Part 10. Middletire PatchSet Installation
Part 11. IDM Setup

List of Issues
FMW 11g Discoverer Plus Error Loading Applet
FMW 11g Post Install using the Verify Option in Upgrade Assistance gives failure message for Discoverer
FMW 11g Portal and Discoverer Post Upgrade verification failed with ORA-7445
FMW 11g Discoverer Upgade Failed while updating ptm5_instance
FMW 11g Discoverer Version Check

Further steps to be updated

Popular Posts