原 Oracle登录报错ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME
现象
版本:11.2.0.1
ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME
ORA-12543: TNS: 无法连接目标主机
ORA-12543: TNS:destination host unreachable
EZConnect or Hostname Adapter Usage: ORA-12504 (Doc ID 2550189.1)
APPLIES TO:
Oracle Net Services - Version 11.2.0.3 to 18.1.0.0.0 [Release 11.2 to 18.1]
Information in this document applies to any platform.
SYMPTOMS
While attempting to use the EZCONNECT Naming adapter, the following error is returned:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Example: