Shell Programming and Scripting

for Db in `cat /var/opt/oracle/oratab |egrep -v "ASM" |grep -v \# |cut -d\: -f1`
do
{
export ORACLE_SID=$Db
$ORACLE_HOME/bin/sqlplus -s /nolog <<EOF
connect / as sysdba
....
....
exit
EOF
}
done

for Db in $(awk -F: '!/ASM|#/ {print $1}' /var/opt/oracle/oratab)

for Db in `cat /var/opt/oracle/oratab|cut -d\: -f1`do{export ORACLE_SID=$Db$ORACLE_HOME/bin/sqlplus -s /nolog <<EOFconnect / as sysdba........exitEOF}done

awk -F: '!/ASM|#/{print $1}' /var/opt/oracle/oratab | xargs -I% -P5 bash -c './sql_script %'

#!/bin/bash
export ORACLE_SID=$*
$ORACLE_HOME/bin/sqlplus -s /nolog <<EOF
connect / as sysdba
....
....
exit
EOF

       -P max-procs
              Run up to max-procs processes at a time; the default is 1.  If max-procs is 0, xargs will  run
              as  many  processes  as  possible at a time.  Use the -n option with -P; otherwise chances are
              that only one exec will be done.

for Db in `grep -v \# /etc/oratab|cut -d\: -f1|egrep -v "+ASM"`
do
export ORACLE_SID=$Db
sqlplus -s /nolog <<EOF
connect / as sysdba
startup
exit
EOF
done