Re: ORA-27102: out of memory

Hi edward,

add following parameters to /etc/system file and restart the machine. Your problem must disappear.

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

Good Luck
George

Edward Rosenthal wrote:

> i'm on solaris box and i just installed 8.1.5.
> during install it proceeded up to the two optional
> components, one of which was database config assistant
> where it hung.
> i shut down the java installer, and got the out of memory
> error when i tried a startup nomount pfile=<pfile name>
> i cannot read the docs they are all in html and there is no
> netscape on this machine.
> when i go to metalink and view patches it is the same problem.
> i cannot read the html docs or the pdf docs.
> i need to know what the output of ipcs -a should be for a minimal
> configuration.
> i would like to know which revisions on the solarsi box are recommended.
>
> i should like to know the patches required for this version of this unix
> box, if any.
> any body have a handy excel spreadsheet or similar?
> thanks,
> ed
> btw - the trc files show
> skgm warning: EINVAL creating segment of size 0000000001400000
> fix shm parameters in /etc/system or equivalent
> lots of these messages in files
> in this dir
> /local1/users/oracle/app/oracle/8.1.6/rdbms/log
> with lots of different 'size' numbers.
>
> other output of possible interest ...
> ipcs -m
> IPC status from <running system> as of Fri Dec 1 18:46:46 PST 2000
> T ID KEY MODE OWNER GROUP
> Shared Memory:
> m 0 0x50000676 --rw-r--r-- root root
> m 1 0 --rw-rw-rw- oracle dba
>
> $ ipcs -a
> IPC status from <running system> as of Fri Dec 1 18:49:16 PST 2000
> Message Queue facility inactive.
> T ID KEY MODE OWNER GROUP CREATOR
> CGROUP NATTCH
> SEGSZ CPID LPID ATIME DTIME CTIME
> Shared Memory:
> m 0 0x50000676 --rw-r--r-- root root root
> root 1
> 4 243 2959 12:08:38 12:08:38 15:07:41
> m 1 0 --rw-rw-rw- oracle dba oracle
> dba 0
> 45708 5238 5238 14:44:03 14:47:05 14:44:03
> Semaphore facility inactive.
> $ vmstat
> procs memory page disk faults
> cpu
> r b w swap free re mf pi po fr de sr m0 m1 m3 m5 in sy cs us
> sy id
> 0 0 0 2458792 444624 0 0 0 0 0 0 0 0 0 0 0 107 18 17
> 0 0 100
  Received on Tue Jan 02 2001 - 21:29:23 CST