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 1.0.0.0.63
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 (https://myoraclesupport.oracle.com)

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/liboraInstaller.so
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_JAVA_ERROR=OUI Version: 10.2.0.5.0
OPATCH_JAVA_ERROR=OUI Version: 10.2.0.5.0
OPatch requires OUI 10.1 or earlier.
Cannot set up OUI inventory session.

ERROR: OPatch failed because of Inventory problem.
oracle@devas[MiddleTire]$


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)
Cause

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 1.0.0.0.xx. However, since upgrading the Oracle Universal Installer in the middle-tier to10.2.0.4.x, the OPatch utility is also upgraded to 10.2.0.4.x.

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.

Solution

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.

Popular Posts