HELP:shutdown startup/too many processes
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: HELP:shutdown startup/too many processes

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi gurus,
    I first get a too many processes message when I try to connect.

    I raised the processes parameter...

    Then,
    SVRMGR> shutdown immediate
    ORA-01034: ORACLE not available
    SVRMGR> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first

    What do I do?

    This is urgent..my db is down!
    Hemant

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    If you are running o unix. Try running

    /usr/proc/bin/ptree

    and it may return ALOT of processes such as the following...

    26694 oracleCFA (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

    In startup, init.ora, you scecifiy how many process Oracle may keep running at anyone time. In your case, when you try and log in, Oracle senses you trying to exceed this and returns the error you are seeing.

    You are going to have to manually kill at least one process, before you can log in.

    The big question is WHY is it occuring. I have this issue currently, we are running a Websphere front end, and webphere keeps the Oracle processes alive if somebody drops out of Websphere, which is a real pain in the butt, because it means websphere has to be manually stopped and restarted periodically in order to release the Oracle processess. You may be having a similer issue.

    Hope this helps.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    Thanks John

    Thanks John,
    You gave me exactly what I needed!

    Cheers!
    Hemant

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When you, issue the shutdown immediate and still if you see oracle not available, then it would be the time to just abort the oracle instace through shutdown abort...

    SVRMGR> shutdown immediate
    ORA-01034: ORACLE not available
    SVRMGR> shutdown abort
    SVRMGR> startup mount
    SVRMGR> recover database
    SVRMGR> alter database open;


    This would be the way to go...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You can try one more thing.

    In this situation.

    STARTUP FORCE

    Will start the database ignoring the earlier errors.

    Kishore
    Thanks
    Kishore Kumar

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    This is quiet unsafe!!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    It is quite a risky game to startup force :-) If you then get the 1019 error, you'll need to manually remove the old SGA.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I think itīs ok if you do

    alter system checkpoint
    startup force
    shutdown immediate
    startup

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I once played the game of startup force and got into trouble... Its not worth the trouble that you have to go through to get it back if it goes wrong!!!

    This is my personal opinion. I would take a long shot and save time....

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #10
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Ahhh guys.... it was the number of processes running on the server. It wouldn't mater what shutdown method you used, if the number of processes have maxed out, you wouldn't be able to connect to do any on that until you kill one of the Dedicated Oracle processes in the background..

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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