SMO - RAC Listener IPs

sam_wozniak — Thu, 05 Jun 2025 06:33:12 GMT

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

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

sam_wozniak — Fri, 09 Mar 2012 03:35:59 GMT

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.

topic SMO - RAC Listener IPs in Data Protection

SMO - RAC Listener IPs

SMO - RAC Listener IPs