After Upgrade of Oracle Database Server to 10g Advanced Queues Do Not Register in OID (Doc ID 313734.1)

Last updated on NOVEMBER 14, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.1.0 to 11.1.0.7.0
This problem can occur on any platform.

Symptoms

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 <<Note 178714.1>>, "Configuration and Test of OID with SSL".

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 <<Note 178714.1>>, "Example of setting up Enterprise User Security with password authentication".

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.

Changes

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.

Cause

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