A few months ago we upgraded our Fusion Middleware Portal environment from 188.8.131.52 to 184.108.40.206. The upgrade went pretty smoothly, especially compared to our 220.127.116.11 to 18.104.22.168 upgrade. It seems that Oracle has replaced alot of the manual post-upgrade tasks with scripts. It seemed much easier this time around.
Below is the upgrade. I'll post a followup shortly with some of the issues I encountered and how they were resolved.
1. Shutdown Portal
a. $FUSION_HOME/PORTALasinst_1/bin/opmnctl stopall;
b. $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_PORTAL
2. Backup application and Database
3. If you haven't already download the patchset from Oracle and extract it.
4. Update WebLogic
$JAVA_HOME/bin/java -jar wls1036_upgrade_generic.jar
Prompted for Configuration manager, Bypassed…
5. Upgrade Portal
Upgrade Portal Schema using the Patch Set Assistant
1. Recompile any INVALID objects:
2. Verify aq_tm_proccesses > 0
show parameter aq_tm_processes;
alter system set aq_tm_processes=1 scope=both;
3. Run the PSA utility
After you put in the database credentials click on the Connect button to select the Portal schema, enter the password and click on Next:
|4.||Recompile any INVALID objects following same steps as above.|
|5||. Verify upgrade was successful|
|SQL> SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY;|