Subscribe
Accepted Solution

SMO - RAC Listener IPs

[ Edited ]

Oracle Linux 5.6 x64

Oracle 11.2.0.2 & 11.2.0.3

2 node RAC

SMO 3.1 & 3.2

In an Oracle RAC two node cluster, out of the box the listeners are configured on the virtual IP of each RAC node.  It seems that when creating a SMO profile, it will only work if the listeners are configured on the local host IPs.  I don't see this in the doc but am wondering if it's a true requirement to have listeners configured on the local IPs.  This would be with database authentication and not OS authentication.

The consistent error message I get is below.  But when it's a listener on a local IP it works.

Operation Id [ff80808135ee99760135ee998073000a] failed. Error: Cannot connect to database instance oracdb1 using JDBC connect string dbc:oracle:thin:smooper/XXXXXXXX@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bpic-na-rac1)(PORT = 1521)))(CONNECT_DATA = (SID = oracdb1))).  Error: Io exception: The Network Adapter could not establish the connection.

My guess is that SMO is resolving the host name (bpic-na-rac1) the IP and the listener is not configured on that IP, it's on the virtual IP.  See where I'm coming from?  10.89.38.214 is the local IP and is in DNS as "bpic-na-rac1" and 10.89.38.218 is in DNS as "bpic-na-rac1-vip". 

[oracle@bpic-na-rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-MAR-2012 13:50:38

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                05-MAR-2012 19:14:10

Uptime                    1 days 18 hr. 36 min. 27 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/oracle/diag/tnslsnr/bpic-na-rac1/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.89.38.218)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "oracdb.nalabs.tst" has 1 instance(s).

  Instance "oracdb1", status READY, has 1 handler(s) for this service...

Service "oracdbXDB.nalabs.tst" has 1 instance(s).

  Instance "oracdb1", status READY, has 1 handler(s) for this service...

The command completed successfully

SMO - RAC Listener IPs

I actually had a misconfiguration that caused this unneeded an additional step with the listener to be taken.  In my /etc/hosts file the host name was specified under the loop back address (127.0.0.1).  I removed it and the listener started up with both the local IP and the VIP.  Problem solved.