Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 

 

Status of Oracle RAC/SAP Certification

Oracle RAC Cluster Tips by Burleson Consulting

This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters.  To get immediate access to the code depot of working RAC scripts, buy it directly from the publisher and save more than 30%.


Oracle and SAP have conducted many certification tests on selected platforms. Tests have shown a viable combination of RAC with the SAP system. One such test was done using the SAP R/3 4.6D and Oracle 9i RAC on a HP Tru64 UNIX Cluster. Many customers have implemented SAP with an Oracle RAC database. Readers are urged to check with the SAP vendor for the current status.

Also see the website for certification status:

http://www.oracle.com/features/ow/index.html?0626_ow_saprac.html

SAP's MCOD

mySAP architecture requires more and more databases for the different modules. At the same time, the SAP modules in a mySAP.com environment are not independent, e.g. SAP SD, SAP CRM, and BW interact and share data. To guarantee the required consistency within all these databases, SAP has developed a new method or strategy of Multiple Components in One Database (MCOD).  MCOD is a new feature in the installation process for mySAP.com components. It provides the capability of installing several components independently into one single database.

As shown in Figure 11.2, the data needs are consolidated into one large database system, aided by the RAC system.

Figure 11.2: mySAP , MCOD and Oracle RAC Database

With Oracle 10g RAC, nodes can be optimally customized for dedicated workloads such as CRM, HR, SD, and retail. By utilizing different database instances for these functional modules and batch-centric modules, they can be fine tuned without affecting each other.

By having a single database, administrative flexibility and cost savings are achievable. Running all the related SAP modules in only one database guarantees the consistency and availability of current data. However, as all the eggs are kept in one basket, it becomes much more important to protect the MCOD database for high availability and also to provide acceptable levels of performance. The Oracle RAC database system meets these challenges very well.

Performance Considerations

Some database systems require different parameterization, depending on the transactional behavior of the application. For these database systems, a separate installation of OLTP and OLAP systems is necessary. With the implementation of RAC-based multiple instances, a specific instance can be assigned to a specific SAP module, and it can have its own set of parameters or customization.

Siebel and RAC

The Siebel eBusiness application suite is another important packaged application supporting business operations. Siebel eBusiness application suite provides an integrated set of solutions for sales, marketing, customer service, and partner organization.

Siebel suite is developed on multi-tier models with application clients, application servers, and backend database layers. As shown in Figure 11.3, the client interacts with the middle tier and the middle tier accesses the database. The business logic is in the middle tier, also known as the Siebel application server. The business logic is encapsulated in one or more server components. These server components provide services to both the interactive and the batch operations. Typically, the following components make up the middle tier: the object manager, assignment manager, enterprise integration manager (EIM), and WorkFlow, etc.

Figure 11.3: Siebel Architecture

The Oracle database has been an important backend database choice for many Siebel customers. With a heavy reliance on the database system by Siebel servers, any malfunction in the database layer cripples the entire application framework. Any database component can become a single point failure for the whole Siebel suite. Therefore, a clustered database such as a RAC database, provides true high availability and scalability. When one of the nodes fails along with the database instance, the other surviving instances can still provide the database resources.

Siebel can also leverage the RAC database?s ability to provide scalability. As the number of users increases, Siebel Servers can be added to support and maintain performance levels. At the same time, database access increases. The Oracle database server can provide the same type of growth. As the need arises, additional nodes can be added to support the extra workloads.

Another important feature of RAC is the ability to use a selective database instance for a specific group of application servers. This allows the more critical application needs to be prioritized and a specific database instance to be assigned to avoid conflicts and contention.

At the time of writing, tests are being conducted to certify the Siebel backend database with the Oracle RAC system. The reader is urged to consult with Siebel to enquire about the certification status.

 


This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters, Rampant TechPress, by Mike Ault and Madhu Tumma.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

http://www.rampant-books.com/book_2004_1_10g_grid.htm


 

 
��  
 
 
 
 

 
 
 

 
 
Oracle performance tuning software 
 
oracle dba poster
Oracle Linux poster
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright ? 1996 -  2014

All rights reserved by Burleson

Oracle ? is the registered trademark of Oracle Corporation.