配置Oracle本地Net服务名

配置Oracle本地Net服务名, 我理解为在本地用PL/SQL链接远程数据库。

方法一：

 打开oracle的Net Configuration Assistant，选择“本地Net服务名配置”，按部就班进行配置即可。

参考资料：

http://blog.csdn.net/bigbighello/article/details/4538622

http://database.ctocio.com.cn/482/12201982.shtml

http://wenku.baidu.com/view/6be6681aa8114431b90dd8ee.html

 

 

方法二：在OracleInstantclient客户端文件夹的tnsnames.ora中直接新增配置。

# tnsnames.ora Network Configuration File: D:\OracleInstantclient_11_2\tnsnames.ora
# Generated by Oracle configuration tools.

LOCALORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )