配置plsql链接Oracle数据库
- 安装Oracle客户端 、安装plsql客户端并激活
- 配置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)
)
)
- 配置plsql