OraFAQ Forum: Windows » Oracle 9i simulating a windows service crash

Home » Infrastructure » Windows » Oracle 9i simulating a windows service crash

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i simulating a windows service crash [message #388443]

Tue, 24 February 2009 15:14

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

Report message to a moderator

Re: Oracle 9i simulating a windows service crash [message #388465 is a reply to message #388443]

Tue, 24 February 2009 23:36

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle 9i simulating a windows service crash [message #388597 is a reply to message #388443]

Wed, 25 February 2009 10:36

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.

Report message to a moderator

Re: Oracle 9i simulating a windows service crash [message #388601 is a reply to message #388597]

Wed, 25 February 2009 10:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why not using "net stop" to stop the service?

Regards
Michel

Report message to a moderator

Re: Oracle 9i simulating a windows service crash [message #388605 is a reply to message #388443]

Wed, 25 February 2009 11:28

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.

Report message to a moderator

Re: Oracle 9i simulating a windows service crash [message #388618 is a reply to message #388605]

Wed, 25 February 2009 12:22

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is a totally different question.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 22:48:41 CDT 2025