Home » Infrastructure » Windows » Oracle 9i simulating a windows service crash
Oracle 9i simulating a windows service crash [message #388443] Tue, 24 February 2009 15:14 Go to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Hello all,

I know this may be a bit fetched... I am trying to simulate a windows service crash in order to test a debug diagnostic software ( debug diagnostic ) on our W2003 server.

We have been experiencing random crashes of the windows Oracle service and I am trying to evaluate if this debug tool is will work for diagnosing my issue.

My question is how I can make the windows process crash via a db script which will eventually halt the DB.

Any ideas? much appreciated.

J
Re: Oracle 9i simulating a windows service crash [message #388465 is a reply to message #388443] Tue, 24 February 2009 23:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can execute an OS command from PL/SQL (search for this here or on AskTom).
You have OS command to kill a process or stop Windows (search for this on Windows help or forum).
Combine the 2.

Regards
Michel
Re: Oracle 9i simulating a windows service crash [message #388597 is a reply to message #388443] Wed, 25 February 2009 10:36 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Ok I killed a background process with orakill which lead to the db falling but not the service Sad

Therefore not allowing me to test the tool.
Re: Oracle 9i simulating a windows service crash [message #388601 is a reply to message #388597] Wed, 25 February 2009 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why not using "net stop" to stop the service?

Regards
Michel
Re: Oracle 9i simulating a windows service crash [message #388605 is a reply to message #388443] Wed, 25 February 2009 11:28 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
It seems that if the service doesn't crash abnormally the MS tool doesn't create a dump file.

I even tried taskkill /F /PID <oracleprocess>

We are just trying to determine why the oracle service just halts on our prod server without creating any logs.
Re: Oracle 9i simulating a windows service crash [message #388618 is a reply to message #388605] Wed, 25 February 2009 12:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is a totally different question.

Regards
Michel
Previous Topic: Configuring Oracle 10G Express Client on win XP
Next Topic: service Database Control on Windows
Goto Forum:
  


Current Time: Fri Mar 29 09:49:54 CDT 2024