rss· 投稿· 设为首页· 加入收藏· 繁體版
当前位置: 火魔网 » 数据库 » Oracle

Linux下修改IP地址后,oracle的监听无法启动,报错

是:Listener不能启动-TNS;12537,TNS-12560, TNS-00507

提示oracle不能启动。检查listener状态,执行listener start,提示:
  ----------------------
  The listener fails to start with the following errors:
  TNS-12537: TNS:connection closed
  TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
  Linux Error: 29: Illegal seek

解决方法:

第一步:编辑tnsname.ora,listen.ora修改其中的IP地址。

第二步:/etc/hosts文件中缺少了127.0.0.1 localhost的信息,加上以后,关闭oracle,再重新启动就可以了。

127.0.0.1 localhost.localdomain localhost

ORACLE的FAQ:

The information in this document applies to:
  Oracle Net Services - Version: 10.1.0.3
  This problem can occur on any platform.
  Symptoms
  The listener fails to start with the following errors:
  TNS-12537: TNS:connection closed
  TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
  Linux Error: 29: Illegal seek
  Generic to Unix platforms.
  Cause
  Wrong syntax in hosts file and also due to the the tnslsnr process was enhanced in
  10.1.0.3 to support FAN(Fast Application Notification) via
  ONS (Oracle Notification Services). This new code opens a socket open on localhost. Therefore
  "localhost" should be defined on the system.
  
  This new code opens a socket open on localhost. Therefore "localhost" should be defined on the
  system.
  Fix
  Change /etc/hosts file to include
  127.0.0.1 localhost.localdomain localhost

顶一下
(0)
踩一下
(0)