有2个虚拟机 一个安装oracle A ,一个安装远程客户端 B
在A端C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN 中修改 listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl) 改为自己的服务名 此处我是oracl
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.102)(PORT = 1521)) 修改为自己的ip地址
)
)
重启oracle 服务器
在B端
解压oracle客户端
二. 环境变量
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN = D:\install\PLSQL\instantclient_11_2 -->指向tnsnames.ora目录
三. PL/SQL Developer 环境设置
1. 位置
工具 -> 首选项 -> 连接
2. 设置
Oracle主目录名 = D:\install\PLSQL\instantclient_11_2
OCI库 = D:\install\PLSQL\instantclient_11_2\oci.dll
在tnsnames.ora 中添加链接
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)