Oracle does not Support Shared tnsnames.ora
SR Reply: "Well, technically there is no official support for UNC (Universal Naming Convention eg. \\path\file) in the tnsnames files. I have
seen customers try this and some manage to get it to work and some do not. My
tests have always lead to it not working so I personally do not believe those
that have claimed it worked when I used the same syntax and it
fails.
Officially we do not support it because the values used for UNC are restricted values.
See this link Specifically the //
Those are used by our coding logic for ezconnect connections therefore we have logic in place for those values to be used for a different purpose.
That is just one of the many reasons its not supported not the only reason just an FYI.
So I cannot really provide the proper syntax as it technically does not exist.
My apologies.
Also so you know technically we do not officially support shared tnsnames files on remote directories.
The ifile and even TNS_ADMIN was designed to handle multiple oracle homes on the same node. It was never intended or supported to work over a network. It does work under most circumstances but is not something we recommended or support. Shared usage over the network we suggest LDAP server as the intended feature to use."
Officially we do not support it because the values used for UNC are restricted values.
See this link Specifically the //
Those are used by our coding logic for ezconnect connections therefore we have logic in place for those values to be used for a different purpose.
That is just one of the many reasons its not supported not the only reason just an FYI.
So I cannot really provide the proper syntax as it technically does not exist.
My apologies.
Also so you know technically we do not officially support shared tnsnames files on remote directories.
The ifile and even TNS_ADMIN was designed to handle multiple oracle homes on the same node. It was never intended or supported to work over a network. It does work under most circumstances but is not something we recommended or support. Shared usage over the network we suggest LDAP server as the intended feature to use."
No comments:
Post a Comment