Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.1.6

SOLVED
Go to solution
Robb Bailey
Occasional Advisor

Oracle 8.1.6

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
3 REPLIES
MANOJ SRIVASTAVA
Honored Contributor
Solution

Re: Oracle 8.1.6

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
Occasional Contributor

Re: Oracle 8.1.6

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.
If your'e going to shoot, shoot don't talk
Wodisch
Honored Contributor

Re: Oracle 8.1.6

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