</p>这里重起数据库和Listener我认为是没有必要的,我们reload一下Listner应该就可以了.
. ?' K% c6 i( Q4 y[oracle@order admin]$ lsnrctl - i# G' |, _2 J; e6 V
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 19-JUL-2006 15:26:330 g1 B% ^( X7 l$ e. Z. u+ @
Copyright (c) 1991, 2005, Oracle. All rights reserved.3 U w' V6 D9 O( _ e8 T, H( C
Welcome to LSNRCTL, type "help" for information.: u" H4 m4 ?3 n: j
LSNRCTL> reload ! c. Q* V- ^' l& I
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521)))
" j" ?' f& Y$ v" m% dThe command completed successfully. C2 h2 N$ n: ? l4 v
LSNRCTL> services) f6 P$ F. u4 X; p1 {$ ]
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521)))
7 e r: ?/ p( l" ?8 {$ a/ y! r: tServices Summary...! z( ?& e( C' k2 M$ q2 \- R/ j% l
Service "order" has 2 instance(s).- ]% S9 V' w! i# f& G* _
Instance "order", status UNKNOWN, has 1 handler(s) for this service...! O$ W, T/ C2 e$ w! X. `
Handler(s):
% [/ }. z+ b* V, p"DEDICATED" established:0 refused:0
6 t( t5 w/ i2 G5 W9 K) R( b2 GLOCAL SERVER$ E( ^$ r D3 t
Instance "order", status READY, has 1 handler(s) for this service...8 @) z/ n( }$ |1 [4 S; c7 S3 s
Handler(s):$ s5 l; n3 j: B0 b% t
"DEDICATED" established:0 refused:0 state:ready
3 T5 d# ?% }9 p: H( aLOCAL SERVER
# Z2 f- S$ u, ]. J ~! }The command completed successfully * h) u, {+ \+ b+ L8 O) A% m
LSNRCTL> show inbound_connect_timeout4 X+ T. W1 M9 O) g4 [0 p" T
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.9.11)(PORT=1521))): O1 s. L' | d) X
LISTENER parameter "inbound_connect_timeout" set to 0
6 S0 H1 k, I9 @ {$ NThe command completed successfully t) I+ m6 X( P! h4 G/ ^+ b
LSNRCTL> exit
" ~3 G: [3 I* r; Q$ A$ D修改之后,观察了一段时间,目前正常.3 j+ O6 a; O& G. G( G/ b
关于SQLNET.INBOUND_CONNECT_TIMEOUT参数,Oracle建议修改该参数,以避免denial-of-service攻击.
) @- f: f6 X7 B: V' P: i引用一段Oracle文档说明如下:
0 C6 i# D) t ?* R6 n$ RSQLNET.INBOUND_CONNECT_TIMEOUT
- p/ M7 a; s) WPurpose3 C; }2 E8 Q; n, ?: J% d* v
Use the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.5 Z2 F# R, F/ I
If the client fails to establish a connection and complete authentication in the time specified, then the database server terminates the connection. In addition, the database server logs the IP address of the client and an ORA-12170: TNS:Connect timeout occurred error message to the sqlnet.log file. The client receives either an ORA-12547: TNS:lost contact or an ORA-12637: Packet receive failed error message.
4 g- [' ^% y3 `Without this parameter, a client connection to the database server can stay open indefinitely without authentication. Connections without authentication can introduce possible denial-of-service attacks, whereby malicious clients attempt to flood database servers with connect requests that consume resources.
* m' T: m8 v2 j. R" ?To protect both the database server and the listener, Oracle Corporation recommends setting this parameter in combination with the INBOUND_CONNECT_TIMEOUT_listener_name parameter in the listener.ora file. When specifying values for these parameters, consider the following recommendations:
+ ^+ o9 V$ ]# T. C, ]+ I$ `Set both parameters to an initial low value. * `, H0 n" D0 f
Set the value of the INBOUND_CONNECT_TIMEOUT_listener_name parameter to a lower value than the SQLNET.INBOUND_CONNECT_TIMEOUT parameter. 1 ^* t p2 _6 ]) v1 Y5 c0 L
For example, you can set INBOUND_CONNECT_TIMEOUT_listener_name to 2 seconds and INBOUND_CONNECT_TIMEOUT parameter to 3 seconds. If clients are unable to complete connections within the specified time due to system or network delays that are normal for the particular environment, then increment the time as needed.
* U5 C5 ]. i* m1 A! BSee Also:
7 e: B, J* W* T* `$ m {) AOracle9i Net Services Administrator's Guide for information about configuring these parameters & i4 e- j) |/ H8 a; b
Default, r3 h2 P& M) t4 L
None
* T) e x4 H8 b( A3 hExample
+ M/ G' X/ f- z: k$ \0 _- }0 _SQLNET.INBOUND_CONNECT_TIMEOUT=3 |