Replace all tnsnames.ora files with a single master file using TNS_ADMIN

Maintaining large numbers of client tnsnames.ora files is a pain.  Oracle Internet Directory is the recommended solution to this, but it is not an easy exercise to set up or migrate to. An easier alternative is to set TNS_ADMIN in all client PCs to use a single common tnsnames.ora file set TNS_ADMIN=\\network\share\path All the client PCs […]

Read More Replace all tnsnames.ora files with a single master file using TNS_ADMIN
December 9, 2013

Copy mirror files with robocopy rsync lftp

The best utilities to use when copying/mirroring/backing up files are: robocopy – Windows rsync – Linux lftp – Linux without setting up password-less ssh Scripts can supply a password to sftp using lftp like this: lftp -u user:password sftp://server.domain.com << END_LFTP put /directory/file.txt quit END_LFTP You can set up password-less ssh this way.

Read More Copy mirror files with robocopy rsync lftp
December 9, 2013