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 Hostname ITPUB个人空间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+b0 22.222.222.22 netrac-scan netrac-scan.uk.oracle.com
@ ~,n7G(i-J)R$P\0
sE#HrY$N0 Node Addresses:
o]6} t.GC{0 12.345.678.111 netrac1 netrac1.uk.oracle.com
7j(v!`0Of b+h0 12.345.678.222 netrac2 netrac2.uk.oracle.com ITPUB个人空间L5@.P#z};wC
ITPUB个人空间qr3B z-YK
Node VIP's
M$f^Aph+N$[+PXlE m0 12.345.678.888 netrac1-vip netrac1-vip.uk.oracle.com
FYRIZ1~&]0 12.345.678.999 netrac2-vip netrac2-vip.uk.oracle.com
tF4nG:`/kd!fe0
'w.X/Y1iI.v0
8ej9T*O:a{\^0 Database called "v11gr2"
nn4y m7c0N*mZxp0 Scan listeners called LISTENER_SCAN1 and LISTENER_SCAN2 ITPUB个人空间}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.com ITPUB个人空间:J B%N5Rg8b2K
Server : dns001.uk.oracle.com ITPUB个人空间3]0a jyK sm
Address: 10.10.1.0
H bG1qZ0
)@&[ @a%P(F1a}@0 Name: netrac-scan.uk.oracle.com
7a g4sO-C O0 Addresses: 11.111.111.11, 22.222.222.22
Node 1.
2U$MEgP)Y1s0
w'b^GQ!Ma0 SCAN 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 tnslsnr ITPUB个人空间:gUTYvX `
grid 9185 1 0 10:57 ? 0 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
F:N m$~+n1cJ0 grid 9707 9061 0 11:09 pts/3 0 grep tnslsnr ITPUB个人空间/n5YU-n6l bl
grid 10762 1 0 Feb08 ? 00:03:19 /u01/app/11.2.0/grid/bin/tnslsnr listener_scan1 -inherit ITPUB个人空间_ enw0kl:[| n
2q2u6D"w&d%?{Z0 Database parameter LOCAL_LISTENER points to Node VIP address
's%c9b4]#sM0
\[Bx7]3Qo0
SQL> show parameter local_listener ITPUB个人空间Z+G| }'T|S
ITPUB个人空间[P3Oi QK ]dq
NAME TYPE VALUE ITPUB个人空间B j ?DT#F
------------------------------------ ----------- ------------------------------
pd;vdY5e0 local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac1-vip)(PORT=1521))))
E1v8xE E[Zy'a0 Database Parameter REMOTE_LISTENER points to SCAN name ITPUB个人空间 P2pXc O7B5O
uPv)j+Hl0
SQL> show parameter remote_listener
!yA)a bI|!o0 ITPUB个人空间4h0K.\J]sL*H r
NAME TYPE VALUE ITPUB个人空间5T|*x%WD2G~+|
------------------------------------ ----------- ------------------------------
O-Q&kx Z.t&{'I|G5H7F0 remote_listener string netrac-scan.uk.oracle.com:1521
~'T7Q!Wj0
[grid@netrac1 admin]$ more listener.ora ITPUB个人空间]W4^?v%J
LISTENER_SCAN2 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
p'\*PcR8J%]0 LISTENER =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by Agent
hsZ'\lB_ Q0 LISTENER_SCAN1 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ITPUB个人空间,d\:rxL}%lH
ITPUB个人空间HvE F(I`
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
3d0dc-X9I G*Lp0 ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
Q)YA:s"l*W-nI3i7t*R0 ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
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?0 Listener 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(g0 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
@ Xua6dv H/TD&|L0 STATUS of the LISTENER ITPUB个人空间4XV(V1V:E&G
------------------------ ITPUB个人空间4H|1t8[Q8@4Hw6a
Alias LISTENER
G%q!T/|0?qq1k0 Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
j mao@0 Start Date 15-FEB-2011 10:57:09
;k)_T#Ir,J6v0 Uptime 0 days 0 hr. 0 min. 46 sec ITPUB个人空间){c|&Ez.K&U
Trace Level off
%xR'[0I6Gv0 Security ON: Local OS Authentication ITPUB个人空间/hB(@8b{O#m.i
SNMP OFF ITPUB个人空间b;Y't`1y1CEC7T4I
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
?#O%W R D![$fRzD0 Listener Log File /u01/app/grid/diag/tnslsnr/netrac1/listener/alert/log.xml ITPUB个人空间*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|2Q0 Instance " v11gr21 ", status READY, has 2 handler(s) for this service... ITPUB个人空间qu'p jNq^ y
The command completed successfully ITPUB个人空间FDO$K*Xxr GTg1h
&UF6]O1Ew~/`0 New 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-O0 LISTENER_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
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!q0 Listener status "listener_scan1" showing both instances registered from the nodes.
\p.RHh`V0 ITPUB个人空间 U`htV0Z!x
[grid@ netrac1 admin]$ lsnrctl status listener_scan1 ITPUB个人空间Q6xv l[ Krmg
ITPUB个人空间]DHQCCn)gv
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2011 11:04:46 ITPUB个人空间 x3` c9b U H
j0n"c`B+snI$V+r0 Copyright (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'g0 STATUS of the LISTENER ITPUB个人空间t%Gw'O$RT f
------------------------
J \9`WJg&r-x!d0 Alias listener_scan1 ITPUB个人空间,e^})Fl!M
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
(d5CTw \e0 Start Date 08-FEB-2011 15:46:52 ITPUB个人空间;T-TX3G5q:r h
Uptime 6 days 19 hr. 17 min. 53 sec ITPUB个人空间IE+T o%^P
Trace Level support
@VW k rOE_`0 Security ON: Local OS Authentication ITPUB个人空间,g6F'S}PC9D
SNMP OFF ITPUB个人空间$\u [3B!SDy A
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora ITPUB个人空间kesX0DST s1w
Listener Log File /u01/app/11.2.0/grid/network/log/listener_scan1.log
oo6@'@? i0 Listener Trace File /u01/app/11.2.0/grid/network/trace/listener_scan1.trc ITPUB个人空间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"? G5Q0 Service " 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
Node 2.
C*d&^s?(H0_G0 SCAN 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 tnslsnr ITPUB个人空间8c8L&A,}0esY
grid 4466 1 0 Feb07 ? 00:00:11 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit ITPUB个人空间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 t6cG8c0 grid 32059 31690 0 11:08 pts/1 0 grep tnslsnr
^w7o4h wR0
Database parameter LOCAL_LISTENER points to Nodes VIP address
,Qgg0vEEuH0 ITPUB个人空间7EeN1U[Zwf
SQL> show parameter local_listener
m7H#P-f'j&@+],N0
(l"J+A&R7kLe`1W0 NAME TYPE VALUE ITPUB个人空间|zh8X*bG7| X
------------------------------------ ----------- ------------------------------
3O @"T/h`,w0 local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521))))
(FO d$_/c}0 Database Parameter REMOTE_LISTENER points to SCAN name. ITPUB个人空间L.m1AVIu
ITPUB个人空间*oiC*z\O;R
SQL> show parameter remote_listener
e1i-l0\ k'q2k0 ITPUB个人空间q|H/A5Y"|1],o
NAME TYPE VALUE ITPUB个人空间 Ckv)Y9n"C\#V
------------------------------------ ----------- ------------------------------ ITPUB个人空间2N;w/~~7T s(H6}
remote_listener string netrac-scan.uk.oracle.com:1521
[grid@netrac2 admin]$ more listener.ora
[U`_(SE0 LISTENER_SCAN2 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent ITPUB个人空间-n#iM[%k/Z
LISTENER_SCAN1 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ITPUB个人空间5Iy-F nc~G*{b
LISTENER =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by Agent ITPUB个人空间*pN{7h^!i0M L!ki
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
lQ ~2WI0 ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
7]]8z/H;o J1MV0 ENABLE_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 address ITPUB个人空间o&EP%F9[ [l m
8\ ZbOGP1C]L0
[grid@netrac2 admin]$ more endpoints_listener.ora ITPUB个人空间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
Listener status "listener" showing 1 instance registered
1P%uG5?-m0
g*gX9c\%]0R.f^0
[grid@ netrac2 admin]$ lsnrctl status listener ITPUB个人空间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/_J0nM0 Copyright (c) 1991, 2009, Oracle. All rights reserved.
h%M]#jd4{G,V0 ITPUB个人空间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(h0 Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production ITPUB个人空间+^;Z'D[1x0Cx0N
Start Date 07-FEB-2011 10:48:06 ITPUB个人空间{*y9P.[} S5|.v8^.{
Uptime 8 days 0 hr. 36 min. 22 sec ITPUB个人空间az,a^%eoy
Trace Level off
^8rw Q*~ O9Q0 Security ON: Local OS Authentication ITPUB个人空间yKP[Yoo0B!c
SNMP OFF ITPUB个人空间cct0RVK s
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora ITPUB个人空间v'} kMyva/h
Listener Log File /u01/app/grid/diag/tnslsnr/netrac2/listener/alert/log.xml ITPUB个人空间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/C0 Services 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:}0 The command completed successfully ITPUB个人空间`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{0 ITPUB个人空间haJoC s
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2011 11:32:14 ITPUB个人空间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+{0 STATUS of the LISTENER ITPUB个人空间5M$l&E PH,y
------------------------ ITPUB个人空间N$Yk E"Z*I+W9i7cd;lH
Alias LISTENER_SCAN2
-X8Q/EL)c/az%P0 Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production ITPUB个人空间)Jw4os$nJE
Start Date 07-FEB-2011 10:48:06 ITPUB个人空间 fh-fm/iCY
Uptime 8 days 0 hr. 44 min. 7 sec ITPUB个人空间l}CX&d:}L
Trace Level off
"ZI1u1|#QON0 Security ON: Local OS Authentication ITPUB个人空间1hQ_G/xQ5RJx
SNMP OFF
9X*|xHI0 Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora ITPUB个人空间!rB3`X6D#v
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/netrac2/listener_scan2/alert/log.xml
!X6Jc,\s5H)O9U0 Listening 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 Dp0 Services Summary...
#D7mUh J0 Service " 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/@0 The command completed successfully
Further information on the listeners can be found via svrctl ITPUB个人空间V&d){ z$B-C9vuq
ITPUB个人空间bn]!l/L.|
[grid@netrac1 admin]$ srvctl config scan_listener
rS0z c%nC+c7lM0 SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
G;x8IB"Z3ihwk1Pj|0 SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
F1A cN(c \A$w0 ITPUB个人空间HI+ct8LI
[grid@netrac1 admin]$ srvctl config scan
m`7DE7c8H0 SCAN 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;Z0 SCAN VIP name: scan1, IP: /netrac-scan.uk.oracle.com/11.111.111.11
7A2W;J:u7Y:@~0 SCAN VIP name: scan2, IP: /netrac-scan.uk.oracle.com/22.222.222.22 ITPUB个人空间9B q7D.G_}PSs
Configuration changes to the Listener are made via svrctl ITPUB个人空间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^0 Note 975457.1 How to Troubleshoot Connectivity Issue with
11gR2 SCAN Name ITPUB个人空间+Q7v;^-j+K&W*Q,J
Note 972500.1 How to Modify SCAN Setting after Installation
U](Zzm(Q~H0
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
C:\Documents and Settings\sflood>sqlplus scott/tiger@netscan ITPUB个人空间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 uHP0 Copyright (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&f0 Connected to:
Z#y0R7t%U7fF0 Oracle Database
11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production ITPUB个人空间L _wE^Vf4H
With the Partitioning, Real Application Clusters, Automatic Storage Management,
} Q-Th^3O4Y:?w'B0 Data Mining and Real Application Testing options
w g6ZN6V J7e'}r0 ITPUB个人空间-]_/[,vW||
SQL> select instance_name from v$instance;
|jw9{v$I$w1DO0 ITPUB个人空间G*J0XA8d J)~M
INSTANCE_NAME
.lbB `z2U0 ----------------
~"^ghM"R{M0 v11gr22
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
Resolve the Scan address and build connection information on address information supplied by DNS ITPUB个人空间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: entry ITPUB个人空间 dH)oE`y
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exit ITPUB个人空间p;I+~N'L z%A ssf
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entry ITPUB个人空间@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.11 ITPUB个人空间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
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: entry ITPUB个人空间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
Redirect packet from Scan TNS listener ITPUB个人空间'[lY YS
5XN{#UZM3Bjz0
[15-FEB-2011 11:43:02:859] nscon: got NSPTRD packet ITPUB个人空间M JbS+Gsa?hd
Connection told to redirect to Node 2 Node listener
Bo&hSd0 ITPUB个人空间!nm+goT`P
[15-FEB-2011 11:43:02:859] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521)))
ITPUB个人空间o%Jy5JEA;PCConnection handshake completed (Connect, Resend, Connect, Accept)
I;Z kqu"NW;zY0 ITPUB个人空间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 packet ITPUB个人空间gQ$S/YN q
%I`}U%a? Le b*N0 [15-FEB-2011 11:43:02:921] nscon: got NSPTRS packet
c1l.wo;k`0 ITPUB个人空间+S/aVb#^"Y!jh
[15-FEB-2011 11:43:02:921] nscon: sending NSPTCN packet
`1^iy$O.O8It O0 ITPUB个人空间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\ZO3YY0 ITPUB个人空间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...|
ceK9mSv0 And 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
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 )
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 Environment ITPUB个人空间'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*Dr5D0 ITPUB个人空间5`Zc({ O~E7A ~8v)H
1M!f2?.~P%| ]H"\-g[0
+e V xc5m3C2S0 ITPUB个人空间 f.w m J-Pn/I
ITPUB个人空间%Th+d%Y%N
查看更多关于11gR2中的SCAN监听器和本地监听器配置的详细内容...