当前位置:  数据库>oracle

Linux Oracle 10.2.0.1 lsnrctl无法启动

    来源: 互联网  发布时间:2017-04-19

    本文导语: 故障现象:lsnrctl stat后即无任何反应,而SQLPLUS正常: [Oracle@wlserver3 ~]$ lsnrctl stat LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-SEP-2011 23:16:11 Copyright (c) 1991, 2005, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=local...

故障现象:lsnrctl stat后即无任何反应,而SQLPLUS正常:

[Oracle@wlserver3 ~]$ lsnrctl stat

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-SEP-2011 23:16:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

尝试ps -ef|grep lsnrctl后kill -9 杀进程,但杀后重启时也碰到同样问题

尝试ps -ef|grep lsnr(注意和上述命令的区别少了ctl)后kill -9 杀进程,后重启成功

[root@wlserver3 admin]# ps -ef|grep lsnr

oracle    3067 16807  0 Sep10 ?        00:00:01 /oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

oracle   16807     1  0 Jul08 ?        00:02:07 /oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

oracle   18378 18350  0 Sep13 pts/1    00:00:00 lsnrctl stat

oracle   18386 18350  0 Sep13 pts/1    00:00:00 lsnrctl stat

oracle   18423 18350  0 Sep13 pts/1    00:00:00 lsnrctl stat

root     19686 18480  0 01:18 pts/3    00:00:00 grep lsnr

[root@wlserver3 admin]# kill -9 3067

[root@wlserver3 admin]# kill -9 16807

重启成功:

oracle@wlserver3 bdump]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-SEP-2011 01:21:35

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

Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                14-SEP-2011 01:21:37

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@wlserver3 bdump]$ 

补充:处理过程中看到过一个10.2.0.1环境下的BUG,也一并修复掉了

10g Listener: High CPU Utilization - Listener May Hang [ID 284602.1]

Symptoms
1) If the listener is hanging, a sqlnet trace (level 16) will show that the last operation was a fork.

[000068 28-SEP-2004 14:16:17:398] sntpcall: entry
[000068 28-SEP-2004 14:16:17:401] sntpcall: detaching from parent with additional fork 68 bytes to NS buffer

2) netstat -na reports numerous (maybe thousands) of sockets associated with port 6100 in a time_wait status

127.0.0.1.6100 127.0.0.1.55228 49152 0 49152 0 TIME_WAIT
127.0.0.1.6100 127.0.0.1.55229 49152 0 49152 0 TIME_WAIT
127.0.0.1.6100 127.0.0.1.55230 49152 0 49152 0 TIME_WAIT
127.0.0.1.6100 127.0.0.1.55231 49152 0 49152 0 TIME_WAIT
127.0.0.1.6100 127.0.0.1.55232 49152 0 49152 0 TIME_WAIT

3) "sdtprocess" (Solaris), or "top" show that the listener process (tnslsnr) is using a large amount of cpu.

ID Name Owner CPU% RAM Size Started Parent
-----------------------------------------------------------------------------------------------
21145 tnslsnr mseibt 44 9440 22368 13:36:03 1 /u01/app/oracle/product/10.1.0/bin/tnslsnr LISTENER -inherit

4) The 10g(iAS) $ORACLE_HOME/opmn/log on the same system shows the following repeating error in the ons logs:

04/10/01 13:30:43 [4] Local connection 0,127.0.0.1,6100 missing form factor
04/10/01 13:30:43 [4] Local connection 0,127.0.0.1,6100 missing form factor
04/10/01 13:30:43 [4] Local connection 0,127.0.0.1,6100 missing form factor
04/10/01 13:30:43 [4] Local connection 0,127.0.0.1,6100 missing form factor
04/10/01 13:30:43 [4] Local connection 0,127.0.0.1,6100 missing form factor

Changes
- Both 10g(iAS) and Oracle 10g(rdbms) are installed on the same system.
- Oracle 10g (non-RAC) is installed on a system with or without other Oracle installations.

Cause
The Oracle Notification Server (ONS) running in the 10g(iAS) home uses the ports defined in $ORACLE_HOME/opmn/conf/ons.config. The database listener, which is an ONS client, also utilizes the ONS ports identified in its own $ORACLE_HOME/opmn/conf/ons.config. When 10g(iAS) and 10g(rdbms) are installed on the same box, the installer will mistakenly configure identical ONS ports in both homes which creates an buffer iis7站长之家 conflict when both the 10g(iAS) ONS and 10g(rdbms) listener services are running.

In non-RAC environments where Oracle 10g is the only Oracle product on the system, the existence of the ons.config may still cause a hang condition in the listener.

Solution
This issue is corrected in versions 10.2.0.3 and higher.
(or apply backport patch <<4518443>>)

You may also use either of the following 2 workarounds to address this problem:

1)  In the 10g(rdbms) home, rename the $ORACLE_HOME/opmn/conf/ons.config file (so that the listener does not find or use it).

For example:

cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig

(then restart the listener)

     
          - or -  


2)  Explicitly disable the 10g TNS Listener from subscribing to the ONS.

Edit the active 10g  listener.ora file and add the parameter below:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF

where would be replaced with the actual listener name configured in the listener.ora file.

For example, if the listener name is LISTENER (default), the parameter would be:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

(then restart the listener)


References
BUG:3881276 - LISTENER HANGS INTERMITTANTLY AFTER APPLYING 10.1.0.3 PATCHSET
BUG:6017068 - PMON SPINNING IN NETWORKING CODE


    
 
 

您可能感兴趣的文章:

  • linux系统无法启动出错,键盘无法输入
  • 安装Linux7.3后,在Win2K中删掉Linux分区,导致无法正常启动(显示grub>;),且无法从光盘启动,该如何解决?请帮忙
  • windows 和linux双系统,重装windows后,无法启动linux?
  • 我系统安装了win2000,win98,linux,现在登录时只能进入win98和linux,无法进入win2000
  • 达人狂入:linux中木马,文件无法删除
  • linux 无法分逻辑盘
  • 华硕p5b无法安装linux?
  • LINUX系统无法识别到网卡
  • 无法设置路由器的情况下,远程连接linux电脑
  • 在Linux中复制文件如何自动跳过那些损坏的无法被复制的文件。
  • 晕倒!新买的机器无法安装linux!如何办?求救!
  • 急,,Linux下无法正常运行服务
  • 编译后的Linux怎么无法启动
  • linux无法登陆,急~~~~~~~~~
  • LINUX 无法识别DVD光驱,请求帮助
  • linux fstab问题,无法正常启动,急!!!
  • 我的WIN98无法访问LINUX
  • sata硬盘无法安装linux!
  • suse Linux 10 无法启动的问题!
  • linux在重装windows后无法启动
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Mysql服务器登陆,启动,停止等基本操作命令介绍(Linux/Centos环境)
  • 我的LINUX为什么不能选择启动,只能用启动盘启动
  • 98/2000/redhat7.2 装好后98/2000 ghost linux没做启动盘,怎么启动linux?
  • 做redhat linux7.3启动软盘:我的LINUX系统是在hda7上的,但我在这做的启动软盘是要用来启动接在hdc1上的另一个LINUX系统的,请问该怎么办啊
  • linux下安装oracle后使用命令行启动的方法 linux启动oracle
  • 在win2K上,再装linux,原先的Fat32格式的启动区,是不是不可以启动linux,?
  • 在装了xp后再装linux,现在grub默认启动是linux,如何修改,让默认启动为xp?
  • 再线送分:我的硬盘装了REDHAT LINUX,但不启动,软盘启动盘也没了,请问怎样能再次启动?
  • 在我启动linux设成Gnome图片模式启动,如果想启动字符模式,应怎样把级别5改为3吗,教我改法
  • 同机装有Windows和Linux两套系统(先装Win后装Linux),如何使计算机使用Windows的启动模块而不是Linux的启动模块?
  • linux 服务器启动时,机子启动就启动下面的这行命令
  • Linux的安装之后,双重启动一次之后,第二次启动就进入GRUB的命令提示符,如何回到图形化的DOS与LINUX的启动菜单界面?
  • 我机器上装了两个系统,win2000,Linux,现在我机器启动后进入grub命令行,请问我有没有办法恢复Linux或Win2000启动
  • 如何同时在启动菜单中启动LINUX和UNIX
  • 如何修改启动菜单的启动顺序(linux,windows),我想让系统默认启动到windows.谢谢!!
  • 怎么启动的时候没有提示从linux启动?
  • 我先装了XP,又装了Linux,现在Linux只能用启动盘启动,有没有其他方法啊?
  • LINUX REDHAT 启动硬盘不能启动,要怎样做!
  • 我下载了个linux.iso,我想在计算机启动时启动它,
  • 能在笔记本上安装XP和Linux双启动吗?删除Linux时如何保证XP仍能正常启动?
  • win2kserver和redhat7.2共存,win2kserver升级到winxp后,发现linux的启动菜单不见了?怎样才能恢复linux 的启动?
  • linux c/c++ IP字符串转换成可比较大小的数字
  • 在win分区上安装linux和独立分区安装linux有什么区别?可以同时安装吗?(两个linux系统)
  • linux哪个版本好?linux操作系统版本详细介绍及选择方案推荐
  • 在虚拟机上安装的linux上,能像真的linux系统一样开发linux程序么?
  • secureCRT下Linux终端汉字乱码解决方法
  • 我重装window后,把linux的引导区覆盖了,进不了linux怎么办?急啊,望热心的人帮助 (现在有linux的盘)
  • Linux c字符串中不可打印字符转换成16进制
  • 安装vmware软件,不用再安装linux系统,就可以模拟linux系统了,然后可以在其上学习一下LINUX下的基本操作 了?
  • Linux常用命令介绍:更改所属用户群组或档案属性
  • 红旗Linux主机可以通过127.0.0.1访问,但如何是连网的Win2000机器通过Linux的IP去访问Linux


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,