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

第一.在对方Oracle服务器中添加监听,在B:\Program_Files\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora中加入*号包着的代码:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) )******************************************************* (SID_DESC =* (GLOBAL_DBNAME = XING_ORCL)* (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)* (SID_NAME = ORCL)* )****************************************************** )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(H