Forum Stats

  • 3,769,714 Users
  • 2,253,014 Discussions


how to find public IP address of SCAN?

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, 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?)


  • 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




    TEST =




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

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