11gR2中的SCAN监听器和本地监听器配置
来源：互联网 发布：linux 三个时间 编辑：程序博客网 时间：2024/05/24 23:11
11gR2中的SCAN监听器和本地监听器配置
上一篇 /下一篇 2012-02-09 23:38:11 / 个人分类：Oracle RAC
查看( 458 ) /评论( 1 ) / 评分( 5 / 0 )
11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1]
修改时间 29-JAN-2012 类型 HOWTO 状态 PUBLISHED
Information in this document applies to any platform.
/BCr\vs0
:gZF0AM:h6p@0
H U8R#D-e sia0
8ej9T*O:a { \^0Database called "v11gr2"
nn4y m7c0N*m Z xp0Scan listeners called LISTENER_SCAN1 and LISTENER_SCAN2ITPUB个人空间 }U2IX9h t5]B6G
(Most configurations will have upto 3 SCAN listeners configured)ITPUB个人空间%APw+AYF|%T_%gI
DNS setup for the scan address to resolve to 11.111.11.11 or 22.222.222.22
5j$B g,Kn2D)w d0ITPUB个人空间 ^ C f"J7Q9h/a)g
Node 1.
2U$MEgP)Y1s0
w'b^ GQ!Ma0SCAN listener "LISTENER_SCAN1" is currently running on Node 1.ITPUB个人空间h8AM @&isb
Both the SCAN and Node listeners run from the grid oracle home. This the recommend setup.
2lrV*y9s7?0
2q2u6D"w&d%?{Z0Database parameter LOCAL_LISTENER points to Node VIP address
's%c9b4]#sM0
\[Bx7]3Qo0
E1v8x E E[Zy'a0Database Parameter REMOTE_LISTENER points to SCAN nameITPUB个人空间 P2pXc O7B5O
u Pv)j+Hl0Listener.ora Node1
ITPUB个人空间1i\l1yd:Ds
The ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ parameter is set to allow the listener to accept connections for pre-11.2 databases which did not register the dynamicendpoint.ITPUB个人空间J V W'VP+d I3f m
.h&G {n?0Listener status "listener" showing 1 instance registered, ie instance running on the node
X e7TWb0
q6i j:N0\0
&UF6]O1Ew~/`0New file for 11.2 called endpoints_listener.ora, showing the Node IP address and Node VIP address.ITPUB个人空间+gbz0F5Bnu
ITPUB个人空间 bDI1dn2|eWxb
ITPUB个人空间D-b8m3yr ]hp
Endpoints_listener.ora file is there for backward compatibility with pre-11.2 databases.ITPUB个人空间.w4u p-a7m jj
DBCA needs to know the endpoints location to configure database parameters and tnsnames.ora file.ITPUB个人空间Z*X h6Ef({$@
It used to use the listener.ora file, 11.2 RAC listener.ora by default only has IPC entries.ITPUB个人空间1s$O ZMAj
"f/rxT"S/kD"H!q0Listener status "listener_scan1" showing both instances registered from the nodes.
\p.RHh `V0ITPUB个人空间 U`htV0Z!x
ITPUB个人空间4t#VDz&Z v1K$i
Node 2.
C*d&^s?(H0_G0SCAN listener "LISTENER_SCAN2" is currently running on Node 2, along with node listener "listener"ITPUB个人空间;jx S;pG@k4Q9{
ITPUB个人空间%Hb8k/M*t%RK
ITPUB个人空间pZz s fN
Database parameter LOCAL_LISTENER points to Nodes VIP address
,Qg g0vEEuH0ITPUB个人空间7EeN1U[Zwf
(FO d$_/c}0Database Parameter REMOTE_LISTENER points to SCAN name.ITPUB个人空间L.m1AV I u
ITPUB个人空间*oiC*z\O;R
^ [-B0m c(u'rU,{(a)b0"Line added by Agent" is the Oraagent is the process updating the listener.ora and endpoints_listener.ora files.ITPUB个人空间6s1H:r#BW0^7W `
ITPUB个人空间Iy k \z$X&i`F,r
Endpoints_listener.ora showing the Node IP address and Node VIP addressITPUB个人空间o&EP%F9[ [l m
8\ ZbOGP1C]L0ITPUB个人空间s J J/u ~"nm s
Listener status "listener" showing 1 instance registered
1P%uG5?-m0
g*g X9c\%]0R.f ^0ITPUB个人空间 t%d rP!BKQH
Listener status "listener_scan2" showing both instances registered
@ XFR%gN!{#c0ITPUB个人空间d.w&}7{*Vn"h
Further information on the listeners can be found via svrctlITPUB个人空间V&d){ z$B-C9vuq
ITPUB个人空间 bn]!l/L.|
ITPUB个人空间W p'u!f~Z
Calling address used
~Cg0c W ] x)M(O0
"E/I:M-I8]2K+V0f0
Resolve the Scan address and build connection information on address information supplied by DNSITPUB个人空间1t3c}#c8Yj(ub)d'Z
4hj2LYPHD0
Selected Node 1
g9@J(_rK$hW u;~y0
)MKB['kf0
Start of the connection handshake
n8\-d%@&f7mqo5]0
r#J6`s|J0
Redirect packet from Scan TNS listener ITPUB个人空间'[ lY YS
5XN{#UZM3Bjz0
Connection told to redirect to Node 2 Node listener
Bo&hS d0ITPUB个人空间!n m+goT`P
Connection handshake completed (Connect, Resend, Connect, Accept)
I;Z kqu"NW;zY0ITPUB个人空间5yKiz;f;a
After authentication and banner packets pass, we see the select run "nsbasic_bsd" = send
P\ZO3YY0ITPUB个人空间3^J+c-uC
ce K9mSv0And the information received "nsbasic_brc" = receive
]l%i2`9U? W,\`0
`%@@~%IN0TNSNAMES.ORA ITPUB个人空间2S6f5c(J9o2G
ITPUB个人空间X;L,^[4b,]
Pre 11.2 clients will need to the use the SCAN VIP addresses,as they do not contain the code to understand the two addresses returned by DNS, a thus connections would not load balance correctly.
vi8l*s f9L'q#__0
ITPUB个人空间 ^??+XdN'Q7]
ITPUB个人空间0N6[&N y$c"M1U0~F
首先从11gR2开始，SCAN监听器和本地监听器都是通过Grid来管理的，相关的配置文件都是存放在$GRID_HOME/network/admin/目录中，相关的进程运行在grid操作系统用户下。ITPUB个人空间H;v_ e%b
3Q3PT.C^)e {R4F q}0 其次$GRID_HOME/network/admin/endpoints_listener.ora是个向后兼容的文件，其中包含了节点的公共IP地址和VIP地址，Grid必须要能够找到这个文件。$GRID_HOME/network/admin/listener.ora文件中的ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ 参数表示当CRS在监听上创建动态endpoints，这个参数添加向后兼容性，允许客户端连接到11gR2之前的实例，甚至是没有动态注册到endpoint的实例。ITPUB个人空间c!HT*qIq
ITPUB个人空间 LWMk6J(S?5m
有关监听器的endpoint概念可以参考文章：http://space.itpub.net/23135684/viewspace-715967
z r*^%O*Dr5D0ITPUB个人空间5` Zc({ O ~E7A ~8v)H
1M!f2?.~P%| ]H"\-g[0
+e V xc5m3C2S0ITPUB个人空间 f.w m J-Pn/I
ITPUB个人空间%Th+d%Y%N
修改时间 29-JAN-2012 类型 HOWTO 状态 PUBLISHED
In this Document
6MC^A!H7uKAn3m0 Goal
%~2FZ1TA2uYy0 Solution
:q-B3g]s}j,E0 References
&H0u{)Q }9{A4X,O2ax0
Applies to:
Oracle Net Services - Version: 11.2.0.1 and later [Release: 11.2 and later ]ITPUB个人空间:tD0Ud0rN]ZjqInformation in this document applies to any platform.
/BCr\vs0
Goal
Document to show 11.2 Scan and Node TNS listener examples for RAC, along with client trace connection, showing possible route taken to database from client.:gZF0AM:h6p@0
Solution
Example for 2 Node cluster with 2 Scan listeners running, with following details:ITPUB个人空间 I6n8F6a K.|H U8R#D-e sia0
Ipaddress HostnameITPUB个人空间h6g4Z.[ I*~1[
-------------- -------------------------------------ITPUB个人空间"`8}%D(V f
Scan Addresses:ITPUB个人空间i~%OZ.j!e4?c
11.111.111.11 netrac-scan netrac-scan.uk.oracle.com
)s \2}_1MO \2N2t+b022.222.222.22 netrac-scan netrac-scan.uk.oracle.com
@ ~,n7G(i-J)R$P\0
sE#HrY$N0Node Addresses:
o]6} t.GC{012.345.678.111 netrac1 netrac1.uk.oracle.com
7j(v!`0Of b+h012.345.678.222 netrac2 netrac2.uk.oracle.comITPUB个人空间L5@.P#z};wC
ITPUB个人空间qr3B z-YK
Node VIP's
M$f^Aph+N$[+PXlE m012.345.678.888 netrac1-vip netrac1-vip.uk.oracle.com
FYRIZ1~&]012.345.678.999 netrac2-vip netrac2-vip.uk.oracle.com
tF4n G:`/kd!fe0
'w.X/Y1iI.v08ej9T*O:a { \^0Database called "v11gr2"
nn4y m7c0N*m Z xp0Scan listeners called LISTENER_SCAN1 and LISTENER_SCAN2ITPUB个人空间 }U2IX9h t5]B6G
(Most configurations will have upto 3 SCAN listeners configured)ITPUB个人空间%APw+AYF|%T_%gI
DNS setup for the scan address to resolve to 11.111.11.11 or 22.222.222.22
5j$B g,Kn2D)w d0
C:\>nslookup netrac-scan.uk.oracle.comITPUB个人空间:J B%N5Rg8b2K
Server: dns001.uk.oracle.comITPUB个人空间3]0a jyK sm
Address: 10.10.1.0
H bG1qZ0
)@&[ @a%P(F1a}@0Name: netrac-scan.uk.oracle.com
7a g4sO-C O0Addresses: 11.111.111.11, 22.222.222.22Node 1.
2U$MEgP)Y1s0
w'b^ GQ!Ma0SCAN listener "LISTENER_SCAN1" is currently running on Node 1.ITPUB个人空间h8AM @&isb
Both the SCAN and Node listeners run from the grid oracle home. This the recommend setup.
2lrV*y9s7?0
[grid@netrac1 admin]$ ps -ef |grep tnslsnrITPUB个人空间:gUTYvX `
grid 9185 1 0 10:57 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
F:N m$~+n1c J0grid 9707 9061 0 11:09 pts/3 00:00:00 grep tnslsnrITPUB个人空间/n5YU-n6l bl
grid 10762 1 0 Feb08 ? 00:03:19 /u01/app/11.2.0/grid/bin/tnslsnr listener_scan1 -inheritITPUB个人空间_ enw0kl:[| n
2q2u6D"w&d%?{Z0Database parameter LOCAL_LISTENER points to Node VIP address
's%c9b4]#sM0
\[Bx7]3Qo0
SQL> show parameter local_listenerITPUB个人空间Z+G| }'T| S
ITPUB个人空间[P3Oi QK ]d q
NAME TYPE VALUEITPUB个人空间B j ?DT#F
------------------------------------ ----------- ------------------------------
p d;vdY5e0local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac1-vip)(PORT=1521))))E1v8x E E[Zy'a0Database Parameter REMOTE_LISTENER points to SCAN nameITPUB个人空间 P2pXc O7B5O
u Pv)j+Hl0
SQL> show parameter remote_listener
!y A)a b I|!o0ITPUB个人空间4h0K.\J]s L*H r
NAME TYPE VALUEITPUB个人空间5T|*x%WD2G~+|
------------------------------------ ----------- ------------------------------
O-Q&kx Z.t&{'I|G5H7F0remote_listener string netrac-scan.uk.oracle.com:1521Listener.ora Node1
~'T7Q!W j0
[grid@netrac1 admin]$ more listener.oraITPUB个人空间]W4^?v%J
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
p'\*PcR8J%]0LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by Agent
hsZ'\lB_ Q0LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by AgentITPUB个人空间,d\:rxL }%lH
ITPUB个人空间H vE F(I`
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
3d0d c-X9I G*Lp0ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
Q)YA:s"l*W-nI3i7t*R0ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by AgentThe ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ parameter is set to allow the listener to accept connections for pre-11.2 databases which did not register the dynamicendpoint.ITPUB个人空间J V W'VP+d I3f m
.h&G {n?0Listener status "listener" showing 1 instance registered, ie instance running on the node
X e7TWb0
q6i j:N0\0
[grid@netrac1 admin]$ lsnrctl status listener
*H"TK_7lZ(g0Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
@ Xua6dv H/TD&|L0STATUS of the LISTENERITPUB个人空间4X V(V1V:E&G
------------------------ITPUB个人空间4H|1t8[Q8@4Hw6a
Alias LISTENER
G%q!T/|0?qq1k0Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
j m ao @0Start Date 15-FEB-2011 10:57:09
;k)_ T#Ir,J6v0Uptime 0 days 0 hr. 0 min. 46 secITPUB个人空间){c |&Ez.K&U
Trace Level off
%x R'[0I6Gv0Security ON: Local OS AuthenticationITPUB个人空间/hB(@8b{O#m.i
SNMP OFFITPUB个人空间b;Y't`1y1CE C7T4I
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
?#O%W R D![$fRzD0Listener Log File /u01/app/grid/diag/tnslsnr/netrac1/listener/alert/log.xmlITPUB个人空间*Q CI3O7^ s
Listening Endpoints Summary...
zf Tkf"Z0(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))ITPUB个人空间\$zT&F;a
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.111)(PORT=1521))) ** Node IP Address **
7h\ A)Wq0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.888)(PORT=1521))) ** Node VIP Address **ITPUB个人空间0|@ \ql&v/XP u&d-I\:d }
Services Summary...ITPUB个人空间)zt/D x+s \(x7l
Service "v11gr2" has 1 instance(s).
{sI,g~T6|2Q0Instance "v11gr21", status READY, has 2 handler(s) for this service...ITPUB个人空间qu'p j N q^ y
The command completed successfullyITPUB个人空间 FDO$K*Xxr GTg1h
&UF6]O1Ew~/`0New file for 11.2 called endpoints_listener.ora, showing the Node IP address and Node VIP address.ITPUB个人空间+gbz0F5Bnu
ITPUB个人空间 bDI1dn2|eWxb
[grid@netrac1 admin]$ more endpoints_listener.ora
ZP1^"o}l/w-O0LISTENER_NETRAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=12.345.678.888)(PORT=1521)(IP=FIRST)))) # line added by AgentEndpoints_listener.ora file is there for backward compatibility with pre-11.2 databases.ITPUB个人空间.w4u p-a7m jj
DBCA needs to know the endpoints location to configure database parameters and tnsnames.ora file.ITPUB个人空间Z*X h6Ef({$@
It used to use the listener.ora file, 11.2 RAC listener.ora by default only has IPC entries.ITPUB个人空间1s$O ZMAj
"f/rxT"S/kD"H!q0Listener status "listener_scan1" showing both instances registered from the nodes.
\p.RHh `V0ITPUB个人空间 U`htV0Z!x
[grid@netrac1 admin]$ lsnrctl status listener_scan1ITPUB个人空间Q6xv l[ Krmg
ITPUB个人空间] DHQCCn)gv
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2011 11:04:46ITPUB个人空间 x3` c9b U H
j0n"c`B+sn I$V+r0Copyright (c) 1991, 2009, Oracle. All rights reserved.ITPUB个人空间}7j8k+M ft/k
ITPUB个人空间%cp*V p2q V-` S$O
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
%Y Vq+{ g'g0STATUS of the LISTENERITPUB个人空间t%Gw'O$RT f
------------------------
J \9`W Jg&r-x!d0Alias listener_scan1ITPUB个人空间,e ^})Fl!M
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
(d5CTw \e0Start Date 08-FEB-2011 15:46:52ITPUB个人空间;T-T X3G5q:r h
Uptime 6 days 19 hr. 17 min. 53 secITPUB个人空间IE+T o%^P
Trace Level support
@VW k rOE_`0Security ON: Local OS AuthenticationITPUB个人空间,g6F'S }PC9D
SNMP OFFITPUB个人空间$\u [3B!SDy A
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.oraITPUB个人空间ke sX0DST s1w
Listener Log File /u01/app/11.2.0/grid/network/log/listener_scan1.log
oo6@'@? i0Listener Trace File /u01/app/11.2.0/grid/network/trace/listener_scan1.trcITPUB个人空间4X1x,zq:F Sg
Listening Endpoints Summary...ITPUB个人空间w)l;c,{*|D&w
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
O#Oiq"{r o{ z/c0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.111.111.11)(PORT=1521))) ** Scan VIP **ITPUB个人空间h @7E0`z:K rP
Services Summary...
g \ _+xC"S"? G5Q0Service "v11gr2" has 2 instance(s).ITPUB个人空间0O)nn#u+wt m.yKQ#H
Instance "v11gr21", status READY, has 3 handler(s) for this service...ITPUB个人空间4a,V uD$l8g3S
Instance "v11gr22", status READY, has 2 handler(s) for this service...ITPUB个人空间(iv ] W&R
The command completed successfully
x y o T-@}0Node 2.
C*d&^s?(H0_G0SCAN listener "LISTENER_SCAN2" is currently running on Node 2, along with node listener "listener"ITPUB个人空间;jx S;pG@k4Q9{
ITPUB个人空间%Hb8k/M*t%RK
[grid@netrac2 ~]$ ps -ef |grep tnslsnrITPUB个人空间8c8L&A,}0es Y
grid 4466 1 0 Feb07 ? 00:00:11 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritITPUB个人空间3U _Edln T _
grid 4481 1 0 Feb07 ? 00:00:13 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
e ])u"I K t6cG8c0grid 32059 31690 0 11:08 pts/1 00:00:00 grep tnslsnr
^w7o4h wR0Database parameter LOCAL_LISTENER points to Nodes VIP address
,Qg g0vEEuH0ITPUB个人空间7EeN1U[Zwf
SQL> show parameter local_listener
m7H#P-f'j&@+],N0
(l"J+A&R7kLe`1W0NAME TYPE VALUEITPUB个人空间 |zh8X*bG7| X
------------------------------------ ----------- ------------------------------
3O @"T/h`,w0local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521))))(FO d$_/c}0Database Parameter REMOTE_LISTENER points to SCAN name.ITPUB个人空间L.m1AV I u
ITPUB个人空间*oiC*z\O;R
SQL> show parameter remote_listener
e1i-l0\ k'q2k0ITPUB个人空间q|H/A5Y"|1],o
NAME TYPE VALUEITPUB个人空间 Ckv)Y9n"C\#V
------------------------------------ ----------- ------------------------------ITPUB个人空间2N;w/~~7T s(H6}
remote_listener string netrac-scan.uk.oracle.com:1521Listener.ora Node2
[grid@netrac2 admin]$ more listener.ora
[U`_(SE0LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by AgentITPUB个人空间-n#iM[%k/Z
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by AgentITPUB个人空间5I y-F nc~G*{b
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by AgentITPUB个人空间*pN{7h^!i0M L!ki
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
lQ ~2WI0ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
7]]8z/H;o J1M V0ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
U4SqD \0^ [-B0m c(u'rU,{(a)b0"Line added by Agent" is the Oraagent is the process updating the listener.ora and endpoints_listener.ora files.ITPUB个人空间6s1H:r#BW0^7W `
ITPUB个人空间Iy k \z$X&i`F,r
Endpoints_listener.ora showing the Node IP address and Node VIP addressITPUB个人空间o&EP%F9[ [l m
8\ ZbOGP1C]L0
[grid@netrac2 admin]$ more endpoints_listener.oraITPUB个人空间 n+D(m_;X2d(t
LISTENER_NETRAC2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=12.345.678.999) (PORT=1521)(IP=FIRST)))) # line added by Agent
*z%eN r2q9b d"v4l0Listener status "listener" showing 1 instance registered
1P%uG5?-m0
g*g X9c\%]0R.f ^0
[grid@netrac2 admin]$ lsnrctl status listenerITPUB个人空间2X2X4B^2u.y{/t5q V
ITPUB个人空间2v3~*O \9kg
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2011 11:24:28
g{I+Td0
.|M+W/_J0n M0Copyright (c) 1991, 2009, Oracle. All rights reserved.
h%M]#jd4{G,V0ITPUB个人空间9`de Q;W9C/} c^K n
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))ITPUB个人空间wa-qn Du {3b&U
STATUS of the LISTENER
ODD%D$l#tl'z\0------------------------ITPUB个人空间+f| M/ufp ze|
Alias LISTENER
-w_ hLk3s!Q(h0Version TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionITPUB个人空间+^;Z'D[1x0Cx0N
Start Date 07-FEB-2011 10:48:06ITPUB个人空间{*y9P.[} S5|.v8^.{
Uptime 8 days 0 hr. 36 min. 22 secITPUB个人空间az,a^%eoy
Trace Level off
^8rw Q*~ O9Q0Security ON: Local OS AuthenticationITPUB个人空间yKP[Yoo0B!c
SNMP OFFITPUB个人空间c ct0RVK s
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.oraITPUB个人空间v'} kMyva/h
Listener Log File /u01/app/grid/diag/tnslsnr/netrac2/listener/alert/log.xmlITPUB个人空间Aa }3O#q
Listening Endpoints Summary...ITPUB个人空间@3L]F"` s `%j1`
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
6Zy*s~3^&}}@0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.222)(PORT=1521))) **Node IP Address**
~Ds.A^0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.999)(PORT=1521))) **Node VIP Address**
yp"^W$R L/C0Services Summary...ITPUB个人空间7CvMv sF ~&a
Service "v11gr2" has 1 instance(s).ITPUB个人空间:x s:C | c ?3U
Instance "v11gr22", status READY, has 2 handler(s) for this service...
Q ef k|Y(FZ:}0The command completed successfullyITPUB个人空间`a/\(h)p j0m)g l9qD
Listener status "listener_scan2" showing both instances registered
@ XFR%gN!{#c0
[grid@netrac2 admin]$ lsnrctl status listener_scan2
Od9q ]5T]x {0ITPUB个人空间ha JoC s
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2011 11:32:14ITPUB个人空间S oj{H2b:v
ITPUB个人空间n"c9iE^!m
Copyright (c) 1991, 2009, Oracle. All rights reserved.ITPUB个人空间xPF"LL
ITPUB个人空间KZ+~I{;YnU#H
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
7X [[B3[g+{0STATUS of the LISTENERITPUB个人空间5M$l&E P H,y
------------------------ITPUB个人空间N$Yk E"Z*I+W9i7cd;lH
Alias LISTENER_SCAN2
-X8Q/EL)c/az%P0Version TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionITPUB个人空间)Jw4os$n JE
Start Date 07-FEB-2011 10:48:06ITPUB个人空间 fh-fm/iCY
Uptime 8 days 0 hr. 44 min. 7 secITPUB个人空间l}CX&d:}L
Trace Level off
"ZI1u1|#QON0Security ON: Local OS AuthenticationITPUB个人空间1hQ_G/xQ5RJx
SNMP OFF
9X*|xHI0Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.oraITPUB个人空间!rB3`X6D#v
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/netrac2/listener_scan2/alert/log.xml
!X6Jc,\s5H)O9U0Listening Endpoints Summary...
X S8m:ft9V-w9f0(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
q [CP h T0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=22.222.222.22)(PORT=1521)))** Scan VIP **
lr cN?4r Dp0Services Summary...
#D7mUh J0Service "v11gr2" has 2 instance(s).ITPUB个人空间5{&G~)}5m
Instance "v11gr21", status READY, has 3 handler(s) for this service...ITPUB个人空间v;R:C\{@
Instance "v11gr22", status READY, has 2 handler(s) for this service...
/w A_o F/@0The command completed successfullyFurther information on the listeners can be found via svrctlITPUB个人空间V&d){ z$B-C9vuq
ITPUB个人空间 bn]!l/L.|
[grid@netrac1 admin]$ srvctl config scan_listener
rS0z c%nC+c7lM0SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
G;x8IB"Z3ihwk1Pj |0SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
F1A c N(c \A$w0ITPUB个人空间HI+ct8L I
[grid@netrac1 admin]$ srvctl config scan
m`7D E7c8H0SCAN name: netrac-scan.uk.oracle.com, Network: 1/10.167.20.50
c8h k/xd|.E0.240.0/255.255.240.0/eth1
.T Uv7sS%O8qu8IV;Z0SCAN VIP name: scan1, IP: /netrac-scan.uk.oracle.com/11.111.111.11
7A2W;J:u7Y:@~0SCAN VIP name: scan2, IP: /netrac-scan.uk.oracle.com/22.222.222.22ITPUB个人空间9B q7D.G _}P SsConfiguration changes to the Listener are made via svrctlITPUB个人空间o7^-Fg8GMH1G
ITPUB个人空间m!vr Q+Xh{
Note 952903.1 How to update the IP address of the SCAN VIP resources (ora.scan<n>.vip)
1vg W"my ^0Note 975457.1 How to Troubleshoot Connectivity Issue with11gR2 SCAN NameITPUB个人空间+Q7v;^-j+K&W*Q,J
Note 972500.1 How to Modify SCAN Setting after Installation
U](Zzm(Q ~H0
SQLNET.ORA
Ensure the GI Oracle home has in the SQLNET.ORA file ezconnect in the directory Path
'rT [%v$c(L!Z!c0
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
1e"u)nL/x ?-S;B h4m0Client connection example
C:\Documents and Settings\sflood>sqlplus scott/tiger@netscanITPUB个人空间4Cd)W8k*V
ITPUB个人空间(Ju c#h g d5[.^
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 15 11:43:02 2011
Wg]+U)Y6{u0
"D"l0vER kl uHP0Copyright (c) 1982, 2010, Oracle. All rights reserved.
n U*OA'\~!r4Zk%oQ!h8@0
*j \Z;Y%E#j(e0
/Z r2t t't K$h!]JQ m&f0Connected to:
Z#y0R7t%U7fF0Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionITPUB个人空间L _wE^Vf4H
With the Partitioning, Real Application Clusters, Automatic Storage Management,
} Q-Th ^3O4Y:?w'B0Data Mining and Real Application Testing options
w g6ZN6V J7e'}r0ITPUB个人空间-]_/[,vW ||
SQL> select instance_name from v$instance;
|jw9{v$I$w1DO0ITPUB个人空间G*J0XA8d J)~M
INSTANCE_NAME
.l bB `z2U0----------------
~"^gh M"R{M0v11gr22Calling address used
~Cg0c W ] x)M(O0
"E/I:M-I8]2K+V0f0
15-FEB-2011 11:43:02:703] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac-scan.uk.oracle.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=v11gr2)(CID=(PROGRAM=c:\Oracle\RDBMS112\bin\sqlplus.exe)(HOST=sflood-uk)(USER=sflood))))
r H0@:S A x!R(q Lt0
ITPUB个人空间%}&}ow^4r Y_?r H0@:S A x!R(q Lt0
Resolve the Scan address and build connection information on address information supplied by DNSITPUB个人空间1t3c}#c8Yj(ub)d'Z
4hj2LYPHD0
[15-FEB-2011 11:43:02:703] nlad_expand_hst: Expanding netrac-scan.uk.oracle.com
Eq/} p7lD/TuU0[15-FEB-2011 11:43:02:703] snlinGetAddrInfo: entryITPUB个人空间 dH)oE`y
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exitITPUB个人空间p;I+~N'L z%A s s f
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entryITPUB个人空间 @FAw4K)S
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
.S3H8gRF1a.F%s0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 11.111.111.11ITPUB个人空间uT9YwD.zV,I
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entry
i8z3cF#G s0[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
6Em{A8t4j8Y)Gl0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 22.222.222.22
w$K8C)Z r [/u0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: entry
_3rF%NMO Y4U1QD0H0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: exit
/j!@c9CSc f0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11.111.111.11)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=22.222.222.22)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=v11gr2)(CID=(PROGRAM=c:\Oracle\RDBMS112\bin\sqlplus.exe)(HOST=sflood-uk)(USER=sflood))))ITPUB个人空间q$l)Cx|A"n5O
ITPUB个人空间6_Ds2s3E/S(l}QEq/} p7lD/TuU0[15-FEB-2011 11:43:02:703] snlinGetAddrInfo: entryITPUB个人空间 dH)oE`y
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exitITPUB个人空间p;I+~N'L z%A s s f
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entryITPUB个人空间 @FAw4K)S
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
.S3H8gRF1a.F%s0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 11.111.111.11ITPUB个人空间uT9YwD.zV,I
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entry
i8z3cF#G s0[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
6Em{A8t4j8Y)Gl0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 22.222.222.22
w$K8C)Z r [/u0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: entry
_3rF%NMO Y4U1QD0H0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: exit
/j!@c9CSc f0[15-FEB-2011 11:43:02:734] nlad_expand_hst: Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11.111.111.11)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=22.222.222.22)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=v11gr2)(CID=(PROGRAM=c:\Oracle\RDBMS112\bin\sqlplus.exe)(HOST=sflood-uk)(USER=sflood))))ITPUB个人空间q$l)Cx|A"n5O
Selected Node 1
g9@J(_rK$hW u;~y0
)MKB['kf0
[15-FEB-2011 11:43:02:734] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=11.111.111.11)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=v11gr2)(CID=(PROGRAM=c:\Oracle\RDBMS112\bin\sqlplus.exe)(HOST=sflood-uk)(USER=sflood))))ITPUB个人空间s@.d$ni(k j
[15-FEB-2011 11:43:02:734] nttbnd2addr: entry
$G(h|+y yoM-xt0[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: entryITPUB个人空间1f[x:m/~ ^7~
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exit
8y ie%U6sUF7@*J0[15-FEB-2011 11:43:02:734] nttbnd2addr: using host IP address: 11.111.111.11
ITPUB个人空间]m1d0f5n ~[15-FEB-2011 11:43:02:734] nttbnd2addr: entry
$G(h|+y yoM-xt0[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: entryITPUB个人空间1f[x:m/~ ^7~
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exit
8y ie%U6sUF7@*J0[15-FEB-2011 11:43:02:734] nttbnd2addr: using host IP address: 11.111.111.11
Start of the connection handshake
n8\-d%@&f7mqo5]0
r#J6`s|J0
[15-FEB-2011 11:43:02:734] nscon: doing connect handshake...ITPUB个人空间*g5R&N1\ CN-`5p
[15-FEB-2011 11:43:02:734] nscon: sending NSPTCN packet
ITPUB个人空间!i dh T c g8_/z%j+G G3x[15-FEB-2011 11:43:02:734] nscon: sending NSPTCN packet
Redirect packet from Scan TNS listener ITPUB个人空间'[ lY YS
5XN{#UZM3Bjz0
[15-FEB-2011 11:43:02:859] nscon: got NSPTRD packetITPUB个人空间M Jb S+Gsa? h d
ITPUB个人空间#ZCSZj2U?$h7K+XConnection told to redirect to Node 2 Node listener
Bo&hS d0ITPUB个人空间!n m+goT`P
[15-FEB-2011 11:43:02:859] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521)))
ITPUB个人空间o%Jy5JEA;P CConnection handshake completed (Connect, Resend, Connect, Accept)
I;Z kqu"NW;zY0ITPUB个人空间5yKiz;f;a
[15-FEB-2011 11:43:02:890] nscon: doing connect handshake...ITPUB个人空间H#XK1uK/Vg mX fz
[15-FEB-2011 11:43:02:890] nscon: sending NSPTCN packetITPUB个人空间 gQ$S/YN q
%I`}U%a? Le b*N0[15-FEB-2011 11:43:02:921] nscon: got NSPTRS packet
c1l.w o;k`0ITPUB个人空间+S/aVb#^"Y!j h
[15-FEB-2011 11:43:02:921] nscon: sending NSPTCN packet
`1^ i y$O.O8It O0ITPUB个人空间R1Ak+U3]I|-jI O |
[15-FEB-2011 11:43:02:921] nscon: got NSPTAC packet
;q"Iana+eHUWRV8o0
ITPUB个人空间 B1H.B#q3m F^,D&P[15-FEB-2011 11:43:02:890] nscon: sending NSPTCN packetITPUB个人空间 gQ$S/YN q
%I`}U%a? Le b*N0[15-FEB-2011 11:43:02:921] nscon: got NSPTRS packet
c1l.w o;k`0ITPUB个人空间+S/aVb#^"Y!j h
[15-FEB-2011 11:43:02:921] nscon: sending NSPTCN packet
`1^ i y$O.O8It O0ITPUB个人空间R1Ak+U3]I|-jI O |
[15-FEB-2011 11:43:02:921] nscon: got NSPTAC packet
;q"Iana+eHUWRV8o0
After authentication and banner packets pass, we see the select run "nsbasic_bsd" = send
P\ZO3YY0ITPUB个人空间3^J+c-uC
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 00 00 00 00 00 00 00 00 |........|
4]*Q;M |UsL0[15-FEB-2011 11:43:11:953] nsbasic_bsd: 24 73 65 6C 65 63 74 20 |$select.|
2K1SV j,ri0[15-FEB-2011 11:43:11:953] nsbasic_bsd: 69 6E 73 74 61 6E 63 65 |instance|ITPUB个人空间[4S!S3{M;yK#?
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 5F 6E 61 6D 65 20 66 72 |_name.fr|ITPUB个人空间-K\7vM0I/m&E;L
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 6F 6D 20 76 24 69 6E 73 |om.v$ins|ITPUB个人空间7O%m2f:_v1u B
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 74 61 6E 63 65 01 00 00 |tance...|
4]*Q;M |UsL0[15-FEB-2011 11:43:11:953] nsbasic_bsd: 24 73 65 6C 65 63 74 20 |$select.|
2K1SV j,ri0[15-FEB-2011 11:43:11:953] nsbasic_bsd: 69 6E 73 74 61 6E 63 65 |instance|ITPUB个人空间[4S!S3{M;yK#?
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 5F 6E 61 6D 65 20 66 72 |_name.fr|ITPUB个人空间-K\7vM0I/m&E;L
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 6F 6D 20 76 24 69 6E 73 |om.v$ins|ITPUB个人空间7O%m2f:_v1u B
[15-FEB-2011 11:43:11:953] nsbasic_bsd: 74 61 6E 63 65 01 00 00 |tance...|
ce K9mSv0And the information received "nsbasic_brc" = receive
]l%i2`9U? W,\`0
`%@@~%IN0
[15-FEB-2011 11:43:11:953] nsbasic_brc: 00 00 0D 49 4E 53 54 41 |...INSTA|
4i7D U$k]Q3ka0[15-FEB-2011 11:43:11:953] nsbasic_brc: 4E 43 45 5F 4E 41 4D 45 |NCE_NAME|
'j~3\^#_$[%a j#?o0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
+cp5\w#e0~s'XG0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 07 00 |........|ITPUB个人空间v*_\JwCd5K9Y [
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 07 78 6F 02 0F 0C |...xo...|ITPUB个人空间Z4S$Y k?t
[15-FEB-2011 11:43:11:968] nsbasic_brc: 2F 28 00 00 00 00 E8 1F |/(......|ITPUB个人空间d+J5[gbs
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 33 00 00 00 33 00 |..3...3.|ITPUB个人空间 d%zN xP$NZ
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 06 22 |......."|ITPUB个人空间4Q.H@ } d
[15-FEB-2011 11:43:11:968] nsbasic_brc: 01 00 00 00 00 00 01 00 |........|ITPUB个人空间q6h3\!u*S
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
:G6Ad`|:[3kUH~0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 07 07 76 31 |......v1|ITPUB个人空间%qa)U7p'D#qr+SS
[15-FEB-2011 11:43:11:968] nsbasic_brc: 31 67 72 32 32 08 06 00 |1gr22...|
9l"] u@ jS0[15-FEB-2011 11:43:11:968] nsbasic_brc: BE 7C FC 02 00 00 00 00 |.|......|ITPUB个人空间'w X A$G&xq C
4i7D U$k]Q3ka0[15-FEB-2011 11:43:11:953] nsbasic_brc: 4E 43 45 5F 4E 41 4D 45 |NCE_NAME|
'j~3\^#_$[%a j#?o0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
+cp5\w#e0~s'XG0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 07 00 |........|ITPUB个人空间v*_\JwCd5K9Y [
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 07 78 6F 02 0F 0C |...xo...|ITPUB个人空间Z4S$Y k?t
[15-FEB-2011 11:43:11:968] nsbasic_brc: 2F 28 00 00 00 00 E8 1F |/(......|ITPUB个人空间d+J5[gbs
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 33 00 00 00 33 00 |..3...3.|ITPUB个人空间 d%zN xP$NZ
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 06 22 |......."|ITPUB个人空间4Q.H@ } d
[15-FEB-2011 11:43:11:968] nsbasic_brc: 01 00 00 00 00 00 01 00 |........|ITPUB个人空间q6h3\!u*S
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
:G6Ad`|:[3kUH~0[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 07 07 76 31 |......v1|ITPUB个人空间%qa)U7p'D#qr+SS
[15-FEB-2011 11:43:11:968] nsbasic_brc: 31 67 72 32 32 08 06 00 |1gr22...|
9l"] u@ jS0[15-FEB-2011 11:43:11:968] nsbasic_brc: BE 7C FC 02 00 00 00 00 |.|......|ITPUB个人空间'w X A$G&xq C
TNSNAMES.ORA ITPUB个人空间2S6f5c(J9o2G
entry only now needs to have the Scan name
NETSCAN =ITPUB个人空间 V+{!O6Ddgg
(DESCRIPTION =
4E f(J X9k0 (ADDRESS_LIST =
J$p x S&uY%e,B0 (ADDRESS = (PROTOCOL = TCP)(HOST = netrac-scan.uk.oracle.com)(PORT = 1521))
e$W9d5R-k0 )ITPUB个人空间y#Bg}ux"XsrhX
(CONNECT_DATA =ITPUB个人空间l I q9a!L
(SERVICE_NAME = v11gr2)ITPUB个人空间(Htc@/d
)
\ a;^E6z W%n_+W0)Pre 11.2 clients will need to the use the SCAN VIP addresses,as they do not contain the code to understand the two addresses returned by DNS, a thus connections would not load balance correctly.
vi8l*s f9L'q#__0
SDU and Scan
As SCAN listener information is altered via srvctl via grid oracle home, then SDU can be change for all Oracle Net connections with the profile parameter DEFAULT_SDU_SIZE in the SQLNET.ORA file.ITPUB个人空间!^yX[M^ \o!} Z
References
NOTE:948456.1 - Pre 11.2 Database Issues in 11gR2 Grid Infrastructure EnvironmentITPUB个人空间'yQH"ntMR {ITPUB个人空间 ^??+XdN'Q7]
ITPUB个人空间0N6[&N y$c"M1U0~F
首先从11gR2开始，SCAN监听器和本地监听器都是通过Grid来管理的，相关的配置文件都是存放在$GRID_HOME/network/admin/目录中，相关的进程运行在grid操作系统用户下。ITPUB个人空间H;v_ e%b
3Q3PT.C^)e {R4F q}0 其次$GRID_HOME/network/admin/endpoints_listener.ora是个向后兼容的文件，其中包含了节点的公共IP地址和VIP地址，Grid必须要能够找到这个文件。$GRID_HOME/network/admin/listener.ora文件中的ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ 参数表示当CRS在监听上创建动态endpoints，这个参数添加向后兼容性，允许客户端连接到11gR2之前的实例，甚至是没有动态注册到endpoint的实例。ITPUB个人空间c!HT*qIq
ITPUB个人空间 LWMk6J(S?5m
有关监听器的endpoint概念可以参考文章：http://space.itpub.net/23135684/viewspace-715967
z r*^%O*Dr5D0ITPUB个人空间5` Zc({ O ~E7A ~8v)H
1M!f2?.~P%| ]H"\-g[0
+e V xc5m3C2S0ITPUB个人空间 f.w m J-Pn/I
ITPUB个人空间%Th+d%Y%N
相关阅读:
- 转)索引扫描还是全表扫描（Index Scan Or Full Table Scan）(beatony, 2011-11-29)
- （转载）使用VirtualBox在Linux上安装Oracle 11gR2 RAC(db_wjw, 2011-12-02)
- Redhat6 下 Oracle 11gr2 的 安装(renfengjun, 2011-12-03)
- FLASHBACK_TRANSACTION_QUERY 11G R2. UNDO_SQL为NULL的问题(lfree, 2011-12-12)
- 监听器控制程序lsnrctl跟踪trace file(realkid4, 2011-12-19)
- 解析listener跟踪文件(realkid4, 2011-12-20)
- 笔记本搭建11gR2 RAC环境(尛样儿, 2011-12-28)
- 【延迟段创建】Oracle 11gR2的延迟段创建（deferred segment creation）特性(secooler, 2012-2-03)
- oracle11gR2的数据库示例用户安装说明(pingley, 2012-2-06)
- 11gR2 OCRDUMP查看OCR/OLR文件的内容(尛样儿, 2012-2-09)
- 11gR2中的SCAN监听器和本地监听器配置
- oracle监听器和本地服务配置(有图哟)
- oracle监听器和服务配置
- 客户端监听器创建和配置
- Servlets中的监听器和过滤器
- JavaWeb中的监听器和过滤器
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- Oracle 11gR2 RAC 修改监听器端口号的步骤
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 修改Oracle 11gR2 RAC SCAN监听和本地监听端口
- 修改Oracle 11gR2 RAC SCAN监听和本地监听端口
- 修改Oracle 11gR2 RAC SCAN监听和本地监听端口
- 监听器
- 监听器
- 监听器
- 2013-08-21C语言编程实践课第三天
- 【SSH学习笔记】整合spring3-hibernate的小项目（一）
- Android发送GET和POST请求DEMO
- C/C++中extern关键字详解
- 使用Mac OS X系统必须了解的10条命令
- 11gR2中的SCAN监听器和本地监听器配置
- KMP算法
- hdu 1141 数学
- nhibernate连接池配置
- vim使用进阶
- IOS开发证书申请流程和给他人电脑授权
- Late Counting (POJ 2386) 深度优先搜索
- Python 安装与使用
- freeswitch中文名登陆的疑问
