This discussion is archived
5 Replies Latest reply: Feb 26, 2013 6:34 AM by ShishirTekadeR RSS

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

823085 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

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