Shell Programming and Scripting

 
#!/bin/bash
set -x

#variables
dbs="database"
 
which sqlplus > /dev/null 2>&1
if (( $? > 0 ))
then
   export ORACLE_HOME="/l01/apps/oracle/soa_as_1"
   export PATH=$ORACLE_HOME/bin:$PATH
fi
 
#loop through the database and confirm accessibility to SOA 11g
for dbinst in ${dbs}
do
        if [ ${dbinst} == "database" ]; then prefix="dev"; password="password"; fi
 
sqlplus orawsm/${password}@${dbinst} <<EOF
select service_wsdl_url from services
where service_status = 'A';
EOF
 
echo "Done"
 
done

 
#!/bin/bash
set -x
 
#variables
dbs="ixabc101 ix123101"
 
which sqlplus > /dev/null 2>&1
if (( $? > 0 ))
then
   export ORACLE_HOME="/l01/apps/oracle/soa_as_1"
   export PATH=$ORACLE_HOME/bin:$PATH
fi
 
#loop through the database and confirm accessibility to SOA 11g
for dbinst in ${dbs}
do
    if [ ${dbinst} == "ixabc101" ]; then prefix="dev"; password="abc11g"; fi
    if [ ${dbinst} == "ix123101" ]; then prefix="test"; password="12311g"; fi
 
#run sql query against database
echo "Now running WSDL validation for ${dbinst}..."
sqlplus orawsm/${password}@${dbinst} <<EOF
    set heading off;
    set feedback off;
    set pagesize 0;
    set newpage 0;
    select service_wsdl_url from services
    where service_status = 'A';
EOF
 
echo ${URL}|sed s/8001/8142/|xargs
 
if (( $? == 0 )); then echo "VALID";
else
    echo "NOT VALID";
fi
done