| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
Hi,
I am working on an AS8400 with 4GB of memory and would like to increase
the SGA area. The shm-max is set to 2147483647. ORACLE 7.2.3 fails to
start with the message :-
ORA-07307: sms1sg: shmat error, unable to attach sga.
DEC OSF/1 (AXP) Error:22: Invalid argument
ORACLE starts up if
shared_pool_size = 160956416
db_block_buffer = 29472
log_buffer = 327680
but not when
shared_pool_size = 482869248
db_block_buffers = 88416
log_buffer = 983040
Any comments is appreciated.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1531.1 | check this | ALFAM7::GOSEJACOB | Mon Mar 17 1997 04:43 | 35 | |
re .0 couple of comments here:
- Any reason why shm-max is set to 2GB - 1 byte?
- oerr ora 7307
07307, 00000, "sms1sg: shmat error, unable to attach sga."
// *Cause: Failed to attach shared memory segment, after having gotten
it.
// *Action: Check errno returned. Verify that SGA attach address is
valid.
Hmmm looks like you have been able to allocate your 400 MB SGA but
could not attach to it.
- Have you set vlm_sga_base_address ?
- Have you set:
vm-maxvas
vm-mapentries
max-per-proc-address-space
max-per-proc-data-size
in /etc/sysconfigtab (and rebooted)?
- Have you increased you shell limits for
datasize
addressspace?
- Are you running Unix 4.0x? In which case: have you set
ssm-threshold = 0
in /etc/sysconfigtab?
Have a look at the "Oracle7 Installation Guide for Digital UNIX" for
detailed information on how to set these parameters.
Martin
| |||||
| 1531.2 | sysconfigtab parameters | MEOC02::LEE | Mon Mar 17 1997 18:35 | 40 | |
This machine was upgraded to 4 Gbyte of memory and 4 processors due to
performace problems with SAP R/3 application. One of the recommendations
was to increase the SGA area. I was led to believe that the maximum value
of shm-max is2GB-1. Is this correct ?
The current values set in /etc/sysconfigtab are:-
ssm-threshold = not set (Digital UNIX 3.2G)
vlm_sga_base_address = not set
vm-maxvas = not set
vm-mapentries = not set
max-per-proc-address-space = not set
max-per-proc-data-size = 4294967296
I've checked the SAP R/3 3.0D documentation and the recommended
parameters and values are:-
ipc:
shm-max = 536870912 (minimum)
shm-seg = 256
sem-mni = 256
num-of-sems = 512
vm:
ubc-maxpercent = 10
ubc-minpercent = 5
vm-pagemax = 262144
vm-maxvas = 4294967296
proc:
max-per-proc-data-size = 671088640
max-per-proc-stack-size = 33554432
per-proc-data-size = 671088640
per-proc-stack-size = 33554432
max-proc-per-user = 256
max-per-proc-address-space = 2147483648
per-proc-proc-address-space = 2147483648
open-max-soft = 4096
open-max-hard = 4096
open-max-system = 4096
I try this new parameters tonight. Any futher comments welcome.
| |||||