Saturday, October 29, 2011

About TNSNames.ora

This is in continuation to my previous article where I mentioned about TNSNames.ora.
Again this is my understanding and am a beginner1. The Location where you would find tnsnames.ora file inside a oracle client directory is typically inside the NETWORK\ADMIN folder

2. In My case it is inside d:\oracle\product\11.2.0\client_1\NETWORK\ADMIN

3. This is one file that you should know to create if you want to create connections in SQL Developer client to databases in sever.

4. A sample copy of tnsnames.ora file will be available in the SAMPLE Directory. When in doubt copy paste it and make necessary modification to it

5. The various elements that should be understood in this file are as follows

No comments:

Post a Comment