Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Windows batch script to check if Oracle services have been  restarted

Posted on 2010-11-22
3
Medium Priority
?
816 Views
Last Modified: 2012-05-10

Hi experts,

I' m using Oracle 11G on Windows 98.  I need  several scripts to check  the Oracle Services on Windows.  My Oracle SID is ORCL and when  the Oracle  services are restarted  I want to be informed  with a message like ' OracleServiceORCL' s been started at time 17:00'  for instance.
The names of the services are ;
OracleServiceORCL, Oracle.jobSchedulerORCL, OracleORCLTNSListener and
Oracle ORCL VSS Writer Service.  

The message can be inserted into a variable.  I' ll link it with an e-mail script.


 
0
Comment
Question by:orcun_turkec
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
gatorvip earned 1500 total points
ID: 34196218
Are you looking for a different answer than the one here?

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Q_26631107.html
0
 

Author Comment

by:orcun_turkec
ID: 34202948

Yes,  In this script  I want to be informed when services are restarted.  But the link you sent is  about the script to check the services of which status is  stopped.  
0
 

Author Closing Comment

by:orcun_turkec
ID: 34391428
Thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
AutoHotkey is an excellent, free, open source programming/scripting language for Windows. It started out as a keyboard/mouse macros product, but has expanded into a robust language. This article provides an introduction to it, with links to addition…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question