7 Replies Latest reply on Aug 12, 2010 5:04 PM by Sebastian Solbach -Database Community-Oracle

    RAC: Multiple Databases / Instances with network seperation

    779068
      Dear all,
      We are planning to run our oracle 11g DB on RAC, with two instances both on seperate networks. Is this possible?
      here is what i mean
      Instance 1 including RAC DB is configured in e.g VLAN 12 with subnet 192.168.120.0/24. Instance 2 is configured in VLAN 22 with subnet 192.168.122.0/24. Servers of instance 2 send their data also to instance 1 RAC DB at subnet 192.168.120.0/24. Traffic between them is routed by a Cisco router.

      i searched the net for similar implementations and found a couple of people running similar configurations on RAC,
      but i want to know any downsides/pros cons of running such a setup.

      THanks in advance
      Saad
        • 1. Re: RAC: Multiple Databases / Instances with network seperation
          BelMan
          the vip will do it for you
          http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle11gRAC/CLUSTER_10.shtml#Network Configuration
          • 2. Re: RAC: Multiple Databases / Instances with network seperation
            440066
            Hi Saad,

            Please note: Scan-vip, node-vip and public IP addresses for ONE RAC cluster database must be on the same subnet.

            Yes, you can run TWO or MORE different rac cluster-databases on different subnets.
            But all of instances (2,3,4, ... .. 100.. ) of ONE RAC Cluster database must be on the same subnet.

            I hope it, answer's your query.

            do also share the url's which you refer, that the people are running different instances of the same cluster databases on different subnets.


            Regards,
            Mr. X
            • 3. Re: RAC: Multiple Databases / Instances with network seperation
              user9343608
              Hi Saad,
              Can you share some docs which show how to run TWO or MORE different rac cluster-databases on different subnets. I have a situation where i have to create a 10gR2 RAC cluster and have to form two databases which are part of different networks. Main point is can 10gR2 handle this or i will have to go in for a higher version.
              If you have any docs can you please email me at amoljoshi1977@yahoo.com

              Thanks
              Amol
              email: amoljoshi1977@yahoo.com
              • 4. Re: RAC: Multiple Databases / Instances with network seperation
                779068
                Dear Amol,
                I know that 10GR2 can handle this. I used the configuration and steps in BelMans link above. You can use dbca to create and configure two different databases. and configure listener.ora for both the db services.

                Saad
                • 5. Re: RAC: Multiple Databases / Instances with network seperation
                  user9343608
                  Hi Saad,
                  The problem in my case is clusterware configuration. While creating the cluster CRS asks for public IP,Private IP and VIP for both nodes. I can do it for one database environment which we call here pre-prod.

                  The prod environment also uses the same hardware but is in different subnet and will use same cluster. Can i put vips for that environment when clusterware asks for public ip,private ip and vips.

                  Or as you suggested,create cluster using ip of one subnet and create database for it and for second network create just database and in listerner.ora enter vips of prod environment. My current hosts file looks like this


                  # Do not remove the following line, or various programs
                  # that require network functionality will fail.
                  127.0.0.1 localhost.localdomain localhost
                  ::1 localhost6.localdomain6 localhost6

                  #Production
                  10.88.118.200 cps-oracle-vip.fedex.com cps-oracle-vip
                  10.88.118.201 cps-oracle-1.fedex.com cps-oracle-1
                  10.88.118.202 cps-oracle-2.fedex.com cps-oracle-2
                  10.88.118.203 cps-oracle-1-vip.fedex.com cps-oracle-1-vip
                  10.88.118.204 cps-oracle-2-vip.fedex.com cps-oracle-2-vip

                  #Pre-Production
                  10.88.119.200 cps-pre-oracle-vip.fedex.com cps-pre-oracle-vip
                  10.88.119.201 cps-pre-oracle-1.fedex.com cps-pre-oracle-1
                  10.88.119.202 cps-pre-oracle-2.fedex.com cps-pre-oracle-2
                  10.88.119.203 cps-pre-oracle-1-vip.fedex.com cps-pre-oracle-1-vip
                  10.88.119.204 cps-pre-oracle-2-vip.fedex.com cps-pre-oracle-2-vip

                  #Internal
                  192.168.101.1 cps-oracle-1-priv.fedex.com cps-oracle-1-priv
                  192.168.101.2 cps-oracle-2-priv.fedex.com cps-oracle-2-priv

                  Does 11G provide facility to enter multiple vips in CRS.
                  • 6. Re: RAC: Multiple Databases / Instances with network seperation
                    user9343608
                    Hi Belman,
                    Need advise on RAC CRS configuration

                    ISSUE : I have to create ORACLE 10G R2 RAC. This cluster will host two databases pre-prod and prod. Both databases will be on different networks. pre-prod on 10.88.119 and prod on 10.88.118. I just have two hosts forming the this cluster.
                    How can i configure my hosts file and during clusterware installation what entries should i make for hosts and interfaces.
                    Can this be done in 10gR2 or will have to switch to 11gR2

                    My current hosts file looks like this

                    # Do not remove the following line, or various programs
                    # that require network functionality will fail.
                    127.0.0.1 localhost.localdomain localhost
                    ::1 localhost6.localdomain6 localhost6

                    #Production
                    10.88.118.200 cps-oracle-vip.fedex.com cps-oracle-vip
                    10.88.118.201 cps-oracle-1.fedex.com cps-oracle-1
                    10.88.118.202 cps-oracle-2.fedex.com cps-oracle-2
                    10.88.118.203 cps-oracle-1-vip.fedex.com cps-oracle-1-vip
                    10.88.118.204 cps-oracle-2-vip.fedex.com cps-oracle-2-vip

                    #Pre-Production
                    10.88.119.200 cps-pre-oracle-vip.fedex.com cps-pre-oracle-vip
                    10.88.119.201 cps-pre-oracle-1.fedex.com cps-pre-oracle-1
                    10.88.119.202 cps-pre-oracle-2.fedex.com cps-pre-oracle-2
                    10.88.119.203 cps-pre-oracle-1-vip.fedex.com cps-pre-oracle-1-vip
                    10.88.119.204 cps-pre-oracle-2-vip.fedex.com cps-pre-oracle-2-vip

                    #Internal
                    192.168.101.1 cps-oracle-1-priv.fedex.com cps-oracle-1-priv
                    192.168.101.2 cps-oracle-2-priv.fedex.com cps-oracle-2-priv

                    Does 11G provide facility to enter multiple vips in CRS.
                    • 7. Re: RAC: Multiple Databases / Instances with network seperation
                      Sebastian Solbach -Database Community-Oracle
                      Hi,

                      Multiple VIPs in different Networks is a new feature of 11gR2 grid infrastructure.

                      See listener_network parameter of the database.

                      Sebastian