andybush2003_at_yahoo.com (Andy) wrote in message news:<bb3692fe.0306161357.344d5ac_at_posting.google.com>...
> Hi,
>
> OS: Red Hat Advanced Server 2.1
> DB: Oracle 9.2
>
> I followed the instructions in the installation manual, and was able
> to install the 9.2 database. My question is that after having created
> the 1st instance, I would like to add additional instances.
>
> The installation document only gives the kernel parameter values for
> one instance. Should I simply multiply the values by number of
> instances and adjust the values upwards.
>
> I know UNIX enough to find my way around, however not to the level as
> to make sense of how and what effects these kernel parameters would
> have on database processing on LINUX.
>
> Any help would be really appreciated.
>
> Thanks
Most of the parameters are quite OK for multiple instances. Main exception
would be SHMMAX. I don't know exactly how it works on Linux. Usually
this parameter sets the maximum size of shared segment, and as every
instance creates it's own shared segment for SGA, same parameter should
be OK for multiple instances. But this parameter is interpreted differently
in different flavors of UNIX. I think you should try to run couple of
instances with the same parameters, and if anything bad happens (usually
core dump when trying to start the instance), increase the value of
SHMMAX.
Received on Tue Jun 17 2003 - 11:00:04 CDT
