Do I need to generate the tnsnames.ora file. How do I generate a tnsnames.ora file to connect to an Oracle Database? (where $ORACLE_HOME can be multiple. ORA-01008: not all variables bound. Variable and setting it's value multiple times is a. OracleConnection) Dim fs As IO.FileStream = New IO.
![Tnsnames Tnsnames](/uploads/1/2/4/1/124108177/725568052.jpg)
Howdy, My search fu is not working very well today. I did several searches and did not find an answer. I work for a.gov agency. We have folks who remotely connect and use the various Oracle products as well as other products that connect to Oracle (TOAD being one). What we are doing is instead of maintaining one master tnsnames.ora file (and putting up with the problems a corrupted one brings) is for each of us to have our own tnsnames.ora file. The remote access installed version of TOAD points to the tnsnames.ora file that OEM etc point to. Where can I go to change where TOAD points to the tnsnames.ora file?
I’ve been peeking/poking around but have not found that. I know about TNSADMIN, but if I remember correctly this info used to be part of TOAD also.
I've been trying to switch from the Oracle OCI driver to the thin driver, I got the thin driver to pickup my tnsnames.ora by adding -Doracle.net.tnsadmin=/path to the command line. However, our tnsnames.ora contains lines where multiple services are defined at once. They look like this: NEWS2,NEWS,NEWSFX = (DESCRIPTIONLIST=.) The OCI driver seems happy with this format, but the thin driver doesn't understand that those are 3 separate services NEWS2, NEWS and NEWSFX. Some painful debugging sessions have revealed that it thinks this is a single service named NEWS2,NEWS,NEWSFX. Our DBA's are understandably not very keen on copy-pasting service descriptors left and right, and insist that we find a way to be able to declare different names for the same service descriptor without copy paste before switching from OCI to thin. Is there a properly supported way to achieve this with the oracle thin driver?
PS: here's a post from a guy who is using that same feature, and also mentions that it is apparently undocumented.