Oracle SGA Size over 1gb on Digital Unix

From: Mark A Greenhalgh <mark_greenhalgh_at_usa.net>
Date: Fri, 1 May 1998 09:34:33 -0400
Message-ID: <6icjeb$3gh@news.idx.com>

Hi all,

 I'm running Oracle 7.3.4 on a Digital Unix system v4.0d. For the last couple of days I have been trying to extend my SGA past 1gb and have been unsuccessful. As soon as I go over 1gb the Oracle instance fails to start with the following error:
SVRMGR> startup
Internal AIO consistency error: Cannot initialize aio library.

        Error 35: Operation would block
        Aborting...

From the alert log

Thu Apr 30 08:04:58 1998
Errors in file /u01/app/oracle/product/7.3.4/rdbms/log/ora_1136.trc: ORA-07445: exception encountered: core dump [6] [0] [0] [0] [] [] Thu Apr 30 08:08:29 1998
Starting ORACLE instance (normal)

The instance then creates a trace file and core dumps. This problem seems to have Oracle stumped. I assume other people have been able to go past this 1gb limit that I'm hitting..

The parameters that I have modified so far are: vm:

 vm-maxvas = 4294967296
 vm-mapentries=16384
 vm-vpagemax=262144
 vm-ubcseqstartpercent=10
 new-wire-method = 0

 ubc-minpercent = 1
 ubc-maxpercent = 2
ipc:

 shm-max = 2118123520
 shm-seg = 32
 msg-max = 8192
 msg-mnb = 16384
 msg-mni = 1024
 msg-tql = 4096
 sem-aem = 16384
 sem-mni = 200
 num-of-sems = 200
 sem-msl = 200
 sem-opm = 200
 sem-ume = 200
 sem-vmx = 32767
 ssm-threshold=0

dlm:
 dlm_disable_grptx = 0
proc:

 max-proc-per-user = 1024
 max-threads-per-user = 1024
 max-per-proc-data-size = 2147483648
 max-per-proc-address-space =2147483648

 enhanced-core-name = 1
 enhanced-core-max-versions= 4
vfs:
 name-cache-hash-size=512
advfs:

        AdvfsCacheMaxPercent=8
 AdvfsMaxDevQLen=16
inet:

        tcbhashsize=56
rt:
 aio-max-num = 512
 aio-max-percent = 2

Thanks,

Mark Greenhalgh
IDX Systems Corporation
mark_greenhalgh_at_idx.com Received on Fri May 01 1998 - 08:34:33 CDT