Re: pass multiple commands to svrmgrl

If you're using Unix, try creating and running a script something like this:

svrmgrl <<EOF
connect internal
startup open pfile=initsid.ora
SQL command here;
!host command here
@run_sql_file_here
other miscellaneous good stuff here
exit
EOF If you're going to run it from a cron job, don't forget to set up all of your environment variables.

Nadolig Llawen a Blwyddyn Newydd Dda

Nick

<shdu_at_my-deja.com> wrote in message news:921rn5$rf4$1_at_nnrp1.deja.com...
> How do I pass multiple commands to svrmgrl? I need to do this to invoke
> svrmgrl in a script that does several other things in addition to
> starting database.
>
> What I want to do is something like this:
>
> --other scripts
> svrmgrl command="connect internal; startup open; exit"
> --more scripts
>
> but the svrmgrl does not take simicolumn or new line delimited
> commands.
>
> Is there a way to do such thing with svrmgrl?
>
> Thanks in advance.
>
> SF
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Dec 23 2000 - 05:24:27 CST