This discussion is archived
2 Replies Latest reply: Jul 2, 2012 2:06 PM by rajeysh RSS

RAC and SCAN and TNS

TakhteJamshid Newbie
Currently Being Moderated
Hi

suppose that I have got a RAC (Oracle 11gR2) environment and my SCAN IPs are
172.21.28.115
172.21.28.116
172.21.28.117

I can define TNS name like this
RAC=(DESCRIPTION =
            (ADDRESS=(PROTOCOL=TCP)(HOST=scan)(PORT=1521))
             (CONNECT_DATA=
                (SERVICE=DEDICATED)
                (SERVICE_NAME=rac.com)
    )
)
Consider that I don't want use DNS in client side ,_But my RAC servers have a DNS for SCAN_
for example my application server can't use DNS

Now can I substitute the IPs with scan like follow example ?
RAC=(DESCRIPTION =
            (LOAD_BALANCE=YES)
            (ADDRESS=(PROTOCOL=TCP)(HOST=172.21.28.115)(PORT=1521))
             (ADDRESS=(PROTOCOL=TCP)(HOST=172.21.28.116)(PORT=1521))
             (ADDRESS=(PROTOCOL=TCP)(HOST=172.21.28.117)(PORT=1521))
             (CONNECT_DATA=
                (SERVICE=DEDICATED)
                (SERVICE_NAME=rac.com)
    )
)
Do I miss any thing if I don't use DNS in Clients?


thanks
  • 1. Re: RAC and SCAN and TNS
    KuljeetPalSingh Guru
    Currently Being Moderated
    Consider that I don't want use DNS in client side ,But my RAC servers have a DNS for SCAN
    you can still use VIP to make connectivity even you've configured SCAN.
    entry would be same as we were using in 10g.
    DB =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = tcp)(HOST = ****)(PORT = 1521))
          (ADDRESS = (PROTOCOL = tcp)(HOST = ****)(PORT = 1521))
          (LOAD_BALANCE = yes)
        )
        (CONNECT_DATA =
          (SERVICE_NAME = DB)
          (FAILOVER_MODE =
            (TYPE = select)
            (METHOD = basic)
            (RETRIES = 20)
            (DELAY = 3)
          )
        )
      )
  • 2. Re: RAC and SCAN and TNS
    rajeysh Guru
    Currently Being Moderated
    Refer:- this may help you.
    How to connect to Oracle RAC via SCAN
    RAC SCAN confusion.
    http://www.oraclemasters.in/?p=1296
    http://ruanrong.itpub.net/post/4817/520232

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points