oracle 实例死掉,Oracle 监听莫名死掉

有一台oracle 10g的监听莫名死掉，进行查看

select * from v$version

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

select status,count(*) from v$session group by status order by count(*) desc;

查看链接的session 情况

==在listener.ora 中添加

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

connect_timeout_listener=2

lsnrctl set log_status off

mv listener.log /tmp

lsnrctl set log_status on

[oracle@hongquan archivelog]$ lsnrctl

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 20-AUG-2015 01:56:18

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> help

The following operations are available

An asterisk (*) denotes a modifier or extended command:

start stop status services

version reload save_config trace

spawn quit exit set*

show*

LSNRCTL> show

The following operations are available after show

An asterisk (*) denotes a modifier or extended command:

rawmode displaymode

rules trc_file

trc_directory trc_level

log_file log_directory

log_status current_listener

inbound_connect_timeout startup_waittime

snmp_visible save_config_on_stop

dynamic_registration enable_global_dynamic_endpoint

oracle_home pid

connection_rate_limit valid_node_checking_registration

registration_invited_nodes registration_excluded_nodes

remote_registration_address

LSNRCTL> show inbound_connect_timeout

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.32.8)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID_NAME=hongquan)))

LISTENER parameter "inbound_connect_timeout" set to 60

The command completed successfully

LSNRCTL> SET INBOUND_CONNECT_TIMEOUT 2

LSNRCTL> set save_config_on_stop on #表示修改参数永久生效，否则只是临时生效

解决方案:

在Oracle Net Server tracing/logging中出现这个错误，请在sqlnet.ora中设置DIAG_ADR_ENABLED =OFF

在Listener component中出现这个错误，请在listener.ora中设置DIAG_ADR_ENABLED_ = OFF

sqlnet.ora:

SQLNET.INBOUND_CONNECT_TIMEOUT=180

listener.ora:

INBOUND_CONNECT_TIMEOUT_listener_name=120

metlink文档

ORA-609 TNS-12537 and TNS-12547 in 11g Alert.log (Doc ID 1116960.1)

Troubleshooting Guide ORA-609 : Opiodr aborting process unknown ospid (Doc ID 1121357.1)

===

[root@localhost log]# tail -f -n 300 /u01/app/oracle/product/10.2.0/db_1/network/log/sqlnet.log

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

Time: 06-AUG-2015 08:11:17

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505

TNS-00505: Operation timed out

nt secondary err code: 110

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.119)(PORT=61497))

Fatal NI connect error 12547, connecting to:

(LOCAL=NO)

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

Time: 06-AUG-2015 11:45:49

Tracing not turned on.

Tns error struct:

ns main err code: 12547

TNS-12547: TNS:lost contact

ns secondary err code: 12560

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

====清空监听日志

echo '' >listener.log

====

$ echo -e '4294967338-4*1024*1024*1024' |bc

$ dd if=/dev/zero of=listener.log bs=2147483661 count=2

$ echo -e '4294967338-4*1024*1024*1024' |bc

[root@localhost log]# ulimit -a

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 31559

max locked memory (kbytes, -l) 32

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 10240

cpu time (seconds, -t) unlimited

max user processes (-u) 31559

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

Time: 19-AUG-2015 11:30:30

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12606

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

Time: 19-AUG-2015 11:30:30

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12606

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

总结

以上是生活随笔为你收集整理的oracle 实例死掉,Oracle 监听莫名死掉的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。