Exadata

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
If source platform is Exadata, target should be Exadata ?
If use other x86 server for the target system,
then could not apply the patch to target system?
Photo of HJ

HJ

  • 540 Points 500 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Photo of Michael Brown

Michael Brown

  • 1,540 Points 1k badge 2x thumb
Heungjae,

Exadata can be considered just a large x86 Linux system. A standalone or virtual x86 Linux system is equivalent for Oracle purposes, so you should be able to provision from Exadata source to any x86 Linux target. I'm not sure what patch you refer to, though. If you could give us some detail about that question, we could provide a complete answer.

Michael
Photo of HJ

HJ

  • 540 Points 500 badge 2x thumb
Thanks for your reply.
I could provision VDB on x86 system from Exadata, then could I also apply the exadata's patch to VDB on x86 system for A/B testing ? 
Photo of Michael Brown

Michael Brown

  • 1,540 Points 1k badge 2x thumb
To answer that question, we would need to know exactly which patch you are referring to. In general, Oracle patch questions should be directed to Oracle, but we'll be happy to check for you.
Photo of HJ

HJ

  • 540 Points 500 badge 2x thumb
Ok, I see. Thanks.
A key feature of EXADATA is Hybrid Columnar Compression (HCC).
Provisioning from Exadata source to a not-EXADATA x86 Linux target. Is the VDB able to handle HCC compressed data? How is it possible ?
Photo of HJ

HJ

  • 540 Points 500 badge 2x thumb
Some SAP bundle patch for Exadata (SBP name SXD_112035_201304) needed to be installed with Exadata bundle patch 14. In this case, could not apply the patch to x86 server.
Photo of Michael Brown

Michael Brown

  • 1,540 Points 1k badge 2x thumb
Regarding HCC, there is an Oracle requirement that HCC data reside on Oracle-branded storage. The Oracle processes actually check what storage hardware the data resides on and will not service HCC data if not on Oracle storage, and the Delphix Engine is, ultimately, a storage device. Unfortunately, at this time we can't support HCC because of this. We do fully support Exadata as long as HCC is not in play.
Reopening this old thread :)
@Michael Brown
Is this still correct to say that Delphix vDB cannot be created if HCC is applied on Source Oracle DB ?
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 5,846 Points 5k badge 2x thumb
Hi,

Difenetly not.

HCC is something that oracle locked only on its own storage products (exadata, pillar, zs).

But you can still use Delphix with non of those storage appliances, the key point is just to uncompress the hcc tables using a hook at vdb configuration.

Or you can have one of those storages as a backend for Delphix and nothing should be done you can query the hcc tables

Mouhssine
Photo of Tim Gorman

Tim Gorman, Delphix Field Services

  • 3,836 Points 3k badge 2x thumb
Official Response
I'm having trouble reading some of the earlier responses in this thread, with black backgrounds and gray text font, so at the risk of repeating some responses, I'm going to offer the following...

Typically for Exadata sources, Delphix uses either one (or more) of the Exadata compute nodes as target servers, or else completely separate Linux x86-64 servers as target servers.

Regardless of what server is used for compute, Delphix VDBs can be provisioned to these target servers from Exadata sources, whether HCC is in use or not.

HCC is usable only on Oracle-branded storage (i.e. Exa, ZFSSA, Pillar), so HCC tables are unreadable within Delphix VDBs unless appropriate "ALTER TABLE ... MOVE ..." commands are configured to rebuild the HCC tables (usually as COMPRESS BASIC) using Delphix "configure clone" hooks.

As for HJ's original question, applying patches to the target VDB system should be considered very carefully.  Exadata patches are often comprehensive bundled patches, so they may include changes for storage nodes, compute nodes, and database.

If you are testing a database-only patch, then no problems; the patch will affect only the Delphix VDB.

If the patch is more comprehensive and bundled, and hits more than just database, then please exercise caution.  Delphix can virtualize binaries and other file-systems as well as databases, allowing testing of patches to the RDBMS binaries, but comprehensive Exadata bundle patches might go beyond that and update the OS or firmware on the compute node, which Delphix can not and does not virtualize.

Hope this helps...
Photo of Gnanagiri

Gnanagiri

  • 70 Points

Tim,

Thanks for the explanation.

I have one query with respect to the HCC tables in DSource.

Will there be any licensing factor if the HCC tables are present in the Dsource(Gold Copy).

When a VDB is created we are disabling the compression with the help of hooks, so we are good there.

Just wanted to get clarify on the DSource part. 

Regards,

Giri