Oracle 的坑

Oracle 的坑

配置文件的坑

1、异常信息：ORA-12154: TNS: 无法解析指定的连接标识符
原因可能有：

• 客户端安装目录下面\Network\Admin\tnsnames.ora 文件不存在或者没有配置相应的网络连接
• 连接存在空格将导致文件所以连接出错

#  正常连接
orcl2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.158)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
  # 异常连接，因为下面名称有空格开头
   orcl2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.158)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

2、