UPGAST-02003 and MDS-00912 when running psa to upgrade to SOA Suite 11gPS3

Problem:

When upgrading to Oracle SOA Suite 11.1.1.4, there are a series of post-upgrade tasks that must be performed. This involves shutting down the AdminServer and soa_server1 managed servers, and running what is called as the "psa" or "Patch Set Assistant". This script eventually upgrades your database schemas to the 11.1.1.4 versions.

You will probably run "psa"on both the MDS and ORAINFRA schemas.

When running it for the MDS schema:

oracle@/u01/app/oracle/middleware/home_11g/Oracle_SOA1/bin> ./psa -dbType Oracle -dbConnectString //soasandbox:1521/orcl -dbaUserName sys -schemaUserName DEV_MDS

The output is as follows:

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 "DEV_MDS":
Log file is located at: /u01/app/oracle/middleware/home_11g/Oracle_SOA1/upgrade/logs/psa2011-01-25-01-23-08AM.log
UPGAST-02003: schema is not registered in schema version registry: "DEV_MDS"  Exhausted Resultset
The command failed to complete successfully

I can't remember which log file showed me the following error:

<Jan 24, 2011 11:51:47 PM EST> <Error> <oracle.mds> <BEA-000000> <
oracle.mds.lcm.exception.MDSLCMException: MDS-01330: unable to load MDS configuration document
MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid.
MDS-00912: MDS repository is incompatible with the middle tier. Repository version "11.1.1.55.16" is older than minimum repository version "11.1.1.56.27" required.

Solution:

In my case, I noticed that the OWNER and MRC_NAME was incorrectly set for some odd reason. This may have been related to incorrectly running an OEM Agent script against this database.

SQL> SELECT comp_id, comp_name, version, status, mrc_name, owner FROM schema_version_registry;

COMP_ID    COMP_NAME                      VERSION    STATUS      MRC_NAME   OWNER
---------- ------------------------------ ---------- ----------- ---------- ---------------
BAM        BAM Services                   11.1.1.2.0 VALID       DEV        DEV_ORABAM
MDS        Metadata Services              11.1.1.4.0 VALID       SYSMAN     SYSMAN_MDS
ORASDPM    SDP Messaging                  11.1.1.2.0 VALID       DEV        DEV_ORASDPM
SOAINFRA   SOA Infrastructure Services    11.1.1.4.0 VALID       DEV        DEV_SOAINFRA

1. Log in as SYSTEM to the database.

2. Run the following command:

UPDATE system.schema_version_registry$
SET    mrc_name = 'DEV', owner = 'DEV_MDS'
WHERE  mrc_name = 'SYSMAN' AND owner = 'SYSMAN_MDS';

3. Rerun the "psa".


Applicable Versions:

• Oracle SOA Suite 11g (11.1.1.4)

References:

• http://download.oracle.com/docs/cd/E17904_01/doc.1111/e16793/patch_set_installer.htm#CHDCDHHC