A sql script to startup and shutdown all Oracle services
<p>How to write a script which will startup and shutdown all Oracle services?
I need to save it as service.sql and run it from sqlplus as @service.sql</p>

<p>I can do it from sqlplus just typing :</p>

<pre><code>shutdown normal;
startup
</code></pre>

<p>but when I put these 2 commands to a sql file and run it as SYSTEM. I get these error:</p>

<pre><code>SQL&gt;@service.sql
ORA-01031: insufficient priveleges
ORA-01031: insufficient priveleges
</code></pre>

<p>I know I can do it using batch file but i have to do it using only sql and the OS is windows 7. </p>