After Upgrade of Oracle Database Server to 10g Advanced Queues Do Not Register in OID
Last updated on NOVEMBER 14, 2008
Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.1.0 to 126.96.36.199.0
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms