?
Solved

The Oracle Exadata and ODA

Posted on 2013-06-17
17
Medium Priority
?
928 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

752 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