5 Replies Latest reply: Feb 26, 2013 8:34 AM by ShishirTekadeR RSS

    How expand an existing database in a cluster to an existing cluster node?

    823085
      Hi Guys,

      I was installing a RAC yesterday and below is my installation steps path, please help me to move forward.

      I have 2 Redhat5 servers: Node1 and Node2. I installed Clusterware and ASM on both nodes, so the system looks like this:

      Node1: Clusterware, +ASM1
      Node2: Clusterware, +ASM2

      Because I found some hardware issue with "Node2" so I shut it down for maintenance. Because of the tight schedule, I started RAC database installation on "Node1" only. So now the system looks like this:

      Node1: Clusterware, +ASM1, ORCL
      Node2: Clusterware, +ASM2

      * "ORCL" is the DB_NAME installed

      Now, the "Node2" is back online and I would like to expand my ORCL instance to the "Node2". I am a bit confused of what to do next, should I use addNode.sh? Or run Oracle database installer on Node2 then use addNode.sh?

      Thanks
        • 1. Re: How expand an existing database in a cluster to an existing cluster node?
          asahide
          Hi,

          I think You can add with addNode.sh, but first check documents..
          Maybe follow links help you.
          <<http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle11gRAC/CLUSTER_22.shtml>>

          Regards,
          • 2. Re: How expand an existing database in a cluster to an existing cluster node?
            823085
            Hi asahideO,

            Thanks for help. The document is not quit what I wanted but it is surely helpful in my RAC installation.

            The correct answer is actually in the official documentation: RAC Admin & deployment guide, Chapter 9 - Using Cloning to Extend Oracle RAC to Nodes in the Same Cluster
            • 3. Re: How expand an existing database in a cluster to an existing cluster node?
              Satishbabu Gunukula
              You can follow the steps in

              Convert Single Instance to RAC – Part2: Manually Convert to RAC
              http://www.oracleracexpert.com/2012/11/convert-single-instance-to-rac-part2.html

              Hope this helps,

              Regards,
              http://www.oracleracexpert.com
              How to Change Oracle DBNAME and DBID
              http://www.oracleracexpert.com/2013/02/how-to-change-oracle-dbname-and-dbid.html
              Error while loading shared libraries: libdb.so.2 - After Migrating REHL4 to REHL5
              http://www.oracleracexpert.com/2013/01/error-while-loading-shared-libraries.html
              • 4. Re: How expand an existing database in a cluster to an existing cluster node?
                986120
                Hi Eric,

                Configure passwordless SSH setup between two node for 'oracle' user.

                Run the following as oracle user from Node1:
                $ cd $ORACLE_HOME/bin
                $ ./addNode.sh –silent “CLUSTER_NEW_NODES={node2}" “CLUSTER_NEW_VIRTUAL_HOSTNAMES={node2-vip}”

                After this,
                *$ dbca*
                --Select *Oracle Real Application Clusters Database* and then select *Instance Management*.
                --Select *add instance* and then click on Next.
                --Follow the steps and finish dbca wizard.

                --
                Bala:)
                • 5. Re: How expand an existing database in a cluster to an existing cluster node?
                  ShishirTekadeR
                  1) [grid@server1 ~]$ cluvfy comp peer -n server2 -refnode server1 -r 11gR2
                  2) [grid@server1 ~]$ cluvfy stage -pre nodeadd -n server2 -fixup -verbose
                  3) [grid@server1 ~]$ /u01/app/11.2.0/grid/oui/bin/addNode.sh -silent CLUSTER_NEW_NODES={server2} CLUSTER_NEW_VIRTUAL_HOSTNAMES={server2-vip}
                  4) [grid@server2 ~]$ cluvfy stage -post nodeadd -n server2
                  [oracle@server2 ~]$ cluvfy stage -pre dbinst -n server2 -r 11gR2
                  5) [oracle@server1 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/oui/bin/addNode.sh -silent CLUSTER_NEW_NODES={server2}
                  6) cd $ORACLE_HOME/bin
                  chgrp asmadmin oracle
                  chmod 6751 oracle
                  ls -l oracle
                  7) [oracle@server1 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca -silent -addInstance -nodeList server2 -gdbName ORCL -instanceName ORCL2 -sysDBAUserName sys -sysDBAPassword oracl

                  *****************************************
                  Best Regards,
                  Shishir Tekade.
                  My Blog: http://shishirtekade.blogspot.com