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
