DBCA with error [FATAL] [DBT-05509] Failed To Connect To The Specified Databa...

刘泽宇

现象：
The below error may happen while running 19c DBCA.

Error - [FATAL] [DBT-05509] Failed to connect to the specified database <DBNAME>.
CAUSE: OS Authentication might be disabled for this database <DBNAME>.
ACTION: Specify a valid sysdba user name and password to connect to the database.


SEVERE: Sep 10, 2020 10:41:53 AM oracle.assistants.common.base.util.AssistantAdvisor logMessage
SEVERE: [ 2020-09-10 10:41:53.516 EDT ] [FATAL] [DBT-05509] Failed to connect to the specified database <DBNAME>.
INFO: Sep 10, 2020 10:41:53 AM oracle.install.commons.util.exception.AbstractErrorAdvisor advise
INFO: Advice is ABORT
INFO: Sep 10, 2020 10:41:53 AM oracle.install.commons.util.ExitStatusSet add
INFO: Adding ExitStatus INVALID_USER_INPUT to the exit status set


原因：
Incorrect environment variable settings may cause this issue.

解决方法：
1) Review the DBCA logfile completely for all the DBT% errors and Java related errors if any.

     SEVERE: [FATAL] [DBT-05509] Failed to connect to the specified database <DBNAME>.
     CAUSE: OS Authentication might be disabled for this database <DBNAME>.
     ACTION: Specify a valid sysdba user name and password to connect to the database.
2) Check for proper environment variable settings, ex: .profile or .bash_profile or /etc/profile settings.

3) Check for http_proxy and https_proxy environment variable if you have, then unset http_proxy & https_proxy explicitly and retry the DBCA.

4) Check for LD_LIBRARY_PATH, PATH and NLS10 related OS environment variables.

5) Most of the times after setting the LD_LIBRARY_PATH to proper value, the issue will be resolved.

6) If any NLS10/NLS settings exist at OS level, please review the following document: