PL/SQL配置oracle客户端,登录远程数据库配置
时间:2021-07-01 10:21:17
帮助过:3人阅读
.
0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.30.152)(PORT =
1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY =
EXTPROC1521))
)
(CONNECT_DATA =
(SID =
CLRExtProc)
(PRESENTATION =
RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.30.152)(PORT =
1521))
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME =
orcl)
)
)
2.将NETWORK文件夹拷贝到instantclient_11_2文件夹下
3.将instantclient_11_2文件夹直接复制到PL/SQL的安装目录下
4.打开PL/SQL, 设置PL/SQL中的”工具”>”首选项”>1,2两处:
5.“确定”, 重启PL/SQL登录即可.
注意:
1.客户端版本与计算机版本需要对应
2.ip, port, 实例名
3.路径尽量不包含中文
感谢:PLSQL Developer安装、tnsnames.ora配置 解答
PL/SQL配置oracle客户端,登录远程数据库配置
标签:div list 直接 .com png 重启 路径 实例 article