Last updated on MAY 10, 2017
Applies to:Oracle Access Manager - Version 18.104.22.168.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