Re: automating shutdown,startup??

Write your commands into a script and use it as the input from command line. Example :

        $ svrmgrl < your_script_file

You can also use this method from a script shell :

#!/usr/bin/ksh
#

	echo Here's the shell
	#
	# call svrmgrl and read commands until EOF
	# EOF (or any other word) must be at the beginning of the line
	#
	svrmgrl << EOF
		connect internal
		shutdown
EOF
	echo Back to the shell

Jason Berryhill <speck_at_ecst.csuchico.edu> wrote:

>Hello all--
 

>I would like to be able to automate shutdown, backup, and restart of my
>db from witin a cron job.
 

>Here is my specific question ==> how do I run a script from the command
>line with server manager in line mode? The documentation I have does not
>mention how to do this (at least I haven't found it yet).
 

>Environment ORACLE 7.3.2.3.0 Have Server Manager but NOT sqldba
>Running on HP-UX 10.20 box.
 

>Thank you very much in advance.
 

>Jason Berryhill
 

>====================================================================
>=Web Site: http://www.ecst.csuchico.edu/~speck =
>=email: speck_at_ecst.csuchico.edu or jasonb_at_stormnet.com =
>= =
>= BASIS Support Team =
>= ORACLE DBA =
>= College of Business =
>= California State University, Chico =
>= =
>= And He looked up and saw the rich putting their gifts into the =
>=treasury. And He saw also a certain poor widow putting in two =
>=mites. So He said, "Truly I say to you that this poor widow has =
>=put in more than all; =
>= For all these out of their abundance have =
>=put in offerings to God, but she out of her poverty put in all =
>=the livelihood that she had." =
>====================================================================

--
TRF