AIA 11g upgrade fails with Errors MDS-01330, ORA-01017 (Doc ID 1320646.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Application Integration Architecture Foundation Pack - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The AIA FP 11.1.1.2.0/SOA:11.1.1.3.0 upgrade to AIA FP/SOA 11.1.1.4.0 procedure, described in the "Oracle Fusion Middleware Installation and Upgrade Guide for Oracle Application Integration Architecture Foundation Pack" , was followed.

In the Upgrade Guide, all the steps were successful until 9.3.3.

In the section 9.3.4, when running the Upgrade Script:

 ant -f UpdateAIAFP11114.xml

the error was reported when deploying the following AIA composites:
  • AIAErrorTaskAdministrationProcess
  • AIAReadJMSNotificationProcess
  • AIAAsyncErrorHandlingBPELProcess
  • AIAB2BInterface
  • AIAB2BErrorHandlerInterface
Sample traces from the "$AIA_HOME/aia_instances/<AIA_INSTANCE>/logs/Update_FPInstallDP_Deployments_<YYYY>_<MM>_<DD>_<HH>_<MM>_<SS>.log" for the "AIAErrorTaskAdministrationApp":
...
[scac] Validating composite ".../Infrastructure/ErrorHandling/src/AIAErrorTaskAdministrationApp/AIAErrorTaskAdministrationProcess/composite.xml"
[scac] error: location {/ns:composite}(12,61): Parse of component type files failed, check the adf-config.xml file : "oracle.fabric.common.FabricException: oracle.mds.confi
g.MDSConfigurationException: MDS-01330: unable to load MDS configuration document
[scac] MDS-01329: unable to load element "persistence-config"
[scac] MDS-01370: MetadataStore configuration for metadata-store-usage "mstore-usage_2" is invalid.
[scac] MDS-01259: The metadata store "oracle.mds.persistence.stores.db.DBMetadataStore" cannot be instantiated.
[scac] MDS-00003: error connecting to the database
[scac] Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
[scac]
[scac] Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...
[scac] MDS-01370: MetadataStore configuration for metadata-store-usage "mstore-usage_3" is invalid.
[scac] MDS-01259: The metadata store "oracle.mds.persistence.stores.db.DBMetadataStore" cannot be instantiated.
[scac] MDS-00003: error connecting to the database
[scac] Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
[scac]
[scac] Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
...


Similar issue is documented in  "Known Issues for Oracle SOA Products and Oracle AIA Foundation Pack for 11g Release 1 (11.1.1.4.0)".
However, this Note addressed the case (<Bug:11659220>) that is specific to Windows OS, while the current OS was Linux.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms