Re: SGA problems on solaris

In article <8cdq4j$vma$1_at_nnrp1.deja.com>,   legolas_at_mjollnir.org wrote:
> I installed oracle 7 onto a ultra1 with no problems
> other than the installer failing to create the DB objects:
>
> ERROR: The 'CREATE DATABASE' statement for the CSS database failed
> egrep failed to find '%create_db_key_words%' in the file
> /css/app/admin/CSS/create/crdbCSS.lst
>
> $ svrmgrl
> connect internal
> startup
> ORA-07331: smsnsg: unable to allocate the variable
> portion of the SGA
> Additional information: 4
>
> I looked at the init.ora files and they look like the ones we
> have at work.
>
> Which value in the init files is wrong?
> Maybe I need to create some shared memory segs?

the following values in my /etc/system file work for me. After this file is changed you need to reboot the system.

HTH & YMMV!

• 980626 cjl added semaphore and shared memory parms for Oracle set semsys:seminfo_semmap = 100 set semsys:seminfo_semmni = 70 set semsys:seminfo_semmns = 600 set semsys:seminfo_semmnu = 100 set semsys:seminfo_semmsl = 100 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 100

set semsys:seminfo_semusz = 96
set semsys:seminfo_semvmx = 32767
set semsys:seminfo_semaem = 16384

• set shared memory max size to 80% of total ram = (500 * .8) * 1024 * 1024 set shmsys:shminfo_shmmax = 419430400 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmmni = 100 set shmsys:shminfo_shmseg = 10
• 980626 cjl End changes

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 00:00:00 CDT