FMW 11g Upgrade Master Index
After the successful installation of FMW MiddleTire 11.1.1.3.0 Portal and Discoverer , here are the steps to get them on the latest patchset level 11.1.1.4.0
Pre Steps
- Make a backup of the Oracle Home
- Make a backup of the Database or a Snapshot of the Database before the upgrade
Step 1: Installing the Middletire Software
Step 2: Upgrading the Schema
Installing the Middletire Software
Download the 11.1.1.4.0 Portal and Discoverer Patchset and start the installer. The runInstaller has only the option to upgrade the Oracle Home.
Upgrading the Schema
Schema Upgrade is not done from the UI and instead there is a Patch Set Assistance Script to do it.
The PSA Script is going to only update the PORTAL Schema and there are no upgrade required for the Discoverer Schema.
Set ORACLE_HOME
Go to $ORACLE_HOME/bi
./psa -dbConnectString //fmwserver:1521/INFDB -dbaUserName sys -schemaUserName portal
Watch the logfile of PSA and you should be able to see if there are any errors.
Recompile the Invalids
Complete all the post upgrade steps as per the patch readme.
PSA Log
After the successful installation of FMW MiddleTire 11.1.1.3.0 Portal and Discoverer , here are the steps to get them on the latest patchset level 11.1.1.4.0
Pre Steps
- Make a backup of the Oracle Home
- Make a backup of the Database or a Snapshot of the Database before the upgrade
Step 1: Installing the Middletire Software
Step 2: Upgrading the Schema
Installing the Middletire Software
Download the 11.1.1.4.0 Portal and Discoverer Patchset and start the installer. The runInstaller has only the option to upgrade the Oracle Home.
Upgrading the Schema
Schema Upgrade is not done from the UI and instead there is a Patch Set Assistance Script to do it.
The PSA Script is going to only update the PORTAL Schema and there are no upgrade required for the Discoverer Schema.
Set ORACLE_HOME
Go to $ORACLE_HOME/bi
./psa -dbConnectString //fmwserver:1521/INFDB -dbaUserName sys -schemaUserName portal
Watch the logfile of PSA and you should be able to see if there are any errors.
Recompile the Invalids
Complete all the post upgrade steps as per the patch readme.
PSA Log
oracle@testas[]$ cd $ORACLE_HOME/bin
oracle@testas[]$ ./psa -dbConnectString //fmwserver:1521/INFDB -dbaUserName sys -schemaUserName portal
Oracle Fusion Middleware Patch Set Assistant 11.1.1.4.0
Enter the database administrator password for "sys":
Enter the schema password for schema user "portal":
Log file is located at: /oraapp/tst/ora/as/app/products/middleware/as_portal_discoverer/upgrade/logs/psa2011-07-14-06-48-09AM.log
Updating the Oracle Fusion Middleware Metadata Schema to release 11.1.1.4.0.
Updating schema for component Oracle Portal.
The command completed successfully
oracle@testas[]$
