Multi ORCL database shared in a single blade server

[hdkid]

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!

[RickT_1]

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

[hdkid]

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!

[RickT_1]

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

Rick

[hdkid]

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!

[Emil Velez]

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

[Viktor Balogh]

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

[Jean-Luc Oudart]

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

[Jean-Luc Oudart]

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