oracle和操作系统冲突的问题。

最新推荐文章于 2025-01-15 15:33:43 发布

原创最新推荐文章于 2025-01-15 15:33:43 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #list #network #数据库 #jdbc #file

部署运行你感兴趣的模型镜像

今天在部属系统时，JDBC连接数据库报出：java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(ERR=12518)(VSNNUM=150999297)(ERROR_STACK=(ERROR=(CODE=12518)(EMFI=4))(ERROR=(CODE=12571)(EMFI=4))))的异常。

怀疑是数据库监听器问题，监听器路径如下：$ORACLE_HOME/network/admin/目录下的listener.ora文件。

原文件如下：

# LISTENER.ORA Network Configuration File: E:/oracle/ora90/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521)) ) ) )

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:/oracle/ora90) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = zzjinhui) (ORACLE_HOME = E:/oracle/ora90) (SID_NAME = ZZJINHUI) ) )

修改为（增加DIRECT_HANDOFF_TTC_LISTENER = OFF）：

# LISTENER.ORA Network Configuration File: E:/oracle/ora90/network/admin/listener.ora # Generated by Oracle configuration tools. DIRECT_HANDOFF_TTC_LISTENER = OFF LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521)) ) ) )

保存。重起监听器，问题解决。另外。查看基本信息的语句是：select * from v$instance

您可能感兴趣的与本文相关的镜像