Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

The Oracle Exadata and ODA

Posted on 2013-06-17
17
Medium Priority
?
975 Views
Last Modified: 2013-06-19
Dear all,

  Right now we are going to do the Oracle database consolidation so that we use less server and therefore the operation cost can be lower down.

  We are considering to use Exadata and oracle database applicant, and please advice any pro and cons of both approach.

  Also how can they be managed ?Oralce comparsion
DBA100.
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 8
17 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39255495
Hi,

ODA is for ease of administration: in few hours you have storage+network+cluster+database+RAC installed. You have good performance because you have dedicated hardware. And you can start with few CPU (lower license cost) and activate them later.

Exadata is for performance and scalability: If you already have tuned your workload to use the all available CPU power (with parallel query) and have reached the point where I/O is the bottleneck, the Exadata can remove that bottleneck.

Regards,
Franck.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39255513
"have reached the point where I/O is the bottleneck, the Exadata can remove that bottleneck.
""
why is it ? as the storage is scabable too ?

will it be correct logic that right now we use ODA first and if later on we found the disk I/O is the bottleneck , then we can easily switch to Exadata? doable, right?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39255515
"You have good performance because you have dedicated hardware."

Exadata don't have dedicated hardware?

" And you can start with few CPU (lower license cost) and activate them later."

Exadata can't do it either ?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39255533
Yes of course Exadata has dedicated hardware. But it has also special software to address performance: SmartScan, Storage Index, Hybrid Columnar Compression...

I mean Exadata has features for performance. ODA has good performance onbly because you have dedicated hardware.

Yes, on Exadata, you can start small (with 1/8 of RAC) and increase later. But 1/8 of RAC is still a big machine... nothing like an ODA with 2 CPU activated...
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39255539
"Yes, on Exadata, you can start small (with 1/8 of RAC) and increase later. But 1/8 of RAC is still a big machine... nothing like an ODA with 2 CPU activated... "

you mean the RAC cost for Exadata and ODA is different?

and the RAC for ODA is has ready 2CPU activated per RAC license? and RAC cost for Exadata is very expensive even for 1/8 of RAC ?

"ODA has good performance onbly because you have dedicated hardware.
"
this only mean ODA has no software to address performance: SmartScan, Storage Index, Hybrid Columnar Compression...
 ?

can we buy the software separately for ODA ? or only for Exadata ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39255543
someone also tell me that for inter site, like DR, only data guard can help.

RAC only help for intra server, like the 2 x cluster nodes, right?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39255733
The RAC cost depends on the number of activated CPU. In ODA minimum is 2 In Exadata X3 minimum is 16 (I think - check the 1/8 rack configuration)

Exadata features are available only on Exadata machine (need storage cell)

RAC is high availability in cluster: you can loose one node. But it's not deasaster recovery: if your machine burns you loose all your cluster (both ODA and Exadata have all the servers in the same machine). You can have a dataguard standby on another site. That's just another machine to by ;)
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39255802
ok, we just finsih a meeting on this.

Any refernece you can think of that ODA is good use and what if something wrong in the ODA and we can't find that out ? Which in this case Exadata is better as all server is separted and we can fix it one by one and we can't do it for ODA ?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39256219
I don't understand your question.
>> all server is separted
That's the case for both: servers are separated but put in the same box. The box is just a bit more compact for ODA. Exadata 1/8 rack has a lot of free space ;)

>> Any refernece you can think of that ODA is good use
If you want an Oracle RAC cluster that is not too hard to configure, the ODA is good.
Even if Exadata is an applicance, don't expect to set it up in few hours.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39258369
">> all server is separted
That's the case for both: servers are separated but put in the same box. The box is just a bit more compact for ODA. Exadata 1/8 rack has a lot of free space ;)"

yeah, the ODA just 4 U from what we understand.
\

"If you want an Oracle RAC cluster that is not too hard to configure, the ODA is good.
Even if Exadata is an applicance, don't expect to set it up in few hours. "

what I mean is, for example, are you using ODA at this moment?  any incident that the ODA fail before and how it fail ? how to recover that?

we just didn't see ODA's perfomance at all and not sure if ODA is good to use and scalarble !

can RAC connect 2 x ODAs ?each ODA has only 2 x server, right?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39258597
>> each ODA has only 2 x server, right?
Right
>> can RAC connect 2 x ODAs ?
No. Each has its own storage, cannot be shared.
>> any incident that the ODA fail before and how it fail ? how to recover that?
Same as any database: either restore a backup or failover to a standby
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39258628
"Same as any database: either restore a backup or failover to a standby "

then we relies on RAC or Data Guard, right?


">> can RAC connect 2 x ODAs ?
No. Each has its own storage, cannot be shared."

no. I mean is 2 x the ODA nodes share a storage, the RAC will DR and load balance the 2 x nodes, right?

I would like to know if 2 x ODA can use RAC to load balance and DR ?
0
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 2000 total points
ID: 39258687
One ODA has 2 servers in RAC that share their storage: load balancong among those 2 nodes and high availability if one node is down.

Another ODA cannot share the first one, but can be a standby for the first one.

You can load balance (RAC) within an ODA, not across several ODA.

You can DR (DataGuard) across several ODA.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39258814
"Another ODA cannot share the first one, but can be a standby for the first one."

how ? using RAC or data guard?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39258844
RAC: load balancing + high availability in case of server failure
-> is in the same ODA box


DataGuard: Deasaster Recovery (in case of server+disk failure)
-> is across several ODA box
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39258914
"
DataGuard: Deasaster Recovery (in case of server+disk failure)
-> is across several ODA box "

we have dataguard for the DR server that is not readable in normal operation, active data guard is readable only in normal operation, what else?

"RAC: load balancing + high availability in case of server failure
-> is in the same ODA box"

so the RAC is installed on both nodes of server in the same ODA and RAC can't across that boundary anyway.
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39259241
Yes, right.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question