My Oracle Support Banner

OUD 12c - DBCA: Register 12.2 DB in LDAP directory OUD 12.2.x fails with error: [DBT-12107] There is no listener associated with the database (Doc ID 2370412.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Unified Directory - Version 12.2.1.3 and later
Information in this document applies to any platform.

Symptoms

 When trying to register 12.2 databases in OUD 12.2.x directory by using DBCA, it fails with the following message:

[FATAL] [DBT-12107] There is no listener associated with the database,that is required for the correct configuration of directory service.

 

This happens on several RAC-1node cluster with 2 to 5 nodes each.

CRS is 12.2.0.1.RU180116
DB is 12.2.0.1.RU180116

$ env |grep ORACLE
ORACLE_SID=HODBA12D1
ORACLE_BASE=/base/oracle
ORACLE_HOME=/soft/oracle/product/rdbms/12.2.0.1

$ unset TNS_ADMIN

$ $ORACLE_HOME/bin/dbca -silent -configureDatabase -sourceDB HODBA12D1 -registerWithDirService true -dirServiceUserName "cn=database,ou=users,ou=xxx,o=xxx" -dirServicePassword "*****" -walletPassword ****
[FATAL] [DBT-12107] There is no listener associated with the database,that is required for the correct configuration of directory service.
ACTION: Register the database with a listener.

By looking in the database, there is actually an registered listener :
SQL> show parameter local_listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.118.5.53)(PORT=1521))

and a remote session can be established. So the listener seems to be ok.

Changes

DBCA is more stringent in 12.2 that it was in previous versions so if any of the checks fail, the clean listener.ora file will be needed.

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!


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