配置plsql链接Oracle数据库（新手）

配置plsql链接Oracle数据库

1. 安装Oracle客户端  、安装plsql客户端并激活  
2. 配置tnsnames.ora文件（路径D:\app\peter\Oracle\InstantClient\network\admin根据你的实际路径设置）

  配置文件如下

 # tnsnames.ora Network Configuration File: D:\app\peter\Oracle\InstantClient\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

cims =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.88)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

1. 配置plsql