Oracle 配置tnsnames.ora 文件

2019独角兽企业重金招聘Python工程师标准>>>

安装完成后请修改 tnsnames.ora 文件中用中文标识的三处.

原文:

修改成自己的配置名 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 服务器IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 服务器服务名)
    )
  )

修改后:

BSOFT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

转载于:https://my.oschina.net/lzwenme/blog/266122