yep, you can do that. we run all of our clusters on two networks,
routing data guard traffic over a backup network and client traffic
over a public network. others are doing it too.
read this thread:
//www.freelists.org/post/oracle-l/Oracle-RAC-listener-on-a-2nd-network
(see related posts at the bottom)
find setup info in MOS note 1063571.1
and check out my email about the problem i had in 11.2.0.3 and the workaround:
//www.freelists.org/post/oracle-l/Oracle-RAC-listener-on-a-2nd-network,13
-Jeremy
--
http://about.me/jeremy_schneider
On Tue, Sep 15, 2015 at 4:53 PM, David Barbour <david.barbour1@xxxxxxxxx> wrote:
This is fun. We've got two networks. One is a 'people' network from which--
our users connect to application servers and the like. The other is a
'core' network wholly contained within our data center on which all the
database servers reside.
Recently we've had a requirement to allow users to access several databases
directly with tools like SQL Developer, TOAD, Tableau, Qlikview and the
like. The databases to which they required access were on standalone
servers with network connections to both the 'people' network and the 'core'
network. So I defined the connection in tnsnames.ora to connect to the
people NIC rather than the core NIC.
Now I've converted the server to a node in a RAC. All the RAC IP addresses
are on the core network. And I'm using a SCAN listener. I can not figure
out how to get the database available on both the people and core networks.
So my previous tnsnames.ora definition looked like this (where rchr2p01-pub
represents the IP for this server on the people network):
P28R =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rchr2p01-pub.lennoxintl.com)(PORT =
1536))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = P28R))
)
The listener was started from the database home using lsnrctl:
LISTENER_P28R =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL = IPC)
(KEY = P28R))
(ADDRESS =
(PROTOCOL = TCP)
(HOST = rchr2p01-pub.lennoxintl.com)
(PORT = 1536))
)
Now the listener is started from the grid home using srvctl and registers as
an endpoint with the SCAN listener. It will see the non-standard port just
fine, as long as the tnsnames.ora entry uses the core IP address hostname.
As soon as I plug in the non-core hostname, I'm out of business. I've tried
defining the local_listener parameter and tnsnames.ora a variety of ways,
but can't make the bridge from the users desktop to the database.
Has anyone encountered a similar requirement/situation and figured out a
solution?
