Re: svrmgrl command line?

chengchisang_at_hotmail.com wrote in article <871251285.14959_at_dejanews.com>...
> Hello,
>
> I need to shutdown the database through running a script. I realize that
> svrmgrl is an interactive tool. Is there a way I can shut it down from a
> script (sh or perl)? The Server Manager Reference is not included in my
> installation. Thanks for your help!

Try the following UNIX shell script:

---
svrmgrl << EOF
  connect internal;
  shutdown $1;
  exit;
EOF
---

where the optional parameter can be immediate or abort. You can also add
checks and stuff to the script. I often have the problem of rogue processes
being left behind after the shutdown. In such a case you can do a grep on
oracle processes and kill them (just don't go and kill the listener by
accident). :-)

regards,
Billy