Working in an environment where new Development and Test Oracle databases are created on a routine basis means I tend to maintain my own local copy of tnsnames.ora and sqlnet.ora.
People working in other locations then tend to send you new entries in an email or even their complete tnsnames files. You can then end up trying to do a patchwork job of adding their entries into your own file.
I consider myself reasonably knowledgeable in such things and rarely have a problem but got into a tangle when I added a new entry and started getting TNS-12533: TNS:illegal ADDRESS parameters
Fiddling around with tnsping and surfing Oracle forums led me to the conclusion that there was a typo or bracket missing somewhere. But then I read someone make a fairly valid point, which was to use the actual editors provided by Oracle!
Although I knew they existed, I rarely use them. But by using 'Net Manager' in the 'Configuration & Migration Tools' section of your Oracle Client install you can effectively manage both the sqlnet and tnsnames file. (Obviously this isn't exactly news to most Oracle Pros!).
When I initially used it to open my tnsnames file, it showed no entries in the Service Naming section which confirmed there was some sort of corruption. I ended up re-adding the entries using the editor and hey presto - all worked fine!
No comments:
Post a Comment
Would love to get feedback on any of my posts.