6 Replies Latest reply: Apr 8, 2014 5:34 AM by Antonio RSS

    Install other Oracle_home in addition to Oracle_home RAC

    Antonio

      Hello everyone

       

      we are planning an installation of 2 RAC's version 11gR2. We want to have the two environments one of production and another pre-production.

       

      In the installation of the 11gR2 RAC we have two different Oracle_home, one for GRID and ASM and another for Oracle RAC Database.

       

      Can we have other Oracle_home that are not in the structure of RAC ?.

      That is to say have other Oracle_home in one nodes that are not in RAC. ?

       

      Could We have a data Guard of the production environment in the second RAC without this in the structure of the RAC, in another Oracle_home, with other different users and groups for the owners of the RAC software?

       

      A greeting

        • 1. Re: Install other Oracle_home in addition to Oracle_home RAC
          teits

          yes to all your question

           

          you can have more than one oracle db software on server.

           

          in your case, i will suggest that you use one oracle db software.

          Note that RAC is just an oracle db software Option. you can use the same oracle db software binaries for both RAC and non-RAC DB.

          dbca oracle utility give you the option of either creating RAC DB or Standalone DB(non-RAC). dbca also allow you to specifies database files path(control files,datafiles etc)

           

          for your data gaurd configuration, the above statement apply.

          you can use different OS user.BUT not that you must have similar database password files for you primary and standby DB.

          Caution: it not advisable to put the primary DB and standby DB files on the same file system/Storage. \

           

          Tobi

          Tobi's Oracle DBA & UNIX Blog

          • 2. Re: Install other Oracle_home in addition to Oracle_home RAC
            Antonio

            Thanks for answering as soon.

             

            I have some more questions.

             

            1.- Then in the second RAC we can create a dataguard without this in RAC but executing it in the same Oracle_home to the databases in RAC. With the option of the dbca we create a database in a single node of the RAC.

                 The database is created as a service of RAC on a single node, and is protected with Oracle Clusterware or, on the contrary is created as a normal instance on the node that we tell.

             

            2.- We can have more than one ASM instance on the server, I think we can only have one.

             

            Re: Can we have separate 10gR2 RAC CRS and 11gR2 RAC CRS homes on same Unix s

             

            I have read this article which indicates that there can be only one ASM instance

             

            Thank you for your help.

            • 3. Re: Install other Oracle_home in addition to Oracle_home RAC
              teits

              you are welcome.

               

              1.you can create dataguard without RAC. you can have RAC database instance in node1 and node2. you can also create a standalone DB instance(can be standby DB in data guard) in node2.

              with dbca option(there are other method, but the dbca easiest because of GUI) you can create a database in a single mode of the RAC.

               

              it registered with oracle clusterware. But it can be remove from clusterware registry/configuration. and standalone DB instance will behave as if you do not have clusterware software on the node.

              e.g. srvctl remove database -d testdb

               

              if you are cloning a database e.g. for data guard. the database will not be registered with oracle clusterware.

               

              2. we can only have ONE asm instance per server/node. One ASM is enough to serves all your database instances. remember ASM is oracle way of implementing LVM.

               

              Tobi

              • 4. Re: Install other Oracle_home in addition to Oracle_home RAC
                Antonio

                Thank you for everything, i was very clear.

                 

                In the end, we are going to create MAA, the scenario would be RAC production and in the RAC preproduction put the development instance, another of preproduction and another for the active data guard.

                 

                Another issue we can have in the RAC Site secondary of dataguard other instances that are not in the primary site.

                 

                Thank you very much

                • 5. Re: Install other Oracle_home in addition to Oracle_home RAC
                  teits

                  Antonio wrote:

                  ...

                  Another issue we can have in the RAC Site secondary of dataguard other instances that are not in the primary site.

                   

                  YES.

                  • 6. Re: Install other Oracle_home in addition to Oracle_home RAC
                    Antonio

                    Thank you for everything has been a pleasure.