OBIEE 11g: Error: "UPGAST-00224: The specified database does not contain any schemas for Oracle Metadata Services..." when Upgrading from 11.1.1.6 to 11.1.1.7. (Doc ID 1562859.1)

Last updated on FEBRUARY 04, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

You are upgrading from OBIEE 11.1.1.6.x to 11.1.1.7.0. At the stage of executing the Patch Set Assistant for the update of the MDS schema, after entering the Connect String, the DBA user name (sys as sysdba) and password, you get the following error:

UPGAST-00224: The specified database does not contain any schemas for Oracle Metadata Services or the database user lacks privileges to view the schemas.

But the OBIEE schemas do exist on the database (which is set up on Exadata appliance).

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