[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

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

1531.0. "ORA-07307" by MEOC02::LEE () Mon Mar 17 1997 03:33

    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.RTitleUserPersonal
Name
DateLines
1531.1check thisALFAM7::GOSEJACOBMon Mar 17 1997 07:4335
    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.2sysconfigtab parametersMEOC02::LEEMon Mar 17 1997 21:3540
    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.