Solved

Windows batch script to check if Oracle services have been  restarted

Posted on 2010-11-22
3
802 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

713 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