Blank space issue in tns names ora

最新推荐文章于 2026-01-05 18:51:59 发布

原创最新推荐文章于 2026-01-05 18:51:59 发布 · 375 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一个特定的Oracle数据库连接配置格式，并详细解释了如何正确设置TNS名称描述符以避免ORA-12154连接错误。文章强调了在描述符中空白字符的重要性。

ORA11G =  /** No blank space at left. **/
  (DESCRIPTION =  /** have blank space or not at left is ok. **/
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521)) /** must have blank space at left. **/
    (CONNECT_DATA = /** must have blank space at left. **/
      (SERVER = DEDICATED) /** must have blank space at left. **/
      (SERVICE_NAME = ora11g) /** must have blank space at left. **/
    ) /** must have blank space at left. **/
  ) /** have blank space or not at left is ok. **/

If the format about blank space is error, you will get the connection error as below:
ORA-12154: TNS:could not resolve the connect identifier specified