Start Oracle in Vista with one click
Monday, July 7th, 2008I 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
