TNS Configuration files – Search order

Oracle clients (and programs that use Oracle clients/drivers) will search for TNS configuration files such as sqlnet.ora and tnsnames.ora in the following order.

Note that the first file to be found will be used -- so if there were files

Read More

Starting a Batch (DOS) file minimized

In my article How to backup your Evernote notes regularly I supplied a windows batch file that could be used with the Windows Scheduler to automatically backup your Evernote Notes. In use, however, it soon becomes annoying that the scheduler launches a DOS window to run the script right in the middle of the screen. This article documents the technique for running a batch file minimized to the taskbar. Read More

Logging PuTTY sessions

As a DBA, it is generally a good idea to log all your activity when working on Unix/Linux servers. Logging provides an audit of changes that you have made to a system as well as being a valuable resource for notes and documentation. This article describes how to log all PuTTY sessions and how to automtically maintain the resulting logfiles in a logical directory structure. Read More