FMW 11g Discoverer Version 11.1.1.4.0 Check

FMW 11g Upgrade Master Index


Upgrading Portal+Discoverer Middletire from 11.1.1.3.0 to 11.1.1.4.0
Patch Set p11060983_111140_Linux-x86-64.zip

Using the runInstaller updated the Oracle Home and it was successful.
Then as per the Readme (http://download.oracle.com/docs/cd/E17904_01/doc.1111/e16793/patch_set_installer.htm#CCHBCCGB) , I updated the Schema

Reference FMW 11g Upgrade : MiddleTire 11.1.1.4.0 PatchSet Part 10

Version Check

SQL> SELECT version, status FROM schema_version_registry WHERE owner='PORTAL';

VERSION STATUS
------------------------------ -----------
11.1.1.4.0 VALID

SQL> SELECT version, status FROM schema_version_registry WHERE owner='DEV_DISCOVERER';

VERSION STATUS
------------------------------ -----------
11.1.1.3.0 VALID

SQL>


Now I am seeing that PORTAL has been upgraded to 11.1.1.4.0 but Discoverer keeps in version 11.1.1.3.0 even though 11.1.1.4.0 Patchset is appled.



The reason is documented in the below node
Review Why Does Discoverer Version On Weblogic Console Shows 11.1.1.2 Where As It Should Be 11.1.1.4? (Doc ID 1324782.1)

Applies to:

Oracle Discoverer - Version: 11.1.1.4.0 and later   [Release: 11g and later ]
Information in this document applies to any platform.
Discoverer, 11g, Fusion Middleware

Goal

Why Does Discoverer Version On Weblogic Console Shows 11.1.1.2 Where As It Should Be 11.1.1.4?

Solution

If patch 11060983 to patch from version 11.1.1.2 to 11.1.1.4 completed successfully, then your install is fine and it is at the correct version.

The release notes of this patch discuss the fact that some components do not have version numbers that get successfully upgraded with the patch but that does not represent a problem.

Version 11.1.1.2 represents the base version although it was also originally a patch. Version 11.1.1.4 is a patch level but the fact that your version numbers were not updated is not a problem as other Fusion Middleware components have the same problem.

So no need to worry , but I feel Oracle should give a simple script which can be run after post verification to update the version.