This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Dec 5, 2012 6:03 AM by dm48 RSS

How to create a SCAN Name

35818 Oracle ACE
Currently Being Moderated
I am upgrading an 11.1.0.7 RAC install to release 2 and am getting stymied at the need for a SCAN name. How is this set up? I see vague hand waving about DNS this and DHCP that but that isn't much help when I have a basic two-node RedHat cluster using the hosts file. I have searched the doc set and Googled with no luck. If someone could point me in the right direction I would be appreciative!
  • 1. Re: How to create a SCAN Name
    damorgan Oracle ACE Director
    Currently Being Moderated
    I've been running 11.2 in my lab for many months and have never once been asked for a scan name.

    Oracle recommends fixed IP addresses. You should definitely not use DHCP with RAC.
  • 2. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    Dan,

    My situation is I have a running 11.1.0.7 RAC cluster using fixed IP addresses resolved through a HOSTS file. I am using ASM with OCFS2 for the vote and config files. In order to update you have to update ASM first. During the third step in the process (using the runInstaller) it requires you to enter a SCAN name. The only things I have been able to find about it are that it allows a single name to address the entire cluster at the server level (it is not the same as the cluster name). This is different from a tnsnames entry allowing all of the instances to be reached by a single name (aultdb for aultdb1 and aultdb2 for example.) It specifically states that the SCAN name must be registered with the DNS or the cluster names server.

    This is the first I have heard of being able to address multiple servers in a cluster with a single name, seems like that could be a bit confusing. I am sure if I blew away my current 11.1.0.7 install and reinstalled it would probably work but I wanted to keep the database the same exact one in the same layout and setup. Has anyone else tried an update of an existing 11.1.0.7 RAC using ASM and OCFS2 for the vote and config disks?

    Mike
  • 3. Re: How to create a SCAN Name
    damorgan Oracle ACE Director
    Currently Being Moderated
    Based on the information here:

    http://download.oracle.com/docs/cd/E11882_01/server.112/e10880/giinstaller_errormessages.htm#sthref25965

    See INS-40922 it would appear that the name must be resolvable to an IP Address. You are not going to be able to address multiple anythings with a single IP Address.

    Please open an SR and report back to us the resolution.

    I am sending a note to the docs team that the doc, perhaps, need to address this.
  • 4. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    Actually I am getting:

    INS-40719: IP address configured for Single Client Access Name (SCAN): string is already assigned to another system.
    Cause: The installer could not find the IP addresses you selected as SCAN addresses. This may be because they are assigned to another system, or the IP addresses are not listed in the DNS or hosts files as assigned to this domain name.

    I have, in the hosts file:

    assigned the cluster name as an alias to the public IP in hosts, same error
    assigned the cluster name to a new IP address not assigned to a eth card, same error
    assigned the the cluster name to a new IP address assigned to the same card as the public IP, same error

    I will retry number three with a reboot.
  • 5. Re: How to create a SCAN Name
    damorgan Oracle ACE Director
    Currently Being Moderated
    I got a response back from the RAC pack ... suggest you look in the Grid docs.

    Have you tried leaving it as NULL?
  • 6. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    Null doesn't work.

    From the docs:

    1.3.2.2.1 IP Address Requirements for Manual Configuration
    The public and virtual IP addresses must be static addresses, configured before installation, and the virtual IP addresses for each node must not currently be in use. Oracle Clusterware manages private IP addresses in the private subnet on interfaces you identify as private during the installation interview.

    Configure the following addresses:

    •A public IP address for each node

    •A virtual IP address for each node

    •A single client access name (SCAN) configured on the domain name server (DNS) for Round Robin resolution to three addresses (recommended) or at least one address.

    The single client access name (SCAN) is a hostname used to provide service access for clients to the cluster. Because the SCAN is associated with the cluster as a whole, rather than to a particular node, the SCAN makes it possible to add or remove nodes from the cluster without needing to reconfigure clients. It also adds location independence for the databases, so that client configuration does not have to depend on which nodes are running a particular database. Clients can continue to access the cluster in the same way as with previous releases, but Oracle recommends that clients accessing the cluster use the SCAN.

    Note:

    If you manually configure addresses, then Oracle strongly recommends that you use DNS resolution for SCAN VIPs. If you use the hosts file to resolve SCANs, then you must provide a hosts file entry for each SCAN address.

    So much for not using DNS! I tried a hosts file entry for each SCAN address, it didn't work.

    So much for RTFM...maybe I shoud tell them were to put the FM...

    Mike

    Edited by: mikerault on Sep 10, 2009 2:28 PM
  • 7. Re: How to create a SCAN Name
    user41860 Newbie
    Currently Being Moderated
    Yeah, I've got the same issue.

    Was anyone able to get past this? I've tried everything. It seems ridiculous to require this feature in a 2 node-non DNS test environment.

    And I agree with Mike...the documentation for this leaves a lot to be desired.
  • 8. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    Nope, not yet. I am creating a 3TB TPC-H this week and on vacation the next so I won't get back to this for at least 2 weeks. Good Luck!

    Mike
  • 9. Re: How to create a SCAN Name
    103065 Newbie
    Currently Being Moderated
    Hi guys, I was having the same issue.
    You will need to have your network admin add an entry into the network DNS for the SCAN name you want.
  • 10. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    That is all well and good, except when it is essentially a stand-alone, 2 node RAC cluster using a public DNS....maybe I can do something through my router. I think I'll go pickle my brain cells in some tequila for a week then worry about it...(going to Cozumel to do some diving!)

    Mike
  • 11. Re: How to create a SCAN Name
    103065 Newbie
    Currently Being Moderated
    Mike have fun diving and pickling.
    You may have to start the DNS service on one of the 2 computers in the cluster.
    Assuming that you are installing on a Windows server or Linux server.
  • 12. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    I think I will run W2003 on my file server in a VM and do DNS there....
  • 13. Re: How to create a SCAN Name
    12020 Newbie
    Currently Being Moderated
    Hi, I have a 3 Node RAC 11gRel2 in Linux. Is there any possibility to implement SCAN functionality without DNS/ GNS, I mean over entries in /etc/hosts file ?
    Thanks.
    Shine
  • 14. Re: How to create a SCAN Name
    35818 Oracle ACE
    Currently Being Moderated
    If there is I couldn't find it.
1 2 Previous Next

Legend

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