Using OAM 188.8.131.52, After Clone the RCU Schemas from DB1 to DB2, Getting the Error: ORA-04043: object system.schema_version_registry does not exist on DB2
Last updated on MAY 10, 2017
Applies to:Oracle Access Manager - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
After the clone (Only OAM schemas) from DB1 to DB2 then using DB2 for the OAM installation on the Backup server, getting error that table SYSTEM.SCHEMA_VERSION_REGISTRY$ is missing.
And when running the following queries, it does not exist:
SQL> desc system.schema_version_registry;
ORA-04043: object system.schema_version_registry does not exist
SQL> SELECT comp_id, comp_name, owner, version, status, upgraded, modified FROM SCHEMA_VERSION_REGISTRY;
SELECT comp_id, comp_name, owner, version, status, upgraded, modified FROM SCHEMA_VERSION_REGISTRY
ERROR at line 1:
ORA-00942: table or view does not exist
Was this table created part of Database creation or OAM schema creation through RCU ?
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