[20160512]tnsnames.ora配置文件.txt

[20160512]tnsnames.ora配置文件.txt

--今天再次解决1个tnsnames.ora配置文件.看来这个文件最好不要手工修改!!
--通过例子来说明:

78 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521))
    )
    (SDU = 32768)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = book)
  )
)

-- 注意别名前有一个空格:

d:\tools>sqlplus scott/book@78
sqlplus scott/book@78
SQL*Plus: Release 12.1.0.1.0 Production on Wed May 11 11:16:54 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-12543: TNS:destination host unreachable

--而且出现这种情况,使用Net Manager是无法打开tnsnames.ora配置文件.
--更正后正常.另外参考连接:
http://blog.itpub.net/267265/viewspace-762224/

78 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521))
    )
    (SDU = 32768)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = book)
  )
)

--如果(DESCRIPTION =前没有空格,使用Net Manager是无法打开tnsnames.ora配置文件.但是使用它登录正常.再次做一个记录.
--总之不建议使用编辑器手工改这个文件.