Solved

The Oracle Exadata and ODA

Posted on 2013-06-17
17
764 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
  • 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 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 how to recover a database from a user managed backup

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now