Hi

I am new to the unix scripting world and really could do with some help.

I have written a basic unix script to do some monitoring of a oracle database.

I would like it to monitor about 10 different database. What i would like to do is list the database connection (with username, password, database sid, etc)

Below is what i have right now.

#!/bin/ksh
TEMP=temp.sql
TEMP1=temp01.sql
OUTPUT=/home/oracle/tony/space/report/space_report_$$
OUTPUT1=/home/oracle/tony/space/report/block_report

################################################## ##
# Space Report
################################################## ##
SPACE_REPORT () {
sqlplus -s ${list[0]}/${list[1]}@${list[2]} <<EOF > /home/oracle/tony/space/test_space.log.$$
@space_report_real.sql ${TEMP} ${OUTPUT} ${list[3]}
/
exit
EOF
}

set -A list username password GASD2.world 60

SPACE_REPORT
#########################################

If i want to add more databases to the list ie something like this

set -A list username password GASD4.world 60
set -A list username password GASD5.world 80
set -A list username password GASD6.world 65

how can i loop around to produce a report for each database

Thanks

Tony