If you have multiple oracle client installations (9i, 10g, 11i) on your box and don't want to configure tnsnames.ora for each oracle home, you can use tnsname sharing.
By sharing, you maintain 1 tnsnames.ora file and point all other tnsnames.ora (from all other home)
to the main file. Use ifile parameter to point to another location
example:
tnsnames.ora from 11i client will just have the following line. In this example it points to 10g client.
ifile=C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
No comments:
Post a Comment