远程连接oracle 客户端

有2个虚拟机 一个安装oracle A ,一个安装远程客户端 B

在A端C:appAdministratorproduct11.2.0dbhome_1NETWORKADMIN 中修改 listener

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) 改为自己的服务名 此处我是oracl (ORACLE_HOME = C:appAdministratorproduct11.2.0dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:appAdministratorproduct11.2.0dbhome_1inoraclr11.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:installPLSQLinstantclient_11_2 -->指向tnsnames.ora目录

三. PL/SQL Developer 环境设置 1. 位置 工具 -> 首选项 -> 连接 2. 设置 Oracle主目录名 = D:installPLSQLinstantclient_11_2 OCI库 = D:installPLSQLinstantclient_11_2oci.dll

在tnsnames.ora 中添加链接

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )