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

Thread: Kill Inactive sessions

  1. 01-02-2002, 04:12 PM #1
    rshivagami
    rshivagami is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 01-02-2002, 04:30 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  3. 01-02-2002, 04:44 PM #3
    rshivagami
    rshivagami is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  4. 01-02-2002, 04:48 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not even as internal through svrmgrl?
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 01-02-2002, 05:26 PM #5
    rshivagami
    rshivagami is offline Senior Member
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Yes, I get 'Oracle not available' .
    Reply With Quote Reply With Quote
  6. 01-02-2002, 07:30 PM #6
    michaell
    michaell is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  7. 01-03-2002, 08:27 AM #7
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Cool kill session

    r u sure the session 9 is still runing.
    anandkl
    Reply With Quote Reply With Quote
  8. 01-03-2002, 07:38 PM #8
    michaell
    michaell is offline Junior Member
    Join Date
    Dec 2001
    Location
    Brisbane, Australia
    Posts
    28
    I believe he was issuing 'kill -9' Unix command instead of kill command in Oracle.
    Reply With Quote Reply With Quote
  9. 01-03-2002, 07:53 PM #9
    sambavan
    sambavan is offline Senior Advisor
    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!

    Reply With Quote Reply With Quote
  10. 01-03-2002, 08:10 PM #10
    rygi
    rygi is offline Junior Member
    Join Date
    Mar 2001
    Posts
    26
    Is it possible that you are trying to kill an Oracle/Background process?... that error seems odd.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width