>
Oracle, Technical

E-Business Suite Applications 11i on RAC/ASM

I recently mentioned working with a client to convert their E-Business Suite environment to RAC and ASM. I enjoyed this project; there are a few good high-level guides to the process but there are still a lot of small hiccups and configuration decisions where I could put my RAC experience to work.

11i_conversion_process.gifThe main guide that we used for this conversion process was metalink note 362135.1. However there were a few divergences; the two main ones were that (1) the client had already upgraded their source database to 10g and (2) the metalink note was updated with a few new steps in the middle of our project but we chose to stick with the original document that we’d started with. The flowchart to the left gives a pretty good summary of our conversion process (click on it to see a larger image).

RConfig simplified the actual conversion to RAC and ASM but there were quite a few additional steps that we had to perform manually before and after RConfig. Here’s a breakdown of the database-related steps:

Install, patch, and configure RAC software (Flowchart Step 3)

  1. Install Clusterware and Patchset

    FYI, although this client chose to use version 10.2.0.2 you can in fact use 10.2.0.3 with E-Business Suite Applications. Have a look at note 362203.1 for more info.

  2. Install ASM Software and Patchset and Configure ASM Diskgroups

    Remember that you may need multiple disk groups in ASM. Think of an ASM disk group as the same thing as a filesystem mount point. If you were spreading your files over 4 mount points then four disk groups would give you an equivalent configuration based on ASM.

  3. Install DB Software and Patchset

    We chose to install a new ORACLE_HOME for the database software. It is also possible to skip this step and use your existing ORACLE_HOME (although you will then need to clone this home to all cluster nodes).

    After installing this home you must apply all patches that were applied to the source ORACLE_HOME… this is one disadvantage of this approach.

  4. Fix 10.2.0.2 Patchset Bug (libknlopt.a)

    Naturally this only applies to the 10.2.0.2 patchset. This is known bug 5128575 and you can find a detailed description and workaround in note 5128575.8.

  5. Fix Listener ONS Notification Config Bug

    The installation of Oracle clusterware onto the same machine as a cloned instance of Oracle Apps triggered a rather nasty networking bug. I put together a few detailed blogs about this when we were working on it; have a look at them for more info.

Database conversion with RConfig (Flowchart Step 4)

This part was pretty straightforward. We updated the oratab first just for convenience then used RConfig to convert the database to RAC and ASM. After the conversion there were three additional steps: (1) deleting the listener that RConfig made, (2) updating the racgwrap script for Oracle Apps, and (3) setting up AutoConfig on the ORACLE_HOME. The third step also created the context and configuration files for E-Business Suite.

Database tier configuration (Flowchart Step 5)

The post-config was a bit involved and I’m not going to detail every step we took but here’s the overview:

  1. Update oraenv Script
  2. Symlink Apps Environment Script
  3. Make All Redo Threads Public
  4. Enable Block Change Tracking
  5. Make Multiple Controlfiles
  6. Update Initialization Parameters and Switch to SPFile
  7. Configure Shared SPFile and PWFile
  8. Fix DBConsole Installation Script Bug
  9. Configure DBConsole (OEM)
  10. Update LISTENER.ORA

The most complicated step was making multiple control files. RConfig only made a single controlfile by default (because DB_CREATE_FILE_DEST was set but there was no flash recovery area). And unfortunately you can’t just copy files in and out of ASM – so we had to use RMAN to make the copies. Took a few more steps than I’m used to!

That being said the project was certainly a success. We got the environment converted and documented in record time – although it did take me awhile after that to get the “pretty” docs finalized. (I hate writing sometimes. Blog posts are easy… but long docs can be torture to finish… ugh!)

About these ads

About Jeremy

Doing stuff with Oracle Database, Performance, Clusters, Linux. about.me/jeremy_schneider

Discussion

7 thoughts on “E-Business Suite Applications 11i on RAC/ASM

  1. I’m in a similar situation -on 11.5.10.2/10.2.0.2 single instance.Need to migrate to RAC.
    installed clusterware and 10gr2 software into new homes.All fine and good.
    But I’m confused about Database conversion with RConfig (Flowchart Step 4)
    Where do I run the Rconfig?.The exiting single instance home or from the newly installed database home?.

    Posted by Austin Baffo | September 6, 2007, 5:22 pm
  2. Hello Austin,
    I think it should be done from the sources system,
    Regs,
    Mo

    Posted by Mashour | October 27, 2008, 5:11 am
  3. We are in the same process right now except that our DB is 10.2.0.4 RAC on 2 nodes running RHEL 5.1

    I have seperate OH for ASM and DB

    I see a listener running from Oracle home but my netca on DB home is failing saying LISTENER name already exists.

    If i use another name, it brings it up on node 2 but not node 1

    Should i run the listener from ASM home or DB home?
    How do i get around this?

    I am using the same note 362135.1

    Posted by Ash | November 4, 2008, 1:54 pm
  4. I think that Alex Gorbachev has a good rule: “if there is one listener per database – run it from DB home (ASM listener from ASM home). One listener for the node – run it from ASM home.” I said something similar too in a really old post about listener best practices, although I think some of my other pointers in that post are out of date.

    Posted by Jeremy | November 5, 2008, 10:31 am
  5. Hi Austin,
    I was also on the same situation E-business(11.5.10.2)implementation with Oracle Business Accelerator on Redhat 4.6.
    Our architecture is 2 nodes apps(with jetNexus SSL Load Balancer) and 2 nodes RAC (10.2.0.4).

    I cloned the BASELINE instance to create the Production Instance using normal cloning procedure.
    The database was cloned on one of the RAC node on ext3 filesystem (I had space) and migrated to ASM using RMAN.

    The listener being used on all nodes is the one that comes with the DB home (and created by autoconfig) and NOT the ASM.
    The ASM listeners is disabled and de-registered from the CRS.
    The ASM instances auto register with the DB home naturally.

    Give me shout if you still have problems.

    Regis

    Posted by Regis Biassala | January 3, 2009, 4:14 pm
  6. Hi Regis,
    I am planning an Oracle E-Business Suite 12 project on Sun Solaris Machines, with 2 nodes DB RAC ASM and 2 nodes APP, I found you are using Jet nexus load Balancers, how was your experience with these load balancers?

    Posted by Diaa | May 26, 2010, 5:23 am

Trackbacks/Pingbacks

  1. Pingback: Migrating to RAC/ASM with RConfig : Ardent Performance Computing - April 19, 2007

Disclaimer

(a) This is my personal blog.

The views expressed on this website are mine alone and do not necessarily reflect the views of my employer.

racattack-iconOakTableLogo-small

about.me

Jeremy Schneider
Follow

Get every new post delivered to your Inbox.

Join 925 other followers

%d bloggers like this: