Re: Solaris /etc/system values for Oracle8i

From: Tim Gorman <tim_at_sagelogix.com>
Date: Sun, 28 Sep 2003 12:59:43 -0800
Message-ID: <F001.005D14F7.20030928125943@fatcity.com>

I've a customer running a development environment of two OraApps 11.5.8 database instances and one more database instance (for web development under WebLogic), all on a Sun V100.

Yes, that is a rack-mountable Solaris machine of 1U rack height with a maximum configuration of one (1) UltraSPARC-III CPU, 1.0 Gb of RAM, and three 36-Gb HDD. Main storage is a NAS (since the machine doesn't accommodate SCSI or FC adapters).

Foolishly underconfigured, yes. Impossible or difficult, no.

on 9/27/03 7:54 AM, Tanel Poder at tanel.poder.003_at_mail.ee wrote:

> What the heck was that?
> 
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, September 27, 2003 2:54 AM
> 
> 

>>
>> Mario:
>>
>> If you are using Solaris with 2GB of memory, it will be awfully difficult,
>> if not impossible, to run 6 instances of Oracle8i simultaneously.
>> Basically, because of the use of semaphores and the way Solaris manages
>> memory, I would say you could run 3 or 4 instances , depending on their
>> size. But to have all six up and running, especially if you have to

> create

>> them, will not work. Oracle usually needs 1 GB per instance while you are
>> creating a database. While running it, you would not necessarily need

> that

>> much. I advice you to upgrade the memory on the server to 8 GB. I suggest
>> you budget 1 GB per Oracle instance.
>>
>> RWB
>>
>>

> ============================================================================
> ================================

>>
>> Reginald W. Bailey
>> IBM Global Services - ETS SW GDSD - Database Management
>> Your Friendly Neighborhood DBA
>> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
>> reginald.w.bailey_at_jpmorgan.com
>> baileyre_at_us.ibm.com
>>

> ============================================================================
> ================================

>>
>>
>>
>> Mario.H.Becerril_at_mex
>> .xerox.com To:

> ORACLE-L_at_fatcity.com


>>                     Sent by:                   cc:

>>                     ml-errors_at_fatcity.co       Subject:     Solaris

> /etc/system values for Oracle8i


>>                     m

>>
>>
>> 09/26/2003 06:19 PM
>> Please respond to
>> ORACLE-L
>>
>>
>>
>>
>>
>>
>>
>>

>>>   Hi managers.
>>> 
>>>   I need modify /etc/systems parameters in my e450 box, it allow 6

>> instances

>>> for oracle 8i
>>> 
>>>    Box have 2 GB in RAM
>>> 
>>>    Next values are valid???
>>> SHMMAX 0.5*(physical memory present in machine)
>>> SHMMIN 1
>>> SHMMNI 100
>>> SHMSEG 10
>>> SEMMNI 100
>>> SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an
>>> Oracle database on the system.
>>> SEMMNS Set to the sum of the PROCESSESparameter for each Oracle database
>>> except the largest one, plus 2 timesthe largest PROCESSES value, plus 10
>>> times the number of Oracle databases.
>>> SEMOPM 100
>>> SEMVMX 32767
>>> 
>>>         Mario Henley Becerril Geldis
>>>    *  (52) +55 5326 3200 ext. 1588
>>>    * Mario.H.Becerril_at_mex.xerox.com
>>>       System Administrator
>>> _______________________________________________
>>> sunmanagers mailing list
>>> sunmanagers_at_sunmanagers.org
>>> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
>>> 

>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Becerril, Mario Henley
>> INET: Mario.H.Becerril_at_mex.xerox.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author:
>> INET: Reginald.W.Bailey_at_jpmorgan.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>

>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Sep 28 2003 - 15:59:43 CDT