oracle 解决本机ip数据源连接不上的问题

来源：互联网发布：天成账号管家网络异常编辑：程序博客网时间：2024/06/05 06:39

切换到：

D:\orcale\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

原文件代码

# listener.ora Network Configuration File: D:\orcale\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\orcale\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\orcale\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\orcale

修改文件代码

# listener.ora Network Configuration File: D:\orcale\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = D:\orcale\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:D:\orcale\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )(SID_DESC =                (GLOBAL_DBNAME = ORCL)                (ORACLE_HOME = D:\orcale\product\11.2.0\dbhome_1)                    (SID_NAME = ORCL)            )   )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.12)(PORT = 1521))    )  )ADR_BASE_LISTENER = D:\orcale

阅读全文

0 0