Connecting to RAC using Two Networks - Users Need to Log In to DB's Directly

From: David Barbour <david.barbour1_at_gmail.com>
Date: Tue, 15 Sep 2015 15:53:54 -0500
Message-ID: <CAFH+iffXeQ8oNibCMc1poSAoBA+RU2xQdqKzdZ+MvDOddWX3NA_at_mail.gmail.com>

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?

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 15 2015 - 22:53:54 CEST