DB doesn't startup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: DB doesn't startup

  1. #1
    Join Date
    Mar 2001
    Posts
    188

    Unhappy

    Hey Guys,
    i have a small problem. I want to start our db on a sun solaris ultar80 with solaris2.7.
    I connect me as internal at sqlplus. Then i make a startup and after that the error occurs:
    ORA-27102 out of memory
    SVR4 Error:22:Invalid argument
    Then i look after the error ORA-27102
    and i should consult the trace file for details:
    i looked after all the trace-files but there are no. So i controlled our init.ora if the all path are right. All is right.
    Whats now.
    Thanks for help
    Thomas Schmidt
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You either need to adjust your kernal parameters or reduce your memory parameters in the init.ora.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Posts
    188
    But way i thake round about 50MB from the ram and with top i can see that there are 831MB RAM are free. Why memory problems

    Thomas Schmidt

    [Edited by tomate on 08-21-2001 at 10:06 AM]
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    hello

    try this export ORACLE_SID=my oracle sid

    then try svrmgrl>>

    regards
    hrishy

  5. #5
    Join Date
    Mar 2001
    Posts
    188
    hey hrishy,
    the oracle_sid is set:
    I think the error from thre next line says more but i don't know what this mean:
    Here the line again:
    SVR4 Error:22:Invalid argument

    Thanks for help
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  6. #6
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    On SQL/Plus after connecting as internal try to start the db in steps to narrow down the problem --

    SQL> startup nomount;

    SQL> alter database mount;

    SQL> alter database open;

    and then post the exact error message and what stage it comes at.

    - Rajeev
    Rajeev Suri

  7. #7
    Join Date
    Mar 2001
    Posts
    188
    Hey rsuri,
    this have i make as one of my first steps:
    The error is the same after i connect to sqlplus or svrmgrl as internal and i make startup mount the error occurs:
    ORA-27102 out of memory
    SVR4 Error:22:Invalid argument

    This is a very good joke from oracle, that there is no more information.
    Do you know more

    Thanks
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  8. #8
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    As Jeff mentioned, you need to lower your memory parameters, could you post the following parameters from the init.ora file --

    db_block_buffers
    shared_pool_size
    db_block_size

    - Rajeev
    Rajeev Suri

  9. #9
    Join Date
    Mar 2001
    Posts
    188
    db_block_buffers = 5000 and this is reduced from me from 9746
    shared_pool_size = 26613760
    db_block_size =8192

    But i think the parameters are all right or??

    Thanks very much for the help
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by tomate

    This is a very good joke from oracle, that there is no more information.
    It's not an Oracle error, it's an OS error. This is why Oracle can't give you any more information...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width