Oracle 配置远程连接

来源：互联网发布：单片机读写sd卡编辑：程序博客网时间：2024/06/05 15:05

修改服务器的listener.ora与tnsnames.ora文件中 localhost 改为服务器ip,文件所在目录E：\app\oracle\product\11.2.0\dbhome_1\admin里,
如果在oracle的安装目录找不到上述文件，可以尝试下在环境变量–>系统变量中查找变量名TNS_ADMIN,变量值就是文件所在路径。

tnsnames.ora文件

# tnsnames.ora Network Configuration File: D:\program file\PLSQL Developer 8.0.3.1510\instantclient_11_2\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ZFXFZB =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.220)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = zfxfzb)    )  )ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )LISTENER_ZFXFZB =  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.220)(PORT = 1521))

listener.ora文件

# listener.ora Network Configuration File: D:\program file\PLSQL Developer 8.0.3.1510\instantclient_11_2\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.220)(PORT = 1521))    )  )ADR_BASE_LISTENER = E:\app\Administrator

阅读全文

0 0