11gR2中的SCAN监听器和本地监听器配置-MySQL-Tutorial-php.cn

11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1] 修改时间 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 S

11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1]

		修改时间 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]Zjq
Information 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个人空间I6n8F6aK.|

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 tF4nG:`/kd!fe0 'w.X/Y1iI.v0

8ej9T*O:a{\^0Database called "v11gr2"
nn4y m7c0N*mZxp0Scan listeners called LISTENER_SCAN1 and LISTENER_SCAN2ITPUB个人空间}U2IX9ht5]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$Bg,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.22

ITPUB个人空间 ^ 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

[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$~+n1cJ0grid 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 ]dq NAME TYPE VALUEITPUB个人空间B j ?DT#F ------------------------------------ ----------- ------------------------------ pd;vdY5e0local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac1-vip)(PORT=1521))))

E1v8xE E[Zy'a0Database Parameter REMOTE_LISTENER points to SCAN nameITPUB个人空间 P2pXc O7B5O

uPv)j+Hl0

SQL> show parameter remote_listener !yA)a bI|!o0ITPUB个人空间4h0K.\J]sL*H r NAME TYPE VALUEITPUB个人空间5T|*x%WD2G~+| ------------------------------------ ----------- ------------------------------ O-Q&kx Z.t&{'I|G5H7F0remote_listener string netrac-scan.uk.oracle.com:1521

Listener.ora Node1
~'T7Q!Wj0

[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个人空间HvE F(I` ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent 3d0dc-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 Agent

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 dynamic endpoint.ITPUB个人空间J V W'VP+dI3f 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个人空间4XV(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 mao@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 %xR'[0I6Gv0Security ON: Local OS AuthenticationITPUB个人空间/hB(@8b{O#m.i SNMP OFFITPUB个人空间b;Y't`1y1CEC7T4I 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... zfTkf"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 jNq^ 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 Agent

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$OZMAj

"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+snI$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))) %YVq+{g'g0STATUS of the LISTENERITPUB个人空间t%Gw'O$RT f ------------------------ J \9`WJg&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-TX3G5q: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个人空间kesX0DST 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:FSg 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:KrP Services Summary... g \ _+xC"S"? G5Q0Service "v11gr2" has 2 instance(s).ITPUB个人空间0O)nn#u+wtm.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 xyoT-@}0

ITPUB个人空间4t#VDz&Zv1K$i
Node 2.
C*d&^s?(H0_G0SCAN listener "LISTENER_SCAN2" is currently running on Node 2, along with node listener "listener"ITPUB个人空间;jxS;pG@k4Q9{
ITPUB个人空间%Hb8k/M*t%RK

[grid@netrac2 ~]$ ps -ef |grep tnslsnrITPUB个人空间8c8L&A,}0esY 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"IK t6cG8c0grid 32059 31690 0 11:08 pts/1 00:00:00 grep tnslsnr ^w7o4h wR0

ITPUB个人空间pZzsfN
Database parameter LOCAL_LISTENER points to Nodes VIP address
,Qgg0vEEuH0ITPUB个人空间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.m1AVIu
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:1521

Listener.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个人空间5Iy-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 J1MV0ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent U4SqD \0

^[-B0mc(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个人空间Iyk\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%eNr2q9b d"v4l0

ITPUB个人空间s J J/u~"nm s
Listener status "listener" showing 1 instance registered
1P%uG5?-m0
g*gX9c\%]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/_J0nM0Copyright (c) 1991, 2009, Oracle. All rights reserved. h%M]#jd4{G,V0ITPUB个人空间9`de Q;W9C/} c^Kn 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个人空间cct0RVK 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 efk|Y(FZ:}0The command completed successfullyITPUB个人空间`a/\(h)p j0m)g l9qD

ITPUB个人空间 t%drP!BKQH
Listener status "listener_scan2" showing both instances registered
@XFR%gN!{#c0

[grid@netrac2 admin]$ lsnrctl status listener_scan2 Od9q]5T]x{0ITPUB个人空间haJoC 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 PH,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$nJE 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... XS8m:ft9V-w9f0(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2))) q [CP hT0(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=22.222.222.22)(PORT=1521)))** Scan VIP ** lrcN?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_oF/@0The command completed successfully

ITPUB个人空间d.w&}7{*Vn"h
Further 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 cN(c \A$w0ITPUB个人空间HI+ct8LI [grid@netrac1 admin]$ srvctl config scan m`7DE7c8H0SCAN name: netrac-scan.uk.oracle.com, Network: 1/10.167.20.50 c8hk/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_}PSs

Configuration 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.vip)
1vg W"my^0Note 975457.1 How to Troubleshoot Connectivity Issue with 11gR2 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;Bh4m0

Client 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'tK$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 .lbB `z2U0---------------- ~"^ghM"R{M0v11gr22

ITPUB个人空间Wp'u!f~Z
Calling address used
~Cg0cW ] 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@:SAx!R(q Lt0

ITPUB个人空间%}&}ow^4rY_?
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 ssf
[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)Zr[/u0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: entry
_3rF%NMOY4U1QD0H0[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: exit
/j!@c9CScf0[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}Q
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|+yyoM-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~
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个人空间!idh T c g8_/z%j+GG3x
Redirect packet from Scan TNS listener ITPUB个人空间'[lY YS

5XN{#UZM3Bjz0

[15-FEB-2011 11:43:02:859] nscon: got NSPTRD packetITPUB个人空间M JbS+Gsa?hd

ITPUB个人空间#ZCSZj2U?$h7K+X
Connection told to redirect to Node 2 Node listener
Bo&hSd0ITPUB个人空间!nm+goT`P

[15-FEB-2011 11:43:02:859] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521)))

ITPUB个人空间o%Jy5JEA;PC
Connection 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.wo;k`0ITPUB个人空间+S/aVb#^"Y!jh
[15-FEB-2011 11:43:02:921] nscon: sending NSPTCN packet
`1^iy$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
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...|

ceK9mSv0And 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|
4i7DU$k]Q3ka0[15-FEB-2011 11:43:11:953] nsbasic_brc: 4E 43 45 5F 4E 41 4D 45 |NCE_NAME|
'j~3\^#_$[%aj#?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个人空间'wX A$G&xqC

TNSNAMES.ORA ITPUB个人空间2S6f5c(J9o2G

entry only now needs to have the Scan name

NETSCAN =ITPUB个人空间 V+{!O6Ddgg (DESCRIPTION = 4E f(JX9k0 (ADDRESS_LIST = J$px 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个人空间lI q9a!L (SERVICE_NAME = v11gr2)ITPUB个人空间(Htc@/d ) \ a;^E6zW%n_+W0)

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*sf9L'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[&Ny$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