DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: rconfig

  1. 01-17-2008, 06:07 AM #1
    sunidba
    sunidba is offline Junior Member
    Join Date
    Jan 2008
    Posts
    31

    rconfig

    Hi,

    I am facing problem in Converting single node to RAC. Below are the details of the environment.

    Can some expert clarify my doubts ??
    thx in advance.




    1. Sigle node DB on OCFS2 file system.

    2. RAC 2 nodes setup done. Cluster and RDBMS done (Just installation)

    3. Shared storage with OCFS2 is done.


    My questions.

    1. From which home should i run rconfig ?? source(single node) or Target (RAC node) ?

    2. should the RAC instances be brought to nomount stage before
    running rconfig ?? ie., prepare init.ora etc. ??
    Reply With Quote Reply With Quote
  2. 01-17-2008, 06:35 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    http://download-uk.oracle.com/docs/c...c.htm#BABBAAEH
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 01-17-2008, 07:10 AM #3
    sunidba
    sunidba is offline Junior Member
    Join Date
    Jan 2008
    Posts
    31
    Quote Originally Posted by PAVB
    http://download-uk.oracle.com/docs/c...c.htm#BABBAAEH

    Thx for the link, which i have already looked into.

    I don't think it has got the info what i am looking for.

    Can somebody else help me ??
    Reply With Quote Reply With Quote
  4. 01-17-2008, 11:54 AM #4
    monto1
    monto1 is offline Junior Member
    Join Date
    Dec 2007
    Posts
    55
    If your oracle home are separate then .

    1)Have your spfile,password file on a shared storage and create softlink for password file on both nodes.

    2)put tns entries at both nodes.

    3)create undo tablespace for node 2.

    4)create redo thread for node 2.

    5)make changes to the parameter file or spfile for so that it has parameters for node 2 like undo tablespace ,thread, instance number, instance name ...

    6)change it to cluster_database=true.

    7)have your pfile pointing to spfile on both nodes.

    8)startup 2nd instance.

    9)register 2nd instance with srvctl (10g) .

    Thats it.

    Regards
    Last edited by monto1; 01-17-2008 at 12:06 PM.
    Reply With Quote Reply With Quote
  5. 01-17-2008, 12:41 PM #5
    sunidba
    sunidba is offline Junior Member
    Join Date
    Jan 2008
    Posts
    31
    monto1,

    Thanx for the reply. I guess you are telling about the Manual steps for the conversion;

    but i am looking for the steps using rconfig ( ofcourse manual also serves the purpose; but i want specifically rconfig)
    Reply With Quote Reply With Quote
  6. 01-17-2008, 01:22 PM #6
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi
    1. From which home should i run rconfig ?? source(single node) or Target (RAC node) ?

    Source node (single Node) in your case its mentioned in the docs

    Code:
    create a clone image of the single-instance database, and move the clone image to a host that is one of the nodes of the cluster. Then use rconfig or the Enterprise Manager Convert to RAC option, as described in the preceding scenario
    2. should the RAC instances be brought to nomount stage before
    running rconfig ?? ie., prepare init.ora etc. ??

    Nope

    regards
    Hrishy
    Last edited by hrishy; 01-17-2008 at 01:34 PM.
    Reply With Quote Reply With Quote
  7. 01-17-2008, 10:43 PM #7
    sunidba
    sunidba is offline Junior Member
    Join Date
    Jan 2008
    Posts
    31
    Thx for the reply Hrishy,

    I went thru the doc.

    But when it says, clone the image, should i do full cloning ?? and my source (single instance ) should be up and running ??


    I am not clear what does the doc mean by clone image... ??
    Reply With Quote Reply With Quote
  8. 01-18-2008, 04:35 AM #8
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Clone means duplicate the database using rman.

    Hmm well at certain point of time you do need to shutdown isnt it ? you cannot have transactions going against the old single instance database i beleive no ?

    regards
    Hrishy
    Reply With Quote Reply With Quote
  9. 01-22-2008, 01:03 AM #9
    sunidba
    sunidba is offline Junior Member
    Join Date
    Jan 2008
    Posts
    31
    Hey Hrishy,

    One more question....

    To clone the source one RAC instance, should i use the RAC enabled Oracle_home or should i create a new rac disabled Oracle_Home on the rac node ??

    thanks.
    sunil
    Reply With Quote Reply With Quote
  10. 01-22-2008, 04:27 AM #10
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Well when you have a single instance oracle home then rac would be disabled no ?
    You should use that rconfig will take care of everything

    regards
    Hrishy
    Last edited by hrishy; 01-22-2008 at 05:47 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width