Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

Donald K. Burleson

Oracle Tips

Distributing standard Oracle files to all Servers

In a large environment, the Oracle DBA must routinely distribute common files to all Oracle servers.  These common files include:

  • tnsnames.ora

  • sqlnet.ora

  • .profile for the Oracle UNIX user

This distribution can be a huge task for large Oracle shops with hundreds of Oracle servers. In UNIX, this is a super useful script that I use to distribute common files to all servers.  Note that 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

If you like Oracle tuning, you might enjoy my latest book “Oracle Tuning: The DefinitiveReference” by Rampant TechPress. (I don’t think it is right to charge a fortune for books!) and you can buy it right now at this link:

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

 

 

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 
 
email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.