1.配置环境变量
变量名1=变量值1
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
变量名2=变量值2
TNS_ADMIN=E:\Program Files\instantclient_11_2
2.在tnsnames.ora.bak文件中配置要远程访问的数据库,cms57为连接的数据库名称,192.168.1.171是远程访问的ip,port为远程访问的端口号,
*不能有空格
cms57 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.171)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.171)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3.打开PL/SQL development,选择工具——>首选项——>OCI库——>输入d:\program files\instantclient_11_2\oci.dl(*instantclient_11_2的安装路径\cci.dll)保存
4.重新进入PL/SQL development
用户名,密码,选择数据库,即可连接