Laurent Schneider

I have been using Vista for about 3 months and finally found a way to start my databases with a single click

The method I used until yesterday was a .BAT file that starts the services, I had then to right click on the shortcut, run as administrator, confirm the UAC warning. 3 Clicks. Way to much…

I have googled quite a lot and found Vista setuid - How to elevate without prompting

Ok, here we go :

1) run mmc
2) file - add snapin
3) Task Scheduler Library - Create Task
4) Name: startoracle
Run with highest privileges
Actions - New - Start a program - Program:net - Arguments: start OracleOraDb11g_home1TNSListener
Actions - New - Start a program - Program:net - Arguments: start OracleServiceLSC01
Actions - New - Start a program - Program:net - Arguments: start OracleServiceLSC02
…
5) create a batch file that runs : schtasks /run /tn startoracle

Same for stoporacle

It seems to work fine. Do not play too much with mmc if you do not know it. It is a powerful tool

This entry was posted on Monday, July 7th, 2008 at 10:05 and is filed under oracle, dba, vista, windows. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl