My Oracle Support Banner

13c: OMS Install Fails During Repository Configuration With the Error: ORA-38818: illegal reference to editioned object SYSMAN.AQ$_MGMT_ADMINMSG_BUS_V (Doc ID 2608155.1)

Last updated on OCTOBER 18, 2022

Applies to:

Enterprise Manager Base Platform - Version 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Installing/Upgrading to 13c OMS fails during the repository configuration with the error:

$<ORACLE_HOME>/sysman/log/schemamanager/m_<timestamp>.CREATE/em_repos_config.log

Error encountered executing SQL statement FileName: 'OMS_HOME/sysman/admin/emdrep/sql/core/13.1.0.0/adminmsg/adminmsg_bus_types_upgrade.sql' LineNumber: '82'
SQL Statement: [BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'SYSMAN'||'.MGMT_ADMINMSG_BUS',
queue_payload_type => 'SYSMAN'||'_TYPES.MGMT_ADMIN_MSG',
multiple_consumers => TRUE);

DBMS_AQADM.CREATE_QUEUE (queue_name => 'SYSMAN'||'.MGMT_ADMINMSG_BUS',
queue_table => 'SYSMAN'||'.MGMT_ADMINMSG_BUS');

DBMS_AQADM.START_QUEUE (queue_name => 'SYSMAN'||'.MGMT_ADMINMSG_BUS');
END;
]
java.sql.SQLException: ORA-38818: illegal reference to editioned object SYSMAN.AQ$_MGMT_ADMINMSG_BUS_V
ORA-06512: at "SYS.DBMS_AQADM", line 547
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4429
ORA-06512: at "SYS.DBMS_RULE_ADM", line 296
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 106
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 109
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 97
ORA-06512: at "SYS.DBMS_RULE_ADM", line 290
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3473
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4390
ORA-06512: at "SYS.DBMS_AQADM", line 539
ORA-06512: at line 6

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.