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.[@more@]

Solution

Example for 2 Node cluster with 2 Scan listeners running, with following details:

Ipaddress        
Hostname
--------------   -------------------------------------
Scan 
Addresses:
11.111.111.11    netrac-scan 
netrac-scan.uk.oracle.com
22.222.222.22    netrac-scan 
netrac-scan.uk.oracle.com

Node Addresses:
12.345.678.111   netrac1 
netrac1.uk.oracle.com
12.345.678.222   netrac2 
netrac2.uk.oracle.com

Node VIP's
12.345.678.888   netrac1-vip 
netrac1-vip.uk.oracle.com
12.345.678.999   netrac2-vip 
netrac2-vip.uk.oracle.com

Database called "v11gr2"
Scan listeners called LISTENER_SCAN1 and LISTENER_SCAN2
(Most configurations will have upto 3 SCAN listeners configured)
DNS setup for the scan address to resolve to 11.111.11.11 or 22.222.222.22

C:>nslookup 
netrac-scan.uk.oracle.com
Server: 
dns001.uk.oracle.com
Address: 10.10.1.0

Name: 
netrac-scan.uk.oracle.com
Addresses: 11.111.111.11, 
22.222.222.22

Node 1.

SCAN listener "LISTENER_SCAN1" is currently running on Node 1.
Both the SCAN and Node listeners run from the grid oracle home. This the recommend setup.

[grid@netrac1 admin]$ 
ps -ef |grep tnslsnr
grid 9185 1 0 10:57 ? 00:00:00 
/u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
grid 9707 
9061 0 11:09 pts/3 00:00:00 grep tnslsnr
grid 10762 1 0 Feb08 ? 00:03:19 
/u01/app/11.2.0/grid/bin/tnslsnr listener_scan1 
-inherit

Database parameter LOCAL_LISTENER points to Node VIP address

SQL> show parameter 
local_listener

NAME TYPE VALUE
------------------------------------ 
----------- ------------------------------
local_listener string 
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac1-vip)(PORT=1521))))

Database Parameter REMOTE_LISTENER points to SCAN name

SQL> show parameter 
remote_listener

NAME TYPE VALUE
------------------------------------ 
----------- ------------------------------
remote_listener string 
netrac-scan.uk.oracle.com:1521

Listener.ora

[grid@netrac1 admin]$ 
more 
listener.ora
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) 
# line added by 
Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# 
line added by 
Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) 
# line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # 
line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added 
by Agent
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.

Listener status "listener" showing 1 instance registered, ie instance running on the node

[grid@netrac1 admin]$ lsnrctl status 
listener
Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the 
LISTENER
------------------------
Alias 
LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - 
Production
Start Date 15-FEB-2011 10:57:09
Uptime 0 days 0 hr. 0 min. 46 
sec
Trace Level off
Security ON: Local OS Authentication
SNMP 
OFF
Listener Parameter File 
/u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File 
/u01/app/grid/diag/tnslsnr/netrac1/listener/alert/log.xml
Listening Endpoints 
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.111)(PORT=1521))) 
** Node IP Address 
**
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.888)(PORT=1521))) 
** Node VIP Address **
Services Summary...
Service 
"v11gr2" has 1 instance(s).
Instance 
"v11gr21", status READY, has 2 handler(s) for this 
service...
The command completed successfully

New file for 11.2 called endpoints_listener.ora, showing the Node IP address and Node VIP address.

[grid@netrac1 admin]$ 
more 
endpoints_listener.ora
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.
DBCA needs to know the endpoints location to configure database parameters and tnsnames.ora file.
It used to use the listener.ora file, 11.2 RAC listener.ora by default only has IPC entries.

Listener status "listener_scan1" showing both instances registered from the nodes.

[grid@netrac1 admin]$ lsnrctl status 
listener_scan1

LSNRCTL for Linux: Version 11.2.0.1.0 - 
Production on 15-FEB-2011 11:04:46

Copyright (c) 1991, 2009, Oracle. All 
rights reserved.

Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the 
LISTENER
------------------------
Alias 
listener_scan1
Version TNSLSNR for Linux: Version 11.2.0.1.0 
- Production
Start Date 08-FEB-2011 15:46:52
Uptime 6 days 19 hr. 17 min. 
53 sec
Trace Level support
Security ON: Local OS Authentication
SNMP 
OFF
Listener Parameter File 
/u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File 
/u01/app/11.2.0/grid/network/log/listener_scan1.log
Listener Trace File 
/u01/app/11.2.0/grid/network/trace/listener_scan1.trc
Listening Endpoints 
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.111.111.11)(PORT=1521))) 
** Scan VIP **
Services Summary...
Service 
"v11gr2" has 2 instance(s).
Instance 
"v11gr21", status READY, has 3 handler(s) for this 
service...
Instance "v11gr22", status READY, has 2 
handler(s) for this service...
The command completed 
successfully

Node 2.
SCAN listener "LISTENER_SCAN2" is currently running on Node 2, along with node listener "listener"

[grid@netrac2 ~]$ ps 
-ef |grep tnslsnr
grid 4466 1 0 Feb07 ? 00:00:11 
/u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
grid 4481 
1 0 Feb07 ? 00:00:13 /u01/app/11.2.0/grid/bin/tnslsnr 
LISTENER_SCAN2 -inherit
grid 32059 31690 0 11:08 pts/1 
00:00:00 grep tnslsnr

Database parameter LOCAL_LISTENER points to Nodes VIP address

SQL> show parameter 
local_listener

NAME TYPE VALUE
------------------------------------ 
----------- ------------------------------
local_listener string 
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=netrac2-vip)(PORT=1521))))

Database Parameter REMOTE_LISTENER points to SCAN name.

SQL> show parameter 
remote_listener

NAME TYPE VALUE
------------------------------------ 
----------- ------------------------------
remote_listener string 
netrac-scan.uk.oracle.com:1521

Listener.ora

[grid@netrac2 admin]$ 
more 
listener.ora
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) 
# line added by 
Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) 
# line added by 
Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# 
line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added 
by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by 
Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by 
Agent

"Line added by Agent" is the Oraagent is the process updating the listener.ora and endpoints_listener.ora files.

Endpoints_listener.ora showing the Node IP address and Node VIP address

[grid@netrac2 admin]$ 
more 
endpoints_listener.ora
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

Listener status "listener" showing 1 instance registered

[grid@netrac2 admin]$ lsnrctl status 
listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 
15-FEB-2011 11:24:28

Copyright (c) 1991, 2009, Oracle. All rights 
reserved.

Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the 
LISTENER
------------------------
Alias 
LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - 
Production
Start Date 07-FEB-2011 10:48:06
Uptime 8 days 0 hr. 36 min. 22 
sec
Trace Level off
Security ON: Local OS Authentication
SNMP 
OFF
Listener Parameter File 
/u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File 
/u01/app/grid/diag/tnslsnr/netrac2/listener/alert/log.xml
Listening Endpoints 
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.222)(PORT=1521))) 
**Node IP 
Address**
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=12.345.678.999)(PORT=1521))) 
**Node VIP Address**
Services Summary...
Service 
"v11gr2" has 1 instance(s).
Instance 
"v11gr22", status READY, has 2 handler(s) for this 
service...
The command completed successfully

Listener status "listener_scan2" showing both instances registered

[grid@netrac2 admin]$ lsnrctl status 
listener_scan2

LSNRCTL for Linux: Version 11.2.0.1.0 - 
Production on 15-FEB-2011 11:32:14

Copyright (c) 1991, 2009, Oracle. All 
rights reserved.

Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the 
LISTENER
------------------------
Alias 
LISTENER_SCAN2
Version TNSLSNR for Linux: Version 11.2.0.1.0 
- Production
Start Date 07-FEB-2011 10:48:06
Uptime 8 days 0 hr. 44 min. 7 
sec
Trace Level off
Security ON: Local OS Authentication
SNMP 
OFF
Listener Parameter File 
/u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File 
/u01/app/11.2.0/grid/log/diag/tnslsnr/netrac2/listener_scan2/alert/log.xml
Listening 
Endpoints 
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=22.222.222.22)(PORT=1521)))** 
Scan VIP **
Services Summary...
Service "v11gr2" 
has 2 instance(s).
Instance "v11gr21", status READY, has 3 
handler(s) for this service...
Instance "v11gr22", status 
READY, has 2 handler(s) for this service...
The command completed 
successfully

Further information on the listeners can be found via svrctl

[grid@netrac1 admin]$ 
srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: 
TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: 
TCP:1521

[grid@netrac1 admin]$ srvctl config scan
SCAN name: 
netrac-scan.uk.oracle.com, Network: 
1/10.167.20.50
.240.0/255.255.240.0/eth1
SCAN VIP name: scan1, IP: 
/netrac-scan.uk.oracle.com/11.111.111.11
SCAN VIP name: scan2, IP: 
/netrac-scan.uk.oracle.com/22.222.222.22

Configuration changes to the Listener are made via svrctlNote 952903.1 How to update the IP address of the SCAN VIP resources (ora.scan.vip)Note 975457.1 How to Troubleshoot Connectivity Issue with 11gR2 SCAN NameNote 972500.1 How to Modify SCAN Setting after Installation

Client connection example

C:Documents and 
Settingssflood>sqlplus scott/tiger@netscan

SQL*Plus: Release 
11.2.0.1.0 Production on Tue Feb 15 11:43:02 2011

Copyright (c) 1982, 
2010, Oracle. All rights reserved.


Connected to:
Oracle Database 
11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the 
Partitioning, Real Application Clusters, Automatic Storage Management,
Data 
Mining and Real Application Testing options

SQL> select instance_name 
from 
v$instance;

INSTANCE_NAME
----------------
v11gr22

Calling address used

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:OracleRDBMS112binsqlplus.exe)(HOST=sflood-uk)(USER=sflood))))

Resolve the Scan address and build connection information on address information supplied by DNS

[15-FEB-2011 11:43:02:703] nlad_expand_hst: Expanding netrac-scan.uk.oracle.com
[15-FEB-2011 11:43:02:703] snlinGetAddrInfo: entry
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exit
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entry
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 11.111.111.11
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: entry
[15-FEB-2011 11:43:02:734] snlinGetNameInfo: exit
[15-FEB-2011 11:43:02:734] nlad_expand_hst: Adding IP 22.222.222.22
[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: entry
[15-FEB-2011 11:43:02:734] snlinFreeAddrInfo: exit
[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:OracleRDBMS112binsqlplus.exe)(HOST=sflood-uk)(USER=sflood))))

Selected Node 1

[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:OracleRDBMS112binsqlplus.exe)(HOST=sflood-uk)(USER=sflood))))
[15-FEB-2011 11:43:02:734] nttbnd2addr: entry
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: entry
[15-FEB-2011 11:43:02:734] snlinGetAddrInfo: exit
[15-FEB-2011 11:43:02:734] nttbnd2addr: using host IP address: 11.111.111.11

Start of the connection handshake

[15-FEB-2011 11:43:02:734] nscon: doing connect handshake...
[15-FEB-2011 11:43:02:734] nscon: sending NSPTCN packet

Redirect packet from Scan TNS listener

[15-FEB-2011 11:43:02:859] nscon: got NSPTRD packet

Connection told to redirect to Node 2 Node listener

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

Connection handshake completed (Connect, Resend, Connect, Accept)

[15-FEB-2011 11:43:02:890] nscon: doing connect handshake...
[15-FEB-2011 11:43:02:890] nscon: sending NSPTCN packet

[15-FEB-2011 11:43:02:921] nscon: got NSPTRS packet

[15-FEB-2011 11:43:02:921] nscon: sending NSPTCN packet

[15-FEB-2011 11:43:02:921] nscon: got NSPTAC packet

After authentication and banner packets pass, we see the select run "nsbasic_bsd" = send

And the information received "nsbasic_brc" = receive

[15-FEB-2011 11:43:11:953] nsbasic_brc: 00 00 0D 49 4E 53 54 41 |...INSTA|
[15-FEB-2011 11:43:11:953] nsbasic_brc: 4E 43 45 5F 4E 41 4D 45 |NCE_NAME|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 07 00 |........|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 07 78 6F 02 0F 0C |...xo...|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 2F 28 00 00 00 00 E8 1F |/(......|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 33 00 00 00 33 00 |..3...3.|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 06 22 |......."|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 01 00 00 00 00 00 01 00 |........|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 00 00 00 00 |........|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 00 00 00 00 07 07 76 31 |......v1|
[15-FEB-2011 11:43:11:968] nsbasic_brc: 31 67 72 32 32 08 06 00 |1gr22...|
[15-FEB-2011 11:43:11:968] nsbasic_brc: BE 7C FC 02 00 00 00 00 |.|......|

TNSNAMES.ORA entry only now needs to have the Scan name

NETSCAN 
=
(DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST 
= netrac-scan.uk.oracle.com)(PORT = 1521))
  )
(CONNECT_DATA =
  
(SERVICE_NAME = v11gr2)
  )
)

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.

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.

[Insert note here]

References

NOTE:948456.1 - Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment

ITPub博客

Scan and Node TNS Listener Setup Examples

Solution

Client connection example

References

最新文章