Solved

Windows batch script to check if Oracle services have been  restarted

Posted on 2010-11-22
3
808 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

635 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