【转】ORA-12528 Oracle 实例无法正常连接一例

查看故障时间的监听日志,如下:

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=33825)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=33826)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=46618)) * establis

h * siebeldb * 12528

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=46618)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=52618)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=33827)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=33828)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=58407)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=58408)) * establis

h * siebeldb * 12528

TNS-12528: TNS:listener: all appropriate instances are blocking new connections

05-OCT-2011 14:02:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=33829)) * establis

h * siebeldb * 12528

 

这部分日志说明实例在重启过程中,监听无法建立连接。

05-OCT-2011 14:03:57 * service_update * siebeldb2 * 0

05-OCT-2011 14:03:57 * service_died * siebeldb2 * 12537

05-OCT-2011 14:03:57 * service_update * siebeldb2 * 0

05-OCT-2011 14:03:57 * service_died * siebeldb2 * 12537

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56843)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56844)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56846)) * establish

* siebeldb * 12514

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56846)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56849)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56851)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=56852)) * establish

* siebeldb * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

05-OCT-2011 14:03:57 *

….

这部分是由于监听没有对应的service注册信息,通过现场了解,由于手工启用了$ORACLE_HOME下的监听命令lsnrctl start,导致scan_listener无法完成正常的注册信息,导致监听无法建立连接。

后通过停掉手工启动的监听,重启scan_listener恢复,但是依旧存在连接超时现象。监听日志如下:

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41074)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49618)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33876)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33877)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=35211)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=35210)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=35213)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33879)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * service_update * siebeldb2 * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=40406)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=35215)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=40403)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41514)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41510)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=35218)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33880)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33881)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33883)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55543)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55544)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55545)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41517)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41522)) * establish

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41517)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41522)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41519)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41518)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49669)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33892)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41525)) * establish

* siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49673)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49671)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33894)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55546)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49674)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41527)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55549)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=55548)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41529)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41530)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41533)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41537)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49678)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49679)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49682)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49679)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49682)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49681)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49683)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=46845)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.195)(PORT=49685)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=46848)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=46846)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.5)(PORT=46849)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41539)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.89.4)(PORT=41543)) * establish

* siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33905)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33901)) * establis

h * siebeldb * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(service_name=siebeldb2)(instance_name=siebeldb2)(UR=A)) * (ADDRESS=(PROTOCOL=tcp)(HOS

T=10.7.8.16)(PORT=37497)) * establish * siebeldb2 * 0

05-OCT-2011 14:40:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=siebeldb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.7.88.194)(PORT=33904)) * establis

h * siebeldb * 0

 

alert日志如下:

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

Wed Oct 05 16:07:28 2011

Time: 05-OCT-2011 16:07:27

Wed Oct 05 16:07:27 2011

Wed Oct 05 16:07:27 2011

nt OS err code: 0

Time: 05-OCT-2011 16:07:26

Wed Oct 05 16:07:28 2011

 

VERSION INFORMATION:

TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 – Production

Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.2.0 – Production

Wed Oct 05 16:07:28 2011

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

Wed Oct 05 16:07:27 2011

 

 

***********************************************************************Wed Oct 05 16:07:27 2011

Wed Oct 05 16:07:27 2011

Wed Oct 05 16:07:26 2011

 

Fatal NI connect error 12560, connecting to:

(LOCAL=NO)

 

通过alert日志中的12560错误,可以判定是由于TCP连接超时导致无法正常连接,而查看当时的监听日志发现,客户端的发起的短连接1秒非常高,大大超过20,在AIX下,监听的处理能力不超过20,当然建议保持在10以下,当并发数量太高,会导致监听无法处理,出现连接超时的现象。

 

10月6日9点多和11点多再次出现无法连接的故障,通过日志和现场监控来看,9点多出现的故障和10月5日相同,是由于短连接太多导致。随后,对此进行了修改,尽量使用连接池来连接。11点多和下午14:30的故障是由于CPU 100%导致。通过资源管理限制部分资源使用不合理的SQL,CPU使用恢复正常。

 

 

建议:

1、修改应用短连接为长连接,避免并发连接太高,尽量保持在10以下

2、不使用Scan地址,直接使用vip。通过下面的命令增加listener:

srvctl add listener -l LISTENER2 -k 1 -p 1522

srvctl add listener -l LISTENER3 -k 1 -p 1523

同时对local_listener作相应的修改。

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.88.10) (PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.88.10) (PORT = 1522))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.88.10) (PORT = 1523))))’ sid=’siebeldb2′;

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569