ss

Oracle Tips by Burleson

Copy tnsnames.ora to all UNIX Servers

This is a super useful UNIX command snippet to distribute common files to all servers. As we have noted, this script requires the .rhosts setup to allow the UNIX rcp and rsh commands.

#!/bin/ksh

echo 'starting distribution of tnanames.ora'

# Note: dbnames file is in the form HOST DATABASE
for host in `cat dbnames|awk '{ print $2 }'`
do
db=`cat dbnames|awk '{ print $1 }'`
echo starting distr to $host
rcp -p tnsnames.ora $host:/etc/tnsnames.ora
rsh $host ls –al /etc/tnsnames.ora
done

Note that this script uses a driving file called dbnames that contains a list of hostname and database name pairs. Here is a sample of this file.

dioneges mysid1
dioneges prod9i
dioneges testm1
praetor test9i
praetor testapps
praetor prodapps

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA