How to assign 1CPU for Oracle 10g

[Allan Umandap]

Hi guys,

I recently, installed 10g in our HP-UX 11.23 itanium box. Since, licensing for oracle 10g is per CPU - how can i assign a single CPU to it. Currently, i have 8 CPUs running but not sure which one is assigned to 10g. Guys pls help me!!!

Allan

[Thierry Poels_1]

hi,

maybe installing vPars (Virtual Partitioning) is an option.
I don't think other software options like RPM are accepted by Oracle.

regards,
Thierry.

[Allan Umandap]

Thnaks for the reply. But vPars are not possible in HP Superdome itanium servers.

[Victor BERRIDGE]

Hi,
I remember having to do with pset and pbind...
look at this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=58823

All the best
Victor

[Fred Ruffet]

Sounds strange to me that vPars are not available... If it is real, maybe you can create a nPar.

Other thing : PRM works with Oracle. It will require to purchase a PRM license, I believe.

Regards,

Fred

[Robert-Jan Goossens]

Hi Allan,

How about Process Resource Manager (PRM)

http://www.software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B3835DATRY

Regards,
Robert-Jan

[Duncan Edmonstone · Accepted solution]

Allan,

I think your on a hiding to nothing here... If your server has 8 CPUS then Oracle are going to want 8CPU licenses, generally they don't accept your word that you will run it only on a single CPU. I think the best you could do woul use nPars, which would presumably allow you to get down to just a single cell board with 4 CPUs - Oracle might accept that.

If you really want to restrict Oracle to just one CPU despite this, you need to use PSETS

man psrset

for more information

HTH

Duncan

[melvyn burnard]

Vpars is not yet available for 11.23 HP-UX, so you cannot use that.
PRM/WLM may be able to help you here, and depending on the OE you have, you may find these already installed.
The best/quickest way is to use Psets, and bind the Oracle processes to a single processor.
I have to ask whether you have checked with Oracle whether this would actually allow you to only buy a single cpu license...

[Thierry Poels_1]

RPM??

You can limit resources with tools like PRM, WLM, ....
But what I meant is that Oracle Corp might not accept this as a single CPU server, so they may still want you to pay an 8 CPU license.
Hardware partitions (npars) however are accepted by Oracle Corp.

regards,
Thierry Poels.

[Allan Umandap]

Guys thanks for the many replies...

i haven't asked oracle if they will accept our inital solution - using PRM to assign 1CPU. Maybe i'll ask later.

if ever i opted to do another npar for oracle, do i need to install OS on it? have any of you guys encountered the same situation i am now? or you now somebody who has?

thanks for your answers...

[Steven E. Protter]

Oracle will accept a vpars solution. I've checked into that myself because I'm planning a hardware buy and I want the ability to push more CPU's into the mix.

Depending on your time frame, it might be a good idea to actually wait for vpars.

Oracle is however quite likely to say they don't support the vpars configuration out of the box because its not released and they haven't had a chance to test it.

vpars is the better solution, so long as each virtual partition has a NIC card, something to boot of of and a CPU and some memory. The cool part is that for short term issues, you can slave in other CPU's. I'd plan for that as a long term solution even if you have to use PRM on the short run.

Licensing for the Oracle Database server is also per CPU, so don't forget to take that into account.

SEP