After Upgrade of Oracle Database Server to 10g Advanced Queues Do Not Register in OID
(Doc ID 313734.1)
Last updated on JANUARY 08, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 22.214.171.124 [Release 10.1 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
Creation of advanced queues in Oracle RDBMS 10.1.0.x does not populate the queues in OID (Oracle Internet Directory) as it did in 9.2. In 9.2, the following steps were necessary to create an advanced queue on the RDBMS server and then have the queue automatically populate in OID:
1. Configure OID with SSL as per <
2. Run NETCA (Network Configuration Assistant) and DBCA (Database Configuration Assistant) to register the database into the server infrastructure.
3. Add the RDBMS_SERVER_DN initialization parameter to the initialization parameter file as per <
4. Set 'alter system set GLOBAL_TOPIC_ENABLED=TRUE' in SQL*Plus and create the queues and queue tables.
In 9.2, this process was sufficient for queues to register in OID. However, in 10g, this does not work.
In 9.2, for databases to register with OID, only SSL authentication could be used. In 10g, SASL (Simple Authentication and Security Layer) can also be used, and configuration GUI tools use it by default when registering a database with OID.
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