Re: Scripts on HPUX

This forum is fine for that purpose.

What specific questions do you have?

Here's a korn shell script skeleton that can invoke sqlplus. You have to have appropriate os permissions of course to run something like this and many shops have policies regarding setup of jobs like these (perhaps only run thru a scheduling package or via authorized change control processes, etc).

#!/bin/ksh
#

. /u01/local/bin/.9isetenv
sqlplus /nolog <<EOF
connect / as sysdba

--
-- what do you need to do?
--
exit;
EOF

Heres another to invoke rman



#!/bin/ksh

#

. /u01/local/bin/.9isetenv
export ORACLE_SID=hardcode;
rman <<EOF
connect target sysdba_user/****@target
connect catalog rman_user/*****@recvcat
resync catalog;
EOF

What other kind of info do you need?