Oracle 8.1.6

[Robb Bailey]

I have just installed 32 Bit Oracle 8.1.6 on a K200, 512 RAM, 1 GB swap, 11.0 OS. The typical install was to take 977 MB, but it ended up taking 1.25 GB. My tmp directory is 300 MB, but I also ran out of space. Any idea why? I did install the recommended patches listed in the release notes (Release 2(8.1.6) December 1999. Are there other patches?

shmmax = 67108864
shmmin =1
shmmni =100
shmseg =120
semmns=200
semmni=70

Are these values acceptable? Are there other parameters that I should change?

Thank you very much for your suggestions.

Robb

[MANOJ SRIVASTAVA · Accepted solution]

Hi Robb

Here are the recommendations for Oracle :

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.6 requirement.

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

SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC >= 256


Manoj Srivastava

[Alan Wilson]

You may be allocating too much memory for your instance. Check the size of your SGA parameters in the pfile.

The main parameters are SHARED_POOL_SIZE
and DB_BLOCK_BUFFERS. Look in your Oracle documentation for the meaning of these parameters.

[Wodisch]

Hello Robb,

Oracle8.1.6 really takes that much space, I never
managed to install it with less than 1GB! 8.1.7 takes
about 1.5GB, BTW...
Increase your SHMMAX to 1GB, and your SEMMNS to,
say, 1000, and check DBC_MAX_PCT, NPROC, NINODE,
NFILE, NBUF, BUFPAGES, NKTHREAD, MAXUPRC,
MAX_THREADS, and MAX_SWAP_CHUNKS.
They all need to be increased, but to what degree
depends on the burden your system will have to
shoulder... Go for the kernel template "MONOLITHIC
SERVER" - but increase TIMESLICE back to 10!!!!!!!!!!

HTH,
Wodisch