Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: oracle 10g DB installation problem

    Hi

    i´ve running oracle 10g on fedora core2 test 3!
    after runInstaller everything works fine, but when the database creation programm starts there is the "ORA-27125: unable to create shared memory segment" failure, after thar sevaral ora-01034 and ora-27101 appears. here are my hardware confg.:

    MemTotal: 516704 kB

    SwapTotal: 1048312 kB

    /dev/hda3 13080872 6504256 5912144 53%

    shmmax = 2147483648
    shmmni = 4096
    shmall = 2097152
    shmmin = 1
    shmseg = 10

    semmsl = 250
    semmns = 32000
    semopm = 100
    semmni = 128

    file-max = 65536

    ip_local_port_range = 1024 65000

    max total shared memory (kbytes) = 8388608

    searching for several days after a solution but nothing will work...

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://download-west.oracle.com/docs...167_01/toc.htm
    In case you are not aware, after changing any kernel parameters a system reboot is required to get the new values to be applied & used.
    AFAIK, the requested amount of shared memory exceeds what the OS can provide given existing values of both initSID.ora and kernel values.
    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
    May 2004
    Posts
    3
    when i try to creat a new databese with emca, the problem appears that the job_queue_process must be equal or greater 1. but in my init.ora it is greater then 1. what can i do... thx

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    oracle@cosmdss001BW# oerr ora 1034
    01034, 00000, "ORACLE not available"
    // *Cause: Oracle was not started up. Possible causes include the following:
    // - The SGA requires more space than was allocated for it.
    // - The operating-system variable pointing to the instance is
    // improperly defined.
    // *Action: Refer to accompanying messages for possible causes and correct
    // the problem mentioned in the other messages.
    // If Oracle has been initialized, then on some operating systems,
    // verify that Oracle was linked correctly. See the platform
    // specific Oracle documentation.
    oracle@cosmdss001BW#
    ================================================== ======
    I serious doubt that the errors you are getting have anything to do with
    job_queue_process
    since AFAIK this parameter has absolutely zero impact on SGA size.
    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.

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    for me shared_pool_size = 83886080 worked

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Review your init.ora parameters : db buffer cache, shared pool, java pool, large pool. Most probably your SGA is too big to fit into the shared memory configured on a kernel level.

    You can increase the shmmax = value.


    HTH,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

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