Wednesday, January 26, 2011

Scheduling TNS Names for Auto Refresh

1. Create a batch file to copy the TNS names form Common Location

2. Save this file to a location on local.




3. Schedule it with Windows "Scheduled Tasks"


---------------------------------
@echo off
setlocal
REM Copy tnsnames.ora from x:\batch to d:\oracle...  Execute weekly or as needed updates are identified.
copy /v /y file://ad.xxxx.com/whq/CorpApps/BATCH/tnsnames.ora D:\oracle\tnsnames
endlocal
echo on
---------------------------------

No comments:

Post a Comment