Oracle.exe and WinNT/Win2k
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Oracle.exe and WinNT/Win2k

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Oracle.exe and WinNT/Win2k

    Hello,
    I have a Winnt Server with 5 Oracle 8.1.6 databases. Today, I attempted to shutdown a database from the Winnt services and the service just stalled. Oracle Alert log just stated that the database was shutting down but it didnt completely come down. I waited about 5 minutes then I wanted to just perform a shutdown abort but I was unable to even connect to database via connect internal because I was getting tns errors. Next thing, i thought was kill the Oracle.exe.
    Since there were 5 Oracle.exe I didnt know which one to kill and how to identiffy the Oracle.exe with the service name or database. Does anbody know how to identified Oracle.exe with Service names or instance names?

    Oracle.exe eventually died but that took 45minutes. In an emergency i need to know to get that resolved. In unix we can kill the Oracle processes but here in NT I cant even identify which Process is which and I am not referin to Oracle threads buyt Oracle.ex Process in Win task manager.

    -Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    ORAKILL is run from the Command Prompt in the following syntax:
    C:> orakill sid thread
    where:
    sid is the Oracle instance to target
    thread is the thread id of the thread to kill

    Note: You can display the syntax of most Oracle executables by typing the executable name at the command prompt with no options. To find the thread id consuming most of the CPU, the NT Resource Kit offers QuickSlice (QSLICE.EXE) which shows individual threads within a given process. (Refer to the NT Resource Kit for instructions on how to use QSLICE.)

    If you do not have QSLICE, you can run the following query within a SQL*Plus session connected as a DBA user:
    select p.spid THREADID, s.osuser, s.program
    from v$process p, v$session s
    where p.addr=s.paddr;

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    STECAL,
    thanks for the response. but as you must have read that I was unable to connect to svrmgrl because I was getting the tns unable to connect to destination since the service was down. How can i identified which Oracle.exe is tied to which database?
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Of course. No QSLICE? No matter. There is an answer at dbaclick now.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    In such cases u have much easier way to do.
    Go to control panel > Services (NT).

    Stop the service of the instance u wish to (right click & stop).
    This is as good as SHUTDOWN abort.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by abhaysk
    In such cases u have much easier way to do.
    Go to control panel > Services (NT).

    Stop the service of the instance u wish to (right click & stop).
    This is as good as SHUTDOWN abort.

    Abhay.
    Not necessary.... this one depends on the registry value
    ORA_DBID_SHUTDOWNTYPE

    if its value is set to i, the stopping of the database from services will do a shutdown immediate...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by adewri
    Not necessary.... this one depends on the registry value
    ORA_DBID_SHUTDOWNTYPE

    if its value is set to i, the stopping of the database from services will do a shutdown immediate...
    adewri :

    Thas correct........ it does depend on registery value of ORA_DBID_SHUTDOWNTYPE.......need to set 'a' if u want abort.....right?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Guys,
    I ended up finding the answer after all on the metalink. I searched for it but didnt find it initially. here it is.
    Doc ID: Note:1014773.102
    Subject: HOW TO MATCH WINDOWS NT PROCESS ID TO AN ORACLE INSTANCE


    thanks for your help anyways.
    "High Salaries = Happiness = Project Success."

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    That was/is the answer posted for you at dbaclick.com. Yesterday afternoon.

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