This discussion is archived
4 Replies Latest reply: Feb 12, 2012 2:30 AM by Hussein Sawwan-Oracle RSS

Using Oracle 11g Release 2 Real Application Clusters with R12.1.1

764772 Newbie
Currently Being Moderated
Hi All,

I am installing two node RAC 11gR2 with EBS R12.1.1.As part of installation I performed below tasks using metalink doc "Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 [ID 823587.1]"

1)Installed single node EBSR12.1.1 and applied pre-req patches as per ID 823587.1
2)Upgraded EBS database from 11gR1(11.1.0.6) to 11gR2(11.2.0.2)
3)Install Oracle Clusterware 11g Release 2(11.2.0.2)
4)Install Oracle Database Software 11g Release 2 on both nodes (only software installation with RAC option on both nodes, not database upgrade using this home bcz i have already done database upgrade in step 2)

But as per metalink [ID 823587.1] says "Upgrade Applications Database to 11g Release 2 ".Please help me what else I need to do as part of step 4.Do I need to perform upgrade once again or skip the upgrade step.

Regards
M Latif
  • 1. Re: Using Oracle 11g Release 2 Real Application Clusters with R12.1.1
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    You can skip this step (since you have already upgraded to 11gR2) and continue

    HTH
    Srini
  • 2. Re: Using Oracle 11g Release 2 Real Application Clusters with R12.1.1
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    1)Installed single node EBSR12.1.1 and applied pre-req patches as per ID 823587.1
    2)Upgraded EBS database from 11gR1(11.1.0.6) to 11gR2(11.2.0.2)
    3)Install Oracle Clusterware 11g Release 2(11.2.0.2)
    4)Install Oracle Database Software 11g Release 2 on both nodes (only software installation with RAC option on both nodes, not database upgrade using this home bcz i have already done database upgrade in step 2)
    Why did you install Database software 11gR2 in Step 4 if you have already upgraded the database to 11.2.0.2 in Step 2? How many 11gR2 ORACLE_HOME you have installed?
    But as per metalink [ID 823587.1] says "Upgrade Applications Database to 11g Release 2 ".Please help me what else I need to do as part of step 4.Do I need to perform upgrade once again or skip the upgrade step.
    I do not understand why you had to lay down the 11gR2 software again if you have already done so as part of the 11gR1 to 11gR2 upgrade.

    Thanks,
    Hussein
  • 3. Re: Using Oracle 11g Release 2 Real Application Clusters with R12.1.1
    764772 Newbie
    Currently Being Moderated
    Hi Hussein,

    Thanks for reply.

    1.Why did you install Database software 11gR2 in Step 4 if you have already upgraded the database to 11.2.0.2 in Step 2? How many 11gR2 ORACLE_HOME you have installed?

    Ans:As per metalink [ID 823587.1], run the Oracle Universal Installer (runInstaller) to carry out an Oracle Database Installation with Oracle RAC. In the Cluster Nodes Window, verify the cluster nodes shown for the installation. Select all nodes included in your Oracle RAC cluster.I have three ORACLE_HOME installed as part of RAC Installation
    1) Grid Infrastructure Home
    2)11gR2 ORACLE_HOME(old) for single node EBSR12.1.1
    3)11gR2 ORACLE_HOME installed on two nodes installed with RAC option

    2)I do not understand why you had to lay down the 11gR2 software again if you have already done so as part of the 11gR1 to 11gR2 upgrade.

    Ans:The ORACLE_HOME that already I have upgraded to 11gR2 is part of single node installation not RAC.Please let me know can I just copy these binaries to second node instead of step 4 ?

    Regards.
    M Latif
  • 4. Re: Using Oracle 11g Release 2 Real Application Clusters with R12.1.1
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I have three ORACLE_HOME installed as part of RAC Installation
    1) Grid Infrastructure Home
    2)11gR2 ORACLE_HOME(old) for single node EBSR12.1.1
    3)11gR2 ORACLE_HOME installed on two nodes installed with RAC option
    You do not need the old ORACLE_HOME and you just need two ORACLE_HOMEs (Grid + ORACLE_HOME with RAC option).
    Ans:The ORACLE_HOME that already I have upgraded to 11gR2 is part of single node installation not RAC.Please let me know can I just copy these binaries to second node instead of step 4 ?
    Yes, or I would say configure ORACLE_HOME which you installed in step 4 with your database by configuring the context/env files and recreate the appsutil directory.

    Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 [ID 387859.1]
    Troubleshooting Autoconfig issues with Oracle Applications RAC Databases [ID 756050.1]
    How To Recreate the /appsutil/scripts/ directory [ID 377495.1]

    Thanks,
    Hussein

Legend

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