1、下载
2、创建network\ADMIN 目录和tnsnames.ora 文件
需要先设置:
添加内容
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.15.242.143)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.166.134)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3、配置plsql工具
用户名:登录用户名
密码:登录密码
数据库:IP:端口/数据库