Virtual IP and SCAN IP in the Connection String for Oracle Extended Agent

The answer is yes that Virtual IP of Real Application Cluster(RAC)

Oracle database can be used for agent's connection string if
the RAC Oracle database listener is in listening in the Virtual IP address.

And SCAN IP for RAC Oracle can be used also if the SCAN_Listener is running.

for example in a two node RAC env:

In the node of tivx010.cn.ibm.com, 9.123.103.238 is the vip and
9.123.103.139 is the SCAN ip.

see below section from the hosts file:

9.123.103.238 tivx010-vip.cn.ibm.com tivx010-vip
9.123.103.139 rac-scan.cn.ibm.com rac-scan

Default Listener for RAC database listening in the physical IP and virtual IP

C:\Users\Administrator>E:\app\11.2.0\grid\BIN\lsnrctl status LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 11 :21 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Pr ction Start Date 17-SEP-2012 16:04:41 Uptime 2 days 18 hr. 57 min. 41 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File e:\app\11.2.0\grid\network\admin\listener.ora Listener Log File e:\app\11.2.0\grid\log\diag\tnslsnr\tivx010\listene lert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENERipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=9.123.103.137)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=9.123.103.238)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+asm1", status READY, has 1 handler(s) for this service... Service "oradb" has 1 instance(s). Instance "oradb1", status READY, has 1 handler(s) for this service... Service "oradbXDB" has 1 instance(s). Instance "oradb1", status READY, has 1 handler(s) for this service... The command completed successfully

SCAN Listener is in running

C:\Users\Administrator>E:\app\11.2.0\grid\BIN\lsnrctl stat LISTENER_SCAN1 LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 11 :15 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Pr ction Start Date 20-SEP-2012 10:43:12 Uptime 0 days 0 hr. 20 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File e:\app\11.2.0\grid\network\admin\listener.ora Listener Log File e:\app\11.2.0\grid\log\diag\tnslsnr\tivx010\listene can1\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENER_SCAN1ipc))) The listener supports no services The command completed successfully

Test Connection result with VIP is success:

Connection string is

"(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=oradb))(ADDRESS=(PROTOCOL=TCP)(HOST=9.123.103.238)(PORT=1521)))"



Test Connection result with SCAN IP is success:

Connection string is

"(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=oradb))(ADDRESS=(PROTOCOL=TCP)(HOST=9.123.103.139)(PORT=1521)))"