Single instance database to RAC

          

Interview questions

Explain how to convert a single instance database to RAC


<<Previous   Next>>
Oracle - Explain how to convert a single instance database to RAC posted by Babu Kunwar

Explain how to convert a single instance database to RAC

There are multiple ways in Oracle 10gR2 to convert a single instance database into a clustered database. We can use the following methods to do this:

  • Dbca
  • enterprise manager
  • rconfig utility

Check if operating system requirements are met you can choose either of these methods to do the conversion. Also the hardware and software system is supported. DBCA does most of the tasks of the conversion automatically whereas grid control provides full support to the conversion process.

Rconfig is a utility which is located in $ORACLE_HOME/bin.

It uses a file called $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC.xml which we need to edit in order to adjust some parameters as needed and then save it under a new name. It contains the parameter for verifying convert options which accepts three different values for example to understand:

  • CONVERT VERIFY= “YES”. If yes it performs checks to make sure everything is in place before starting the conversion.
  • CONVERT VERIFY= “NO”. If NO it starts conversion right away without checking the prerequisits.
  • CONVERT VERIFY= “ONLY”. If equals to ONLY then it only performs the prerequisits-check.

You then call the utility and hand over your modified xml file: $ rconfig my_db_conversion_file.xml.



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring