topic Re: Shell script problem in Operating System - HP-UX

Shell script problem

Logan Ramasamy_1 — Thu, 28 Aug 2003 19:38:08 GMT

I wrote the following script:
#!/bin/ksh
. /u01/app/oracle/.profile
TODAY=`date +'D%y%m%d.T%H%M%S'`
ORACLE_HOME=/u01/app/oracle/product/9.2.0
PATH=$ORACLE_HOME/bin
ORACLE_SID=TTWB
/bin/mkdir /u29/backup/ARC"$TODAY"
/bin/chmod 755 /u29/backup/ARC$TODAY
ARC_FILE=/tmp/archive.$TODAY.lst
/usr/bin/compress /u25/arch/*
$PATH/sqlplus /nolog <connect sys/ttwbsys as sysdba
archive log stop;
!/bin/cp -R `/bin/cat $ARC_FILE` /u29/backup/ARC$TODAY

It gave the following error:
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 28 16:33:43 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> Connected.
SQL> ORA-00250: archiver not started
SQL> then: then/endif not found.
Usage: cp [-f|-i] [-p] [-S] [-e warn|force|ignore] source_file target_file
cp [-f|-i] [-p] [-S] [-e warn|force|ignore] source_file ... target_directory
cp [-f|-i] [-p] [-S] -R|-r [-e warn|force|ignore] source_directory ... target_directory

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production

If I rewrite the script as follow:

#!/bin/ksh
. /u01/app/oracle/.profile
TODAY=`date +'D%y%m%d.T%H%M%S'`
ORACLE_HOME=/u01/app/oracle/product/9.2.0
PATH=$ORACLE_HOME/bin
ORACLE_SID=TTWB
/bin/mkdir /u29/backup/ARC"$TODAY"
/bin/chmod 755 /u29/backup/ARC$TODAY
ARC_FILE=/tmp/archive.$TODAY.lst
/usr/bin/compress /u25/arch/*
$PATH/sqlplus /nolog <connect sys/ttwbsys as sysdba
archive log stop;
exit
/bin/cp -R `/bin/cat $ARC_FILE` /u29/backup/ARC$TODAY

It does not do the last line at all. Help please.

Re: Shell script problem

John Dvorchak — Thu, 28 Aug 2003 19:44:54 GMT

It doesn't do the last line because you have and "exit" as the next to the last line. When the script hits that exit command, it exits without further processing.

Re: Shell script problem

Steven E. Protter — Thu, 28 Aug 2003 19:46:16 GMT

The last line in the second script does not execute because of the exit right above it.

Replace the exit with this

EOF

Then it will work.
#!/bin/ksh
. /u01/app/oracle/.profile
TODAY=`date +'D%y%m%d.T%H%M%S'`
ORACLE_HOME=/u01/app/oracle/product/9.2.0
PATH=$ORACLE_HOME/bin
ORACLE_SID=TTWB
/bin/mkdir /u29/backup/ARC"$TODAY"
/bin/chmod 755 /u29/backup/ARC$TODAY
ARC_FILE=/tmp/archive.$TODAY.lst
/usr/bin/compress /u25/arch/*
$PATH/sqlplus /nolog <connect sys/ttwbsys as sysdba
archive log stop;
EOF
/bin/cp -R `/bin/cat $ARC_FILE` /u29/backup/ARC$TODAY

SEP

Re: Shell script problem

Steven E. Protter — Thu, 28 Aug 2003 20:06:09 GMT

Don't point my previous post. Here is acorrected version. Leave the exit alone.

The last line in the second script does not execute because of the exit right above it.

Then it will work.
#!/bin/ksh
. /u01/app/oracle/.profile
TODAY=`date +'D%y%m%d.T%H%M%S'`
ORACLE_HOME=/u01/app/oracle/product/9.2.0
PATH=$ORACLE_HOME/bin
ORACLE_SID=TTWB
/bin/mkdir /u29/backup/ARC"$TODAY"
/bin/chmod 755 /u29/backup/ARC$TODAY
ARC_FILE=/tmp/archive.$TODAY.lst
/usr/bin/compress /u25/arch/*
$PATH/sqlplus /nolog <connect sys/ttwbsys as sysdba
archive log stop;
exit;
EOF
/bin/cp -R `/bin/cat $ARC_FILE` /u29/backup/ARC$TODAY

SEP

Re: Shell script problem

Logan Ramasamy_1 — Fri, 29 Aug 2003 12:24:24 GMT

Thanks SEP. exit and EOF worked perfectly. I ahve been struggling with this for a while. Hats off.