Shell Programming and Scripting

oracle@brookford:~> tnsping ora11gb|grep -i HOST

Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bovina.int.westgroup.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora11gb)))

awk -F"[)(]" '{sub(/.*=/,X,$6);print $6}'  Input_file

bovina.int.westgroup.com

sed 's/\(.*HOST=\)\([^)]*\)\(.*\)/\2/g'  Input_file

tnsping ora11gb | awk 'match ($0, /HOST=[^)]*/) {print substr ($0, RSTART+5, RLENGTH-5)}'
bovina.int.westgroup.com

tnsping ora11gb | sed -n 's/\(.*HOST=\)\([^)]*\)\(.*\)/\2/p'

SQL> select DESTINATION from v$archive_dest where target='REMOTE';

DESTINATION
------------------------------
ora11gb

SQL> select DESTINATION from v$archive_dest where target='REMOTE';

DESTINATION
------------------------------
ora11gb

1. login to server ( will login to server from a group of servers via script)
2.set the environment of database one by one in case of multiple databases
3.login to database 
4.change sys password
5.Look if the primary has a standby and grep hostname from tnsentry of standby
6. scp password file to standby

x= echo $i|cut -f1 -d':'

x=echo $i|cut -f1 -d':'

oracle@brookford:~> cat test_passwordcopy.sh
for i in `cat /etc/oratab|grep -v '^#'`
do
x= echo $i|cut -f1 -d':'
export ORACLE_SID=$x
echo $x
y= echo $i|cut -f2 -d':'
export ORACLE_HOME=$y
echo $y;
sqlplus / as sysdba<<EOF
select DESTINATION  into $z from v\$archive_dest where target='REMOTE';
EOF
echo $z;
done
oracle@brookford:~> ./test_passwordcopy.sh
./test_passwordcopy.sh: line 13: warning: here-document at line 9 delimited by end-of-file (wanted `EOF')
./test_passwordcopy.sh: line 14: syntax error: unexpected end of file
oracle@brookford:~>

x= echo $i|cut -f1 -d':'
y= echo $i|cut -f2 -d':'

x=`echo $i|cut -f1 -d':'`
y=`echo $i|cut -f2 -d':'`