标题: DBCA with error [FATAL] [DBT-05509] Failed To Connect To The Specified Databa... [打印本页] 作者: 刘泽宇 时间: 2024-2-25 18:11 标题: 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: