1,首先必须安装oracle数据库
2,安装PLSQL客户端工具
3,配置PLSQL工具,登录客户端点击取消,然后进入。在配置选项中找到连接选择oci找到oracle安装的路径中的如:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll
4,找到oracle中的配置文件E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora,在里面添加远程地址如下:
MYORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.76)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myorcl2)
)
)
5,测试连接成功