some kind of teriffic tool you have. I only have found out about a cute little ‘problem’.
When connecting to a Oracle 9 database at some point you need to enter the details of the connection. But then it appeared: ‘Not able to load net service names. File tnsnames.ora not found.’ The detail of this error told me there was no tnsnames.ora in a particular directory ( [oracle install]\network\admin) when I copied our company wide tnsnames.ora to that directory and restarted the proces it found teh tnsnames.ora and all is working well now.
Now my question is the following: Is it possible to make TDM follow the registry key tns_admin in the chosen oracle HOME? And then, when there is no such key, search for the tnsnames.ora in the install dir of that HOME?
This is the procedure Oracle follow themselves too. The advantage of the company wide tnsnames.ora are obvious. With daily showing up new and deleting old entries in this tnsnames.ora you are being forced to make a renewed copy of ths file every now and then (with the hassle of forgetting to do so).
Thanks in advance for your answers.
Gr. Gerben de Vries