Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to execute sqlplus command in bat file ?

882532Nov 27 2011 — edited Nov 7 2012

Hello

I have a simple script file that looks like this:

"sqlplus admin/admin as sysdba
shutdown immediate"

But.. when i start this file.bat my system logs but do not make any script. Sqlplus just waiting for command, and when i write "exit" i logout from sqlplus, and then system execute next command, that is "shutdown immediate" but beyond sqlplus (so my base is still working). Is it at all possible to log on and execute commands from file.bat or some other way ?

I'm using oracle 11g, windows 7x64

Regards and thx for help

Edited by: 879529 on 2011-11-27 04:52

This post has been answered by Shivananda Rao on Nov 27 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2012

Added on Nov 27 2011

#11g, #general-database-discussions, #sqlplus, #windows

5 comments

32,855 views