Google
      
发新话题
打印

关于tns连接的问题

关于tns连接的问题

关于tns连接的问题


各位大虾,小弟最近遇到一个很头痛的问题,一天数据库重新启动了,但是没有关闭listener,导致一个客户端老在尝试连接,但都报TNS-12518 TNS:listener could not hand off client connection  错误,但是数据库起来后其他客户都可以连接上数据库,就是之前一直在尝试连接的客户端连接不上数据库,难道oracle有一个锁定某个客户端连接的profile或者是参数之类的吗?不是很清楚,不知哪儿大虾可以指点一下,谢谢,下面是相关的信息:

From the logfile:
11-APR-2008 02:30:28 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1633)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58894)) * establish * edwd * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=reportc)(GLOBAL_NAME=reportc.cert.gai.com)(CID=(PROGRAM=)(HOST=cvgsq01)(USER=pmmgrc))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.16.20)(PORT=50579)) * establish * reportc * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58901)) * establish * edwd * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=reportc)(GLOBAL_NAME=reportc.cert.gai.com)(CID=(PROGRAM=)(HOST=cvgsq01)(USER=pmmgrc))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.16.20)(PORT=50580)) * establish * reportc * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58899)) * establish * edwd * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1632)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer
11-APR-2008 02:30:31 * service_update * edwd * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1624)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer

TOP

该时间段对应的alert信息:
Fri Apr 11 02:00:51 2008
WARNING:Oracle instance running on a system with low open file descriptor
        limit. Tune your system to increase this limit to avoid
        severe performance degradation.
PMON started with pid=2, OS id=9572
PSP0 started with pid=5, OS id=9607
MMAN started with pid=3, OS id=9615
DBW0 started with pid=4, OS id=9684
LGWR started with pid=6, OS id=9692
CKPT started with pid=7, OS id=9702
SMON started with pid=8, OS id=9771
RECO started with pid=9, OS id=9849
CJQ0 started with pid=10, OS id=9870
MMON started with pid=11, OS id=9914
Fri Apr 11 02:01:20 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=10002
Fri Apr 11 02:01:39 2008
starting up 1 shared server(s) ...
Fri Apr 11 02:02:00 2008
alter database mount
Fri Apr 11 02:02:05 2008
Setting recovery target incarnation to 1
Fri Apr 11 02:02:05 2008
Successful mount of redo thread 1, with mount id 908349592
Fri Apr 11 02:02:05 2008
Database mounted in Exclusive Mode
Completed: alter database mount
Fri Apr 11 02:20:06 2008
WARNING: inbound connection timed out (ORA-3136)
Fri Apr 11 02:33:19 2008
alter database open
Fri Apr 11 02:33:21 2008
Thread 1 opened at log sequence 1401
  Current log# 3 seq# 1401 mem# 0: /oracle/datafiles2/redo1/edwd/redo03_01.log
  Current log# 3 seq# 1401 mem# 1: /oracle/datafiles2/redo2/edwd/redo03_02.log
Successful open of redo thread 1

TOP

哈哈,顶你了哦.

TOP

限量版手表引起抢购热潮,谁会是这百分之一的幸运儿

限量版手表引起抢购热潮,谁会是这百分之一的幸运儿




手表是作为一种有功能性的饰品而被大家所喜爱着。但是随着时代的发展,手表的计时功能好像不怎么被人所重视了,而手表的装饰功能却被许多时尚一族津津乐道。许多手表因其独特性和限量发售而显得异常珍贵。
现在介绍的这款在平购宝网络商城上出售的依波路的艺术家系列-GG9129手表是依波路新上市的手表之一。全世界发行1500只,而在中国发售100只。
依波路的艺术家系列-GG9129手表功能:
瑞士ETA2892全自动机械镂通机芯
精致打磨
中心时,分,秒针
动力储存42小时
全精钢表壳
20微米18K玫瑰包金
透视表底
蓝宝石水晶玻璃
鳄鱼皮表带
50米防水功能
从经典浪漫到时尚浪漫的新浪漫主义,人们看到的是依波路超越现在、引领潮流的浪漫主义大旗,自百多年前翩翩起舞的情侣定格为依波路表盘永恒的浪漫时刻起,依波路的这一经典形象就尊崇华贵中闪现着青春的激昂,精致典雅中蕴涵着动感与激情。这就是依波路表对时尚的诠释,也是依波路表所在的独特性。如此的完美的依波路手表,怎么能不去拥有它呢。

TOP

发新话题