Oracle10g局域网成功连接远程数据库步骤

1、第一.在对方Oracle服务器中添加监听,在B:Program_Filesoracleproduct10.2.0db_1NETWORKADMINlistener.ora中加入*号包着的代码:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (PROGRAM = extproc) )* (SID_DESC =* (GLOBAL_DBNAME = XING_ORCL)* (ORACLE_HOME = D:oracleproduct

2、10.2.0db_1)* (SID_NAME = ORCL)* )* )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP)(HOST = PC-20130123OHU)(PORT = 1521) ) )注意:如果你的电脑安装了Oracle10g,请看第二,第三步.如果你的电脑没安装Oracel10g,请路过第二,第三步,看第四步第二.在我方Oracle服务器中添加配置,在B:Program_Filesoracle

3、product10.2.0db_1NETWORKADMINtnsnames.ora中加入*号包着的代码:192.168.1.102是对方计算机局域网的ip,这个ip是你访问远程Oracle数据库所在计算机的ipORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WenWanyong7-PC)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )*XING_ORCL=*(DESCRIPTION =* (ADDRESS_LIST =* (A

4、DDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521)* )* (CONNECT_DATA =* (SERVICE_NAME = XING_ORCL)* )*)*EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )第三.在我方Oracle客户端中添加配置,在B:P

5、rogram_Filesoracleproduct10.2.0client_1NETWORKADMINtnsnames.ora中加入*号包着的代码:192.168.1.102是对方计算机局域网的ip,这个ip是你访问远程Oracle数据库所在计算机的ipORCL_127.0.0.1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521) ) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED) ) )*XING_ORCL=

6、*(DESCRIPTION =* (ADDRESS_LIST =* (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521)* )* (CONNECT_DATA =* (SERVICE_NAME = XING_ORCL)* )*)*第四,在官网下载客户端:instantclient-basic-nt-12.1.0.2.0.zip,下载地址:192.168.1.102是对方计算机局域网的ip,这个ip是你访问远程Oracle数据库所在计算机的ipXING_ORCL=(DESCRIPTION = (ADDRESS_LIST = (

7、ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = XING_ORCL) )把整个文件夹instantclient_11_2拷到d盘,在"计算机"中添加环境变量变量名：TNS_ADMIN变量值：D:instantclient_11_2NETWORKADMIN变量名：NLS_LANG变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK运行plsqldev工具,不登录进入plsqldev界面:工具->首选项-&g

8、t;Oracl 主目录名:D:instantclient_11_2->OCI 库:D:instantclient_11_2oci.dll关闭plsqldev工具,重新运行plsqldev工具,就可以选择XING_ORCL数据库,以用户名:scott,密码:tiger登录,就可以访问远程的数据库啦!第五,对方电脑的防火墙开放 Oracle 的1521端口,win7系统的操作步骤开始->控制面板->Wondows 防火墙->高级设置->入站规则,右键新建规则->选择"端口",下一步->选择"TCP",特定本地端口:1521,下一步->选择"允许连接",下一步->选择"域,专用,公用"