Forum Stats

  • 3,769,714 Users
  • 2,253,014 Discussions
  • 7,875,157 Comments

Discussions

how to find public IP address of SCAN?

user3886115
user3886115 Member Posts: 2 Blue Ribbon

After 3 frustrating days dealing with service limits, I was finally successful in creating a 2 node DB VM system on Oracle Cloud.

I figured out the external IP addresses of the 2 nodes, and was successful in connecting to one of them (I didn't try the other).

But now I realize I should probably connect to the SCAN (Single Client Access Name) address rather than directly to a node. I see an internal DNS name orclrac-scan.sub05220010500.vcn1.oraclevcn.com, but I can't find a public IP address or DNS name.

How do I find the public SCAN address? (or if there isn't one, how should I be connecting to the RAC cluster from outside my VCN?)

Answers

  • user3886115
    user3886115 Member Posts: 2 Blue Ribbon

    OK - question answered.

    In case anyone else comes across this with the same question:

    SCAN IP are always private

    instead create a client side tnsnames.ora file that uses both public IPs and set the load balancer to active

    EXAMPLE

    =============

     

    TEST =

    (DESCRIPTION =

    (LOAD_BALANCE = ON)

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = [node 1 public IP)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = [node 2 public IP)(PORT = 1521)))

    (CONNECT_DATA =

    (SERVICE_NAME = TEST))))