topic Re: Prm configuration in Operating System - HP-UX

Prm configuration

Kenan Erdey — Sat, 23 May 2009 15:00:24 GMT

Hi,

we have an Oracle RAC running on 11.11 on two rp8420 nodes. lets say RAC is for X project. X database has 13 GB SGA size.

by the way nodes have 12 core and 24 GB Memory.

and also Y project's database is running on one of them and it's configured active-passive. SGA size is 6.5 GB

applications that uses these databases have some problems and sometime because of the these problems two database instance that running on the same node consume more resource than expected. i want to isolate them with PRM so that if there is a problem with one, the other is not affected.

configuration for PSET is below:

X:PSET:::7:
Y:PSET:::4:

root::::(PRM_SYS)
daemon::::OTHERS
bin::::OTHERS
sys::::OTHERS
adm::::OTHERS
uucp::::OTHERS
lp::::OTHERS
nuucp::::OTHERS
hpdb::::OTHERS
nobody::::OTHERS
www::::OTHERS
smbnull::::OTHERS
webadmin::::OTHERS

/oracle/product/bin/oracle::::X,ora*Xins
/oracle/product/bin/oracle::::Y,ora*Yins

oracleX::::X
oracleY::::Y

my questions:

1. is this configuration for PSET is true ?
2. is it supposed to configure MRG for memory isolation for oracle ? if yes how should i do it ?
3. are there anything more that i must consider for this configuration ( it is a cluster environment)

thanks.

Re: Prm configuration

Steven E. Protter — Sun, 24 May 2009 04:48:25 GMT

Shalom,

You say:
i want to isolate them with PRM so that if there is a problem with one, the other is not affected.

PRM does not really isolate anything. If these two programs were stepping on each others memory, one or both would crash instantly.

You seem to indicate that when running on the same node too much resources are being used.

You might try a smaller SGA for both databases as a solution.

I simply don't see where PRM helps. It can manage priorities and give one instance resource priority on the other, however if they are both requesting memory, more than the system has PRM isn't going to stop that. More memory or better memory management is the key to that situation.

SEP

Re: Prm configuration

Kenan Erdey — Sun, 24 May 2009 06:53:23 GMT

hi,

> You seem to indicate that when running on > the same node too much resources are being used.

just when there is a problem. while the problem arises, one instance consumes nearly all cpu and the other gets stack because of cpu lack.

best way is migrating one to another pysical hw i know, before that prm can be useful for this.

Re: Prm configuration

Kenan Erdey — Mon, 25 May 2009 06:53:39 GMT

http://www.repton.co.uk/library/hp_prm_oracle.pdf

good document about using oracle with prm. but not telling about cluster, etc.

any ideas are welcome with points :)

Re: Prm configuration

M. Coffey — Tue, 26 May 2009 18:50:57 GMT

A more recent version of the PRM/Oracle whitepaper is available at http://www.hp.com/go/prm. Another whitepaper about using PRM's Shared Memory management functionality is also available at the same location.