Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: RAC Interview Questions

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    RAC Interview Questions

    1) Explain any issue you got related to RAC, and how did you resolved it ?
    2) What are the init.ora parameter specific to only RAC environment ?
    3) How to upgrade existing oracle 10g single instance database to Oracle 11g R2 RAC. Give a rough idea for each step ?
    4) What error and issues you faced while installing the Oracle 11gR2 RAC ?
    5) What issues you got while upgrading the oracle 10g database to oracle 11gR2 RAC ?
    6) What is cache fusion ?
    7) Explain cache fusion by a example ? Why and How the blocks are transfer from one node to another node ?
    8) How to clone a 3 node RAC database to a another 3 node RAC environment ?
    9) What kind of administrative task you perform in RAC environment ?
    10) What are the different protection mode in data guard ?
    11) Suppose our data guard is in "Maximum Protection" mode. The redo data, related to a transaction, have been written to local online log files, but due to some network problem it cannot be written to standby site. What will happen in this scenario ?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    How to upgrade existing oracle 10g single instance database to Oracle 11g R2 RAC. Give a rough idea for each step ?

    This article explains step by step RAC upgrade procedure to upgrade Oracle 10gR2 (10.2.0.4) Real Application Cluster(RAC) to Oracle 11gR2 (11.2.0.2) RAC. This procedure cannot be used for a fresh RAC installation. The following are important notes:
    Backup the database
    Check the current OCR and voting locations
    Backup the OCR file
    Backup the voting disk
    Fix the OS level prequisites
    Run cluvfy script from the grid directory and address all the problems
    CRS+ASM has to be upgraded first, followed by the database upgrade
    Oracle 11gR2 RAC has brought in a some good changes. Oracle 10g CRS and ASM homes are no more. Both CRS and ASM are installed in to the same home, GRID Infrastructure home. SCAN is introduced.
    In 11g, OCR and Voting disks can be stored in ASM Disk group
    RAW Devices for OCR and Voting disk are still supported on upgraded RAC environments. This is not an option during a fresh install.
    New user for CRS and ASM administration is introduced. ie. grid user. This is more of a role management for storage guys. It has to be the same OS user in Oracle 10g.
    However, since this is an upgrade, I had to retain the same user for grid. Of course, during fresh installation, you can still run both Grid and Oracle database with the same user.. but oracle recommends a separate user for grid.
    Grid home should not be under grid base
    Oracle database home should be under Oracle base.
    11gR2 introduced a multicasting mechanism for cluster communications. Verify if your network supports multicast before the upgrade: Refer to Oracle Note: 1212703.1
    Starting with 11gR2, we don’t have to install base release and apply patch sets. For example: In Oracle 10g, we have to install 10.2.0 and then apply 10.2.0.4 patch set on top of 10.2.0. But now, we can directly install 11.2.0.2 from the media. This may not be found in OTN, check for the patch: 10098816 in My Oracle Support.
    You can opt to run ASMCA after grid installation.. I did not opt for it, because that's mainly for rolling upgrade. There is no rolling upgrade from 10.2.0.4, so I don't see any benefit to run ASMCA manually after the grid installation.
    Make sure your database version is okay to go to 11gR2:
    Direct upgrade to Oracle Database 11gR2 is supported from 9.2.0.8+, 10.1.0.5+, 10.2.0.2+, and 11.1.0.6+
    9.0.1.3 (or earlier) -> 9.0.1.4 -> 10.2.0.4 -> 11.2
    9.2.0.3 (or earlier) -> 9.2.0.8 -> 11.2

+ Reply to Thread

Similar Threads

  1. Oracle apps dba interview questions
    By mdmasood in forum Oracle Applications Interview Questions
    Replies: 9
    Last Post: 06-13-2013, 01:11 PM
  2. Oracle DBA Interview Questions
    By Hemant in forum Oracle Database Interview Questions
    Replies: 1
    Last Post: 06-06-2012, 04:01 PM
  3. More RAC and 11g Database Interview Questions
    By Hemant in forum RAC Interview Questions
    Replies: 0
    Last Post: 04-20-2012, 10:49 AM
  4. Oracle Interview Questions (Contains DBA and Developer Questions)
    By Pradeep in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-29-2012, 05:13 AM
  5. Here are some possible Oracle DBA Interview Questions:
    By Akhil Kumar in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-12-2012, 04:47 PM

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics