Kill Inactive sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Kill Inactive sessions

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    To kill an inactive session,
    kill -9 is not working -
    the error is - 'kill no such process'
    I am telnetting to Oracle 8.1.6.

    Any idea what is going on ??

    Thanks,
    Shiva.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You process has died, but your oracle thinks your session is still connected. Use ALTER SYSTEM KILL SESSION to kill from the DB.
    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
    Sep 2000
    Location
    VA
    Posts
    343

    No I cannot connect to the system, because there is a 'Maximum number of processes exceeded' error.
    So I will have to use some kind of external command like KILL...

    Shiva.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not even as internal through svrmgrl?
    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."

  5. #5
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Yes, I get 'Oracle not available' .

  6. #6
    Join Date
    Dec 2001
    Location
    Brisbane, Australia
    Posts
    28
    Is Oracle still running? Check the Oracle process like pmon. Did you setup ORACLE_SID before you run svrmgrl?

  7. #7
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Cool kill session

    r u sure the session 9 is still runing.
    anandkl

  8. #8
    Join Date
    Dec 2001
    Location
    Brisbane, Australia
    Posts
    28
    I believe he was issuing 'kill -9' Unix command instead of kill command in Oracle.

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To kill a unix process, you either have to be the root, owner or a group member. Be one and try issuing the kill -9 PID

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  10. #10
    Join Date
    Mar 2001
    Posts
    26
    Is it possible that you are trying to kill an Oracle/Background process?... that error seems odd.

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