Use of TNSnames.ORA and possible alternatives in a mixed version environmen
827034Dec 28 2010 — edited Dec 28 2010Hello,
we have an environment with many Oracle databases in different versions (v8, V9, V10 and V11). Besides that, there are many versions of the Oracle Client in use, ranging from V6 to V11.
Many of the clients have a TNSnames.ORA and as was to eb expected, many of these are old as well with a lot of (by now) invalid information in there.
That's why I have the following questions:
Is there any reasonable maximum size to the TNSnames.ORA file?
What are the consequences from going over the max size?
Are there alternatives to using TNSnames.ora which you would recommend?
Many thanks!
Dries Bessels
Amsterdam, The Netherlands