question Re: using Oracle as the database for Ambari, Hive and Oozie, how do we go about sizing the each DB? also, which versions of oracle do we support 11g, 12g? in Archives of Support Questions (Read Only)

using Oracle as the database for Ambari, Hive and Oozie, how do we go about sizing the each DB? also, which versions of oracle do we support 11g, 12g?

mcarrillo — Sat, 10 Oct 2015 01:39:43 GMT

deepesh1 — Sat, 10 Oct 2015 01:44:23 GMT

We support both Oracle 11g r2 and Oracle 12c.

awatson — Sat, 10 Oct 2015 01:46:36 GMT

Hi Martin,

nsabharwal — Sat, 10 Oct 2015 19:32:56 GMT

Yes, both versions are supported and thanks for sharing the doc link.

About sizing:

Ambari, Oozie , Hive - For small to large clusters, the database size and load wont be high unless there is something wrong with the setup.

Coming from Oracle DBA background, I would say that following configuration is good start

64 to 128 GB memory

16 to 32 cpu ( Dual core)

OS disk - standard size ( raid 10)

/oracle - 50 to 100 (raid 10) - oracle binaries

/oraclelogs - anything near to 500GB (raid 1, its for oracle redo log files , not archive logs)

/archivelogs - 300 to 500GB ( raid 1, oracle archive logs and make sure there is archive log rotation in place)

/data - 500G to 1 TB ( raid 10, oracle tablespaces)

Export backups MUST

Any good DBA will stick with both RMAN and Export backups.