• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

The Oracle Exadata and ODA

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
marrowyung
Asked:
marrowyung
  • 9
  • 8
1 Solution
 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
"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
 
marrowyungAuthor Commented:
"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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
"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
 
marrowyungAuthor Commented:
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
 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
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
 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
">> 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
 
Franck PachotCommented:
>> 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
 
marrowyungAuthor Commented:
"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
 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
"Another ODA cannot share the first one, but can be a standby for the first one."

how ? using RAC or data guard?
0
 
Franck PachotCommented:
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
 
marrowyungAuthor Commented:
"
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
 
Franck PachotCommented:
Yes, right.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 9
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now