DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: ORA-09243: smsget: error attaching to SGA

  1. #1
    Join Date
    Mar 2001
    Posts
    52
    I got this error:

    ERROR: ORA-01034: ORACLE not available
    ORA-09243: smsget: error attaching to SGA
    OSD-04101: invalid SGA: SGA not initialized

    I restart the db but the same error

    Please advise

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Did you change any init.ora parameters since your db was last brought down? If so, you probably have an incompatibility with your init.ora and system configuration. If you're on unix, I would check your kernal params.
    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
    Aug 2000
    Location
    Shanghai
    Posts
    433
    It could be because of the SGA is set too large overload the
    system RAM .
    Boot you DB step by step ( before that count how much is your SGA :
    share_pool + block size * db block buffer

    My senior told me that it should not over 40% of the physical RAM .

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    I also once had this one cause the DB crashed, and the lkSID file was remaining in $ORACLE_HOME/dbs ... check that ...
    also you can do :
    ipcs -a | grep oracle
    and see if you still have a semaphore and memory segment attached to your instance

  5. #5
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    Check the following parameters in the init[SID].ora file :
    db_block_size
    db_block_buffers
    log_buffers
    shared_pool%%

    if these parameters are OK, try to startup (nomout) you DB.
    If you have the same problem, try : shutdown abort then startup nomount...


    Hope this helps

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Are you using Windows 2000/ NT ?
    I had this problem on windows platform which I could'nt resolve and had to reinstall Oracle. Fortunately, it was only personal Oracle on Home Computer.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  7. #7
    Join Date
    Mar 2001
    Posts
    52
    O/S is Windows NT
    I was able to restart the oracle. But I have to start manually Oracle services.
    And I still investigate what happened

    Thanks
    You are great

  8. #8
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Please let us know how you could manage to restart, what line of action you took.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check your trace files....


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #10
    Join Date
    Mar 2001
    Posts
    52
    1. From Alert log
    Tue Oct 30 18:30:18 2001
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT


    2.
    2.1 What I did on Wed Oct 31 I shut down and restart the db but even than I got the err
    ERROR: ORA-01034: ORACLE not available
    ORA-09243: smsget: error attaching to SGA
    OSD-04101: invalid SGA: SGA not initialized
    2.2 I checked the services and Oracle Db did not started so I started manually

    3.From Alert log
    Wed Oct 31 09:41:41 2001
    alter database “prod”mount exclusive
    Wed Oct 31 09:41:43 2001
    Successful mount of redo thread 1.
    Wed Oct 31 09:41:43 2001
    Completed: alter database “prod”mount exclusive
    Wed Oct 31 09:41:44 2001
    alter database “prod”open
    ORA-1116 signalled during: alter database “prod”open...

    I am not an expert as a DBA so could you have any idea what happened.
    Thanks

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