Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Oracle 10g on Linux 2.6.3 AMD64: Shared Memory Issues

    Hi,

    I've been trying to install 10g on a new Opteron Linux box. I'm
    running kernel 2.6.3. Installation runs well.

    I've been able to create the database manually, but the following
    error happens about mid-way while running catalog.sql:

    GRANT SELECT ON sys.exu8refu TO PUBLIC
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
    pool","select name,intcol#,segcol#,...","Typecheck heap","kgghteInit")


    Can someone see

    Here's a summay of my config:

    Dual Opteron 246, 4GB SDRAM. Gentoo Linux, Oracle running in 32 bits chrooted environment.

    Linux meknes 2.6.3-gentoo-r2 #6 SMP Mon Mar 22 06:03:48 PST 2004 i686 AMD Opteron(tm) Processor 246 AuthenticAMD GNU/Linux

    Kernel/VM options:
    net.ipv4.ip_local_port_range = 1024 65000
    vm.min_free_kbytes = 2867
    vm.lower_zone_protection = 0
    vm.nr_hugepages = 64
    vm.swappiness = 0
    vm.nr_pdflush_threads = 2
    vm.dirty_expire_centisecs = 3000
    vm.dirty_writeback_centisecs = 500
    vm.dirty_ratio = 40
    vm.dirty_background_ratio = 10
    vm.page-cluster = 3
    vm.overcommit_ratio = 50
    vm.overcommit_memory = 0
    kernel.shmmni = 4096
    kernel.shmall = 2097152
    kernel.shmmax = 2147483648
    kernel.rtsig-max = 1024
    kernel.rtsig-nr = 0
    fs.file-max = 65536


    init.ora:

    global_names = TRUE
    db_name = GEN1
    db_domain = WORLD
    instance_name = GEN1
    service_names = GEN1.WORLD
    compatible = 10.1.0
    db_block_size = 4096
    db_files = 512
    control_files = /home/oracle/oradata/GEN1/con/GEN1_con01.con,
    db_cache_size = 12M
    db_2k_cache_size = 8M
    db_8k_cache_size = 8M
    db_file_multiblock_read_count = 32
    db_block_checking = true
    db_block_checksum = false
    shared_pool_size = 32000000
    log_checkpoint_interval = 50000000
    log_checkpoint_timeout = 0
    log_checkpoints_to_alert = true
    log_buffer = 1024000
    # log_archive_start = false # deprecated
    log_archive_dest = /home/oracle/oradata/GEN1/arc
    log_archive_format = GEN1_%s_%t_%r.arc
    fast_start_mttr_target = 300
    undo_management = AUTO
    undo_retention = 10800
    undo_tablespace = undo
    open_cursors = 1024
    cursor_space_for_time = false
    optimizer_mode = choose
    hash_area_size = 1048576
    sort_area_retained_size = 128000
    sort_area_size = 512000
    audit_file_dest = /home/oracle/oradata/GEN1/adm/admp
    user_dump_dest = /home/oracle/oradata/GEN1/adm/udmp
    background_dump_dest = /home/oracle/oradata/GEN1/adm/bdmp
    core_dump_dest = /home/oracle/oradata/GEN1/adm/cdmp
    utl_file_dir = /home/oracle/oradata/GEN1/adm/utld
    max_dump_file_size = 10240
    _trace_files_public = true
    sql_trace = false
    timed_statistics = true
    sql92_security = true
    resource_limit = true
    audit_trail = none
    # max_enabled_roles = 128 # deprecated
    os_authent_prefix = "OPS$"
    os_roles = false
    remote_os_roles = false
    remote_os_authent = false
    remote_login_passwordfile = none
    open_links = 64
    job_queue_processes = 1
    processes = 100
    license_max_sessions = 0
    license_sessions_warning = 0
    enqueue_resources = 4096
    parallel_min_servers = 0
    parallel_max_servers = 0 # SMALL
    query_rewrite_enabled = true
    query_rewrite_integrity = stale_tolerated
    nls_date_format = 'DD.MM.YYYY:HH24:MI'
    nls_numeric_characters = '.,'
    nls_language = AMERICAN
    nls_territory = AMERICA


    init.sql:
    CREATE DATABASE GEN1
    CONTROLFILE REUSE
    MAXDATAFILES 256
    MAXINSTANCES 4
    MAXLOGFILES 62
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1600
    CHARACTER SET "WE8ISO8859P1"
    NATIONAL CHARACTER SET "AL16UTF16"
    DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_sys1.dbf' SIZE 800M REUSE
    SYSAUX DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_sysaux1.dbf' SIZE 800M REUSE
    UNDO TABLESPACE undo DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_undo1.dbf'
    SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    DEFAULT TEMPORARY TABLESPACE temp
    TEMPFILE '/home/oracle/oradata/GEN1/tmp/GEN1_temp1.dbf' SIZE 500M REUSE
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
    LOGFILE GROUP 1 ('/home/oracle/oradata/GEN1/rdo/GEN1_log1A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log1B.rdo') SIZE 10M REUSE,
    GROUP 2 ('/home/oracle/oradata/GEN1/rdo/GEN1_log2A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log2B.rdo') SIZE 10M REUSE,
    GROUP 3 ('/home/oracle/oradata/GEN1/rdo/GEN1_log3A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log3B.rdo') SIZE 10M REUSE,
    GROUP 4 ('/home/oracle/oradata/GEN1/rdo/GEN1_log4A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log4B.rdo') SIZE 10M REUSE,
    GROUP 5 ('/home/oracle/oradata/GEN1/rdo/GEN1_log5A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log5B.rdo') SIZE 10M REUSE,
    GROUP 6 ('/home/oracle/oradata/GEN1/rdo/GEN1_log6A.rdo',
    '/home/oracle/oradata/GEN1/rdo/GEN1_log6B.rdo') SIZE 10M REUSE;

    CREATE TABLESPACE users
    DATAFILE '/home/oracle/oradata/GEN1/usr/GEN1_users1.dbf' SIZE 10304K REUSE
    AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
    SEGMENT SPACE MANAGEMENT AUTO
    PERMANENT
    ONLINE;


    CREATE TABLESPACE tab
    DATAFILE '/home/oracle/oradata/GEN1/tab/GEN1_tab.dbf' SIZE 819264K REUSE
    AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
    PERMANENT
    ONLINE;


    CREATE TABLESPACE idx
    DATAFILE '/home/oracle/oradata/GEN1/idx/GEN1_idx1.dbf' SIZE 819264K REUSE
    AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
    PERMANENT
    ONLINE;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    As a shot in the dark I'd try
    shared_pool_size = 64000000
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Talking

    Looks like it did the trick! Thank you very much

    Julien

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •