1748185 Members
4178 Online
108759 Solutions
New Discussion юеВ

Re: Prm configuration

 
Kenan Erdey
Honored Contributor

Prm configuration

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.
Computers have lots of memory but no imagination
4 REPLIES 4
Steven E. Protter
Exalted Contributor

Re: Prm configuration

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Kenan Erdey
Honored Contributor

Re: Prm configuration

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.
Computers have lots of memory but no imagination
Kenan Erdey
Honored Contributor

Re: Prm configuration

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 :)

Computers have lots of memory but no imagination
M. Coffey
New Member

Re: Prm configuration

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.