EBS on Exadata

Hi Everyone,

Wish you all very happy and prosperous new Year 2012.

I am hoping to write few articles with respect to EBS 11i running on Exadata machine as I am currently on it.


History on Exadata:

In 2008 Oracle released HP Oracle Database Machine and Exadata
Storage Servers especially for data warehousing

In 2009 Oracle released Sun Oracle Database Machine (Exadata
Version 2) for OLTP/DW/Mixed loads

In 2010 Oracle released Oracle Exadata X2-2,X2-8,Exalogic with OEL, Solaris 11 express

Exadata runs SQL faster due to the fact that it does some processing at Storage level and reduces the work at DB level.

For example, In typical database when SQL statements are given from clients

1. syntax/symatic checks performed and execution plan is derived
2. DB request the blocks from DBF's from storage. Even if a query requires only one row, one column - entire block will be brought to SGA
3. DB discards unwanted rows and only gives the rows required to client

Exadata combines 2 and 3, most of the times and sends ONLY rows/columns directly to PGA.

We have done recently migrated 11i EBS multi node HA environment to Exadata X2-2 Quarter Rack. We have seen huge performance gain on concurrent programs, some programs which ran for days completed in hours. Backups which ran for hours came down to minutes.

EBS needs to be at 11.5.10.2 or R12.0.4 or R12.1 to run on Exadata X2-2 machine. Minimum database version required is 11gR2.

We had Solaris source database and we have migrated to Linux. We have configured huge pages.

EBS on Exadata more details can be found at

http://www.oracle.com/technetwork/database/features/availability/maa-ebs-exadata-197298.pdf

Migration steps can be found at

http://www.oracle.com/technetwork/database/features/availability/maa-ebs-exadata-xtts-321616.pdf

http://www.oracle.com/technetwork/database/features/availability/maa-ebs-dbm-datapump-167285.pdf

I will write more on the specifics on the storage cells/monitoring/configuration/steps as time permits.

Once again, wish you all very Happy New Year 2012.

10 comments:

PraveenKumar said...

Hi Suresh,

I am really impressed to see your blog.I have arourd 2 years of experience as oracle apps dba.Please do respond for the queries which I post.It will be a great help for me.Once again thanks a lot.Please accept the invitation.

Thanks & Regards,
PraveenKumar

Anonymous said...

Thanks for so many articles.

A quick question, if the EBS is running on a different platform with Exadata, can it be migtate to Exadata? example, everything(apps/db tiers) are running on Solaris, can you only move the database to exadata and leave the apps tier in Solaris?

Suresh Lakshmanan said...

Yes, you will be able to. it will be EBS split configuration. That would reduce the cutover downtime window.!

Suresh

Anonymous said...

Hi Suresh,

Thank you for your artciles.

One question, should I use the same method to migrate my EBS database 11i to Oracle Database Appliance ?

Thank you for your answer

Anonymous said...

Hi Suresh,

Thank you for your artciles.

One question, should I use the same method to migrate my EBS database 11i to Oracle Database Appliance ?

Thank you for your answer

Suresh Lakshmanan said...

Yes, it is same method. It would look yet another linux system.

Suresh

Anonymous said...

Thank you very much Suresh

Anonymous said...

Hi Suresh,

thanks for the knowledge sharing and ur blog is a treasure for oracle dba's we could ever find.

can you please put some thought and guide me ..

currently we have R12.1 & 10g database instance running on sun solaris 10 , we want to migrate both to linux platform in order to build a RAC system.

can you please send or guide me the solaris to linux database and apps migration steps.

i can be reached at sandumech@gmail.com

thanks and appreciate all the hard work ..

Suresh Lakshmanan said...

Hi ,

Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]

Export/import process for R12 using 11gR1 or 11gR2 [ID 741818.1]

Suresh

hammad farooq said...

Thankz For the Knowledge sharing ....