UNIX for Dummies Questions & Answers

Hi,

I have written a small shell script which logs into each oracle database on the server and displays whether it is in archivelog mode or not.. The script is as under:


#!/bin/bash
dblist=`ps -ef | grep smon | grep -v grep |cut -d'_' -f3`
for ohome in $dblist; do
sqlplus -s /nolog << EOF
connect / as sysdba ;
ORACLE_SID=$ohome; export ORACLE_SID
set heading off
set feedback off
set verify off
output=`select log_mode from v$database;`
exit;
EOF
echo $ohome
echo $output | sort -u
done

When I run it .. i received errors as under:

jalpan.sh: select: not found
Connected.
SP2-0734: unknown command beginning "ORACLE_SID..." - rest of line ignored.
SP2-0042: unknown command "output=" - rest of line ignored.
bnkdbp01

jalpan.sh: select: not found
Connected.
SP2-0734: unknown command beginning "ORACLE_SID..." - rest of line ignored.
SP2-0042: unknown command "output=" - rest of line ignored.
dosdbp01 --> Oracle Database Name

Pls help

Thx in advance

1. is the ORACLE_SID line supposed to be before the sqlplus line?

2. Are the 'set x y' lines as part of the SQL*PLUS script supposed to have a ';' at the end?

3. The 'output', it looks like you are trying to assign in the SQL*PLUS script but have it magically read by the shell script.

Hi,

Reg your point 1 and 2 , you are correct. I did modify it and its working

Reg point 3. i removed ref to output variable and just kept select stmt and it worked

Thanks again for your guidance