Re: Can SvrMgrl accept command-line parameters?

svrmgrl << xxx
connect internal
shutdown immediate
xxx

the above script will shutdown your database. If you have multiple instances then you will need to set your environment variables

one way to do this is

for i in `cat /etc/oratab` do
echo $i > /tmp/i
sed -e '/\:/d' < /tmp/i > /tmp/i1
read $ORACLE_SID < /tmp/i1
sed -e '/\:/d' < /tmp/i >/tmp/i2
read $ORACLE_HOME < /tmp/i2
./script (whatever you called script above done
John Haskins wrote:
>
> I'd like to create a shell script that, among other things, shuts down and
> then starts up database instances. No mention in the docs how to do this,
> and my experiments have proved fruitless. Is it possible, and if so, what's
> the syntax?
>
> Thanks.
Received on Tue Oct 19 1999 - 01:03:04 CDT