Page 1 of 1

batch file to startup oracle database, STUCK!

Posted: 08 Sep 2007 12:29
by shivek.sachdev
hey,
im tryin to write a batch file to startup the oracle database

the normal procedure would be:


in C:, start sqlplus/nolog
u come across the "sql>" prompt
and using the command "connect as sysdba"
it will ask for the user-name and password
and then u can startup using the "startup" command

so the step by step procedure would be:

sqlplus/nolog
connect as sysdba
sysdba
oracle
startup

i tried creating and executing a batch file to satisfy the above task
but it stops after starting sqlplus/nolog

donno y... please help me out