OUD 12c / 19c - Register Database via DBCA Fails with Error "[FATAL] [DBT-12107] There is no listener associated with the database ..."
(Doc ID 2370412.1)
Last updated on FEBRUARY 14, 2023
Applies to:
Oracle Database Configuration Assistant - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
When trying to register a 12.2 database against OUD 12c via DBCA, it may fail with the following message...
Below is an example dbca registration attempt with the corresponding error result...
$ ORACLE_HOME/bin/dbca -silent -configureDatabase -sourceDB DBXXXX -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.
The issue has been observed to occur on RAC-1 databases containing 2 to 5 nodes/instances each, with the following database specifics...
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
According to the error message, no listener is associated with the database. However, upon inspecting the database in question, there appears to be a registered listener...
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))
Furthermore, a remote session can be established, so there does not appear to be an issue with the listener itself.
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 |