shellscript fails calling Oracle svrmgrl

From: MMP Wolfgang Rupp <wolfgang.rupp_at_mm-packaging.com>
Date: Fri, 15 Jun 2001 10:54:13 +0200

We have a weird problem here. Our dba created a shell script to
make hot backups of the Oracle 8.1.6.1 db. First it extracts
some table data and writes them into a file (_at_auto_backup_out,
see below). On AIX, the script works. On Tru64, if the steps
are done manually as user oracle, it works. As the shell script,
it "connects internal" and then blows up with Oracle "03113 end
of communications channel".

#!/bin/ksh
--[snip environment setting]--
echo "Doing Hot Backup! -------------------- `date`"
$ORACLE_HOME/bin/svrmgrl <<EOF_SQL
connect internal
_at_auto_backup_out
EOF_SQL
--[rest of backup script]--

Since it does work on AIX and manually on Tru64, I assume a
Tru64 or a shell problem. Any ideas?

Wolfgang Rupp
Network Administrator
Mayr-Melnhof Packaging GmbH
Floragasse 7/6
A-1040 Wien
Tel: +43-1-50257-238
Fax: +43-1-50257-260
Received on Fri Jun 15 2001 - 08:56:24 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:42 NZDT