Shell Programming and Scripting

Dear All
Here is the details what i want to achieve from shell scripts
I have a sever where 5 databases are created. which i having diffrent SID's.
Now i want to execute some SQL queries on each one of the databases. (SQL Query is same).That i want to acheive via crontab
Now each one of the database have diffrent login.for that i have created one DBCONFG.cfg file.
Now i want to achive something like, when this script will excute trough crontab, it should take the Usernaem ,password from DBCONFIG.cfg file based on SID
and connect to the database and should execute the SQL Query.
COntent of DBCONFIG.cfg file
LCSCT1|sedba|se_dba123
ENCUPID|encdba|enc_dba123
CIPA|cipadba|cipa_dba123
BELLSOUTH|belldba|bell_dba123
.
.
.
Like this where 1st field is "SID",2nd field is "username" and third filed is "password"
Now it should take the username/password based on SID
And i can take the SID form oratab file like this
ORATAB=/var/opt/oracle/oratab
SID=`egrep -i ":Y|:N" $ORATAB | cut -d":" -f1 | grep -v "\#" | grep -v "\*"`
echo $SID
Please help me how can achieve this.

you can try something like this:

Code:

GetDetails ()
{
eval `awk -v sid="$SID" -F"|" '{ if ( $1 == sid ) { printf ("USER=%s\nPASS=%s\n", $2,$3) }}' cfg`
echo $SID;echo $USER;echo $PASS; echo ""
}
 
for SID in LCSCT1 ENCUPID CIPA BELLSOUTH
do
        GetDetails
        ## do what ever you want to do for each SID
done

output:

Code:

LCSCT1
sedba
se_dba123
 
ENCUPID
encdba
enc_dba123
 
CIPA
cipadba
cipa_dba123
 
BELLSOUTH
belldba
bell_dba123

Hi jhon

DBLIST=`egrep -i ":Y|:N" /etc/oratab | cut -d":" -f1 | grep -v "\#" | grep -v "\*"`
for DBNAME in $DBLIST
do
username=`grep $DBNAME DBCONFIG.cfg | cut -d "|" -f2`
password=`grep $DBNAME DBCONFIG.cfg | cut -d "|" -f3`
sqlplus -s ${username}/${password} <<EOF
select name from v\$database;
select sysdate from dual;
EOF
done

scripter