startup and shutdown scripts(.exe)

[Natik]

can someone show me how to write a script in windows(.exe file) so that I can startup and shut down my sun databases just by clicking on it(.exe file).
Thanks

[davey23uk]

well that would be an executable - not a script.

Just write a script to connect to your database and startup - this assumes you are on 9i and using an spfile and you have remote authentication set up and the listener is running on the remote server

you script would contain


sqlplus /nolog
connect user/password@xxx as sysdba
startup
exit

must surely be easier to telnet to the machine and start it up from there