topic Re: Multi ORCL database shared in a single blade server in Operating System - HP-UX

Multi ORCL database shared in a single blade server

hdkid — Mon, 04 Apr 2011 14:46:24 GMT

Hi all!
We have a HP BL870c i2 (4 CPUs Quad core / 64GB Memory) server. My boss want to consolidate 3 Oracle dbs on it, and they will be dynamic resource re-configured when we have different workload at anytime (1 db for ETL; other 2 dbs for summaring data and reporting). My concern is which the virtualization technology (IVM, PRM, WLM,.. .) is best solution for this problem.

Please help and advidse when I have no more experence with HP VSE.

Thanks so much!

Re: Multi ORCL database shared in a single blade server

RickT_1 — Mon, 04 Apr 2011 15:20:45 GMT

Hi Hdkid,

You don't have to virtualize you can set up all of your instances on the blade and still do dynamic resource configuration.

Rick

Re: Multi ORCL database shared in a single blade server

hdkid — Mon, 04 Apr 2011 15:46:08 GMT

Hi RickT!
Could you please show more detailed? I don't understand your mean? How could we configure when at anytime instance A need more resoure (CPU/memory) and have high workload, other instance have medium workload?

Wait for your recommend? Thanks!

Re: Multi ORCL database shared in a single blade server

RickT_1 — Mon, 04 Apr 2011 17:05:45 GMT

HP has the resource manager that could do the resource management, but AFAIK Oracle also has some resource management tools bilt into it.

Rick

Re: Multi ORCL database shared in a single blade server

hdkid — Mon, 04 Apr 2011 17:18:25 GMT

Hi RickT!
My OS is HP-UX 11.31 VSOE. I found that vPar only is supported in cell-based server. And
what do you think about IVM, WLM/gWLM? The advantage and disadvantage when compared with PRM as you recommend?

Thanks in advanced!

Re: Multi ORCL database shared in a single blade server

Emil Velez — Tue, 05 Apr 2011 02:57:06 GMT

another option where you can partition the databases with process isolation is compartments or secure resource partitions. That would provide security isolation too.

You dont have to use a partitioning.. Running 3 instances on 1 box with different users, different home directories and different datafiles work great. Heck you can have different versions of oracle on the same box too. Oracle supports that

Re: Multi ORCL database shared in a single blade server

Viktor Balogh — Tue, 05 Apr 2011 07:45:40 GMT

here are two ways to manage workload:

HP Process Resource Manager (PRM)

http://h71028.www7.hp.com/enterprise/us/en/os/hpux11i-prm-overview.html

HP Global Workload Manager (gWLM)

http://h18004.www1.hp.com/products/solutions/insightdynamics/vse-gwlm.html

Re: Multi ORCL database shared in a single blade server

Jean-Luc Oudart — Tue, 05 Apr 2011 10:39:04 GMT

Hi

unless it is a requirement for you to separate the databases into diferent VM, may be you should investigate Oracle Database Reource Manager and Oracle caging.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dbrm001.htm
http://download.oracle.com/docs/cd/E14072_01/server.112/e10595/dbrm007.htm

more work for the DBA !

Regards
Jean-Luc

Re: Multi ORCL database shared in a single blade server

Jean-Luc Oudart — Tue, 05 Apr 2011 10:49:20 GMT

Hi again

forgot to mention this White Paper from Oracle :
http://www.oracle.com/technetwork/database/focus-areas/performance/instance-caging-wp-166854.pdf

Regards
Jean-Luc