3 Replies Latest reply: Oct 10, 2009 6:44 AM by Hans Forbrich RSS

    Getting Error:SGA size can not be greater than maximum shared memory segmen

    601989
      Hi,

      While creating database in Linux Env I am getting Error as:

      SGA size can not be greater than maximum shared memory segment size

      Any help will be needful for me

      Thanks and Regards
        • 1. Re: Getting Error:SGA size can not be greater than maximum shared memory segmen
          Hans Forbrich
          user598986 wrote:
          SGA size can not be greater than maximum shared memory segment size
          Reduce the SGA size request or increase the SH parameters.

          You DID set the shared memory parameters and semaphore parameters permanently as described in the install guide, did you not?

          (Please get into the habit of including OS/distro and DB version in the questions.)
          • 2. Re: Getting Error:SGA size can not be greater than maximum shared memory segmen
            601989
            The OS:Linux 32 bit

            The Database:oracle 10g server release 2

            I execute the following command :

            cat /proc/sys/kernel/shmmax and got the SH value

            SHARED MEMORY SEGEMENT IN LINUX:536870912

            The SGA value is taken from template(.dbt) using dbca command line execute execution.

            The .dbt file contents are:

            <InitParamAttributes>
            <InitParams>
            <initParam name="pga_aggregate_target" value="482344960"/>
            <initParam name="db_cache_size" value="1040187392"/>
            <initParam name="processes" value="2000"/>
            <initParam name="db_recovery_file_dest_size" value="2147483648"/>
            <initParam name="control_files" value="(&quot;{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl&quot;, &quot;{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl&quot;, &quot;{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl&quot;)"/>
            <initParam name="sga_target" value="1459617792"/>
            <initParam name="streams_pool_size" value="0"/>
            <initParam name="compatible" value="10.2.0.1.0"/>
            <initParam name="shared_pool_size" value="369098752"/>
            <initParam name="sessions" value="2500"/>
            <initParam name="background_dump_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/bdump"/>
            <initParam name="job_queue_processes" value="10"/>
            <initParam name="java_pool_size" value="16777216"/>
            <initParam name="db_name" value=""/>
            <initParam name="large_pool_size" value="16777216"/>
            <initParam name="user_dump_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/udump"/>
            <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
            <initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
            <initParam name="open_cursors" value="2500"/>
            <initParam name="db_block_size" value="8192"/>
            <initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/flash_recovery_area"/>
            <initParam name="undo_tablespace" value="UNDOTBS1"/>
            <initParam name="core_dump_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/cdump"/>
            <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
            <initParam name="undo_management" value="AUTO"/>
            <initParam name="db_file_multiblock_read_count" value="16"/>
            <initParam name="cursor_sharing" value="SIMILAR"/>
            </InitParams>

            Any help will be needful for me
            • 3. Re: Getting Error:SGA size can not be greater than maximum shared memory segmen
              Hans Forbrich
              Please compare your /etc/sysctl.conf to the values in section 2.6 at http://download.oracle.com/docs/cd/B19306_01/install.102/b15660/pre_install.htm#sthref85