Operating System - HP-UX
1748289 Members
3213 Online
108761 Solutions
New Discussion юеВ

Oracle database server and recommended kernel parameters

 
Christopher McCray
Occasional Contributor

Oracle database server and recommended kernel parameters

I have an L-class 2000 that is being configured to run as an Oracle test server with one large database to be created on it. I have been told that there are a few parameters in the kernel that needs configuring according to Oracle's needs, but the DB administrators cannot give me a comprehensive list, with the exception of one at a time. I do not want to rebuild a kernel 25 times or more, so can someone help with a good starting point?
Christopher McCray
6 REPLIES 6
Alexander M. Ermes
Honored Contributor

Re: Oracle database server and recommended kernel parameters

Hi there.
Did you install the patch PHSS_22478 ?
Have you checked your kernel params ?
shmmax 1610612736 1610612736
Check the Install and Upgrade guide on Oracle Metalink.
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"
MANOJ SRIVASTAVA
Honored Contributor

Re: Oracle database server and recommended kernel parameters

The total picture is as : There is a HP patch (PHSS_22478) that have to be applied before the oracle Install. Also, the HP Unix system configration must be verified and make any necessary changes based on the Oracle 8.1.7 requirement.

Parameter Required
==================================
SHMMAX 1gb
SHMMIN 1
SHMMNI 100
SHMSEG 10

SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC >= 256


Manoj Srivastava

CHRIS ANORUO
Honored Contributor

Re: Oracle database server and recommended kernel parameters

Hi Chris,

Attached is my kernel parameter basically same thing used for 3 different oracle8 servers. This is for K580 HPUX 10.20. I will soon be cutting over to 11 and Oracle 8.1.6.Make sure you have enough swap space.


Cheers!
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Pedro Sousa
Honored Contributor

Re: Oracle database server and recommended kernel parameters

Christopher McCray
Occasional Contributor

Re: Oracle database server and recommended kernel parameters

to Manoj, would these params apply to 8.1.6, or just to 1.7?
Christopher McCray
MANOJ SRIVASTAVA
Honored Contributor

Re: Oracle database server and recommended kernel parameters

Yes , they are pretty much the same. Both are nearly same version except for some bugs .


Manoj Srivastava