redhatserver5中监听器启动不起来

本文讨论了在使用RedHat Enterprise Linux Server 5.2与Oracle Database 10g时,监听器启动失败的问题。通过修改/etc/hosts文件中的IPV6地址配置为IPV4本地回环地址,成功解决了TNS错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

操作系统:Red Hat Enterprise Linux Server release 5.2 (Tikanga)
oracle数据库:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

[@more@]

本机上sqlplus "/as sysdba"是可以进入数据库的,在启动监听器时出现如下情况:

[oracle@btasetl log]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-10ÔÂ-2009 09:52:59
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS13.gifrotocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek

上网上找了一下,说是有可能是/etc/hosts文件的问题,我按照方法试了后还是不行

$ORACLE_HOME/network/log/listener.log文件内容如下:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 13-10ÔÂ-2009 09:45:22

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Trace information written to /u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Trace level is currently 0

Started with pid=22993
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=btasetl)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))


其中/u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc这个文件没有
/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora的内容为:


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = btasetl)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

/etc/hosts文件的内容为:
::1 localhost.localdomain localhost
10.1.71.152 btasetl

后来把hosts中的内容变为

127.0.0.1 btasetl localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

就可以了,原来::1是IPV6地址,不能配localhost

而IPV4本地回环地址才可以配localhost

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7490392/viewspace-1027804/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/7490392/viewspace-1027804/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值