Using RAC and ASM with E-Business Suite Databases

A unique Oracle database feature is Real Application Clusters (RAC).  RAC allows multiple database servers to work on the same database simultaneously, improving scalability and fault tolerance.  


Another interesting Oracle database feature is Automatic Storage Management (ASM).  ASM allows you to specify a disk group of storage devices rather than the traditional datafile when creating or modifying a database structure such as a tablespace. ASM creates and manages the datafiles across all the disk group automatically.

Both of these features have the potential to drop your operating costs:  RAC allows you to use a cluster of inexpensive servers instead of a single massive SMP box, and ASM allows you to use a cluster of inexpensive disks instead of a single massive disk array.

RAC & ASM for E-Business Suite Users

Here's where things get interesting for E-Business Suite users:  E-Business Suite Release 11i is certified with 9i RAC, 10gR1 RAC & ASM and 10gR2 RAC & ASM.

11i RAC Architecture:

As an aside, we use 10gR1 RAC with our own E-Business Suite Release 11i instance for Oracle's corporate Global Single Instance.  We're planning an upgrade to 10gR2 in the near future.

Initially Awkward with 10gR1

This is all good, but our first version of the E-Business Suite certification with 10gR1 RAC and ASM had an awkward restriction.  To use this combination, you first had to migrate your E-Business Suite environment to RAC.  After that was done, you could then migrate your RAC environment to ASM.

There were very good technical reasons for doing things this way, but no matter.  This proved to be really problematic for customers who decided to take advantage of ASM long before they even considered switching to RAC. 


Awkward No Longer

We have a small but brilliant team working in this area and they have managed to lift that restriction for E-Business Suite users.  With the latest version of the 10gR1 RAC & ASM Installation Guide, you can now do this in any order you'd like:  RAC then ASM, or ASM then RAC.

This restriction doesn't exist with our 10gR2 certification, so DBAs who waited for that certification can use RAC and ASM in any order today.

Comments:

Hi,
Good article. Please let me know where is the document about administration of EBiz+RAC? I need cloning docs for this EBiz+RAC...
Thanks.
Frado Sibarani
Singapore

Posted by Frado Sibarani on August 19, 2008 at 01:08 PM PDT #

Frado,

Feel free to click on any of the links in the article: they link directly to the RAC documentation for a given configuration. For example, the 10gR2 RAC & ASM link points to:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=362135.1

Regards,
Steven

Posted by Steven Chan on August 25, 2008 at 02:45 AM PDT #

Hi

Do we require additional license for RAC database on Oracle HRMS Applications.

Thanks.

Souhail

Posted by Souhail Assaad on September 09, 2008 at 05:53 AM PDT #

Hi, Souhail,

Yes, any use of RAC in an EBS environment requires additional licencing for RAC.

Regards,
Steven

Posted by Steven Chan on September 10, 2008 at 01:19 AM PDT #

Schan,

I am doing this configuration, and to our disapointment when we got to the last part (Configure PCP), there are itens that require a shared filesystem.

What is the point of supporting ASM if I still need a shared filesystem for the concurrent to work? I dont like the idea of pointing the areas to a NFS share on one of the servers since this will create a single point of failure, and since we are using ASM, we didnt forsee the need for a NAS device or a Cluster File System.

Is there any way around this?

Regards,
Luis

Posted by Luis Freitas on November 11, 2008 at 10:19 PM PST #

Hi, Luis,

Looking into this now; I'l post an update here as soon as possible.

Regards,
Steven

Posted by Steven Chan on November 13, 2008 at 08:09 AM PST #

Hi, Luis,

Our team has confirmed that the CP processes need access to the directories for temp/log files. There's no way to circumvent this requirement in Release 11i, I'm afraid.

I hope the remainder of your RAC implementation goes smoothly.

Regards,
Steven

Posted by Steven Chan on November 14, 2008 at 02:09 AM PST #

Hi Steve,

We are implementing RAC with E-Business suite.Now, we are stuck up with Oracle clusterware installation.When we run cluvfy utility It's was not able to regnoise the raw devices for OCR and VD. Please can you provide us a document, which has a clear picture of configuring raw devices for Oracle clusterware on sun solaris 10(sparc).

Looking forward for your reply.

Thanks & Regards,
Janakiram

Posted by janakiram on June 17, 2009 at 07:08 PM PDT #

Hi, Janakiram,

Glad to hear that you're implementing RAC, but I'm sorry to hear that you've encountered an issue.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on June 18, 2009 at 06:29 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today