General
cancel
Showing results for 
Search instead for 
Did you mean: 

HP-UX 11 kernel tuning for multiple Oracle8 SIDs

SOLVED
Go to solution
Scott Robertson
Occasional Advisor

HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Anyone have some suggestions or documents pertaining to this subject?

Some background, as this is a new sysadmin experience for me. Instead of one server providing application and database services, our new hardware environment will provide for database and application servers to be separate physical servers. This in turn will cause several production databases to be running on one server. I'm looking for some "been there, done that" tuning information or any relevant documents.
*formally known as srobertson@bcbsga.com
8 REPLIES
Victor BERRIDGE
Honored Contributor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Something like # ps -ef|grep pmon|more
dbap24h 7553 1 0 Jun 8 ? 16:21 ora_pmon_P24H
dbaprda 18695 1 2 22:16:45 ? 0:08 ora_pmon_PRDA
dbapsac 26545 1 0 23:38:57 ? 0:07 ora_pmon_PSAC
dbapcar 28581 1 2 23:49:52 ? 0:07 ora_pmon_PCAR
dbapsad 3991 1 2 20:18:10 ? 0:10 ora_pmon_PSAD
root 10298 10407 1 17:54:27 ttyp1 0:00 grep pmon
dbaprde 17243 1 2 22:06:58 ? 0:08 ora_pmon_PRDE
dbapsyn 10859 1 0 21:09:33 ? 0:09 ora_pmon_PSYN
?

One instance owner per instance
separate listener per instance

Good luck

Victor
Alexander M. Ermes
Honored Contributor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Hi there.
Victor is a genius. But be careful, if you use a 32-bit HP-UX 11.00, because if you do not run memory windows on your machine, the to?tal
size of the SGA's should not exceed 1.75 GB.
So take care.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Rhonda Thorne
Frequent Advisor
Solution

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Hi..

For each instance, the oracle SGA is a shared memory seg. so make sure that your kernel params for shared memory are large enough to hold total size of all SGA's added together.

maxdsize
nproc
maxusers
These should be verified with oracle's requirments

Good luck
Sharing my knowledge of UNIX flavors
Scott Robertson
Occasional Advisor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Victor,
I just wish the DBA's here would use one owner per instance, they prefer one owner and listener for all instances. Some logic just scrambles the mind.

Alexander,
Thanks for you input, and our servers will be 64-bit HP and 64-bit Oracle, so the SGA 1.75GB limitation should not be an issue. N4000's will be handling our new software environment.

Rhonda,
Thanks for you input, and I will keep this information handy, for when the fun begins.
*formally known as srobertson@bcbsga.com
Victor BERRIDGE
Honored Contributor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

there was a reason behind the multiple uids, when it comes to semaphores and having to ipcrm etc...when all is under a same uid you need nerves...

Good luck
Victor
CHRIS ANORUO
Honored Contributor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Look at the following attached document
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
CHRIS ANORUO
Honored Contributor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

There was no way I could post 2 attachements: Look a this second document
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Scott Robertson
Occasional Advisor

Re: HP-UX 11 kernel tuning for multiple Oracle8 SIDs

Victor,
Excellent thought and a great point for ease of admin. I'll have to run your multiple uids idea passed the senior DBA's and get their thoughts.

Chris,
Thanks for the documents. I'll be passing these onto the DBA staff for awareness.
*formally known as srobertson@bcbsga.com