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

Technote (FAQ)


Question

Can the virtual IP or SCAN IP address be used in the connection string for the Oracle Extended Agent's configuration

Answer

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)))"


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Composite Application Manager for Applications
ITCAM Extended Agent for Oracle Database 5724V09OR v6.3

Software version:

6.3.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1611661

Modified date:

2012-09-27

Translate my page

Machine Translation

Content navigation