Hello Team! Hope everyone is doing alright.
I followed the steps provided in this topic [https://community.easymorph.com/t/connecting-to-oracle-database/530\] and I was indeed able to make a TNS connection to work. Nice
However, I have a couple of questions for when we have TNS_ADMIN environment USER-only variable set.
Consider the snapshot:
From it, we can see that there are two TNS_ADMIN environment variables defined:
• one is USER-only variable, and it points to a network path. Said path contains the Company's DATA_SOURCES' connections definition (a tnsnames.ora file), which is maintained by the relevant Team;
• the other is a SYSTEM variable, and it points to a local path. Said path can only be reached/accessed by admin users - which us, regular users, are not.
-- That said, I am unsure if there is or there is not a tnsnames.ora file there, nor contents of it. Not even replace the existing file (if any) by the one that exists on that good network path.
-- Hence we create a TNS_ADMIN user-only variable.
Questions:
(1) Can I make use this USER-only TNS_ADMIN environment variable when setting up ORACLE TNS connectors on EasyMorph?
(2) Does EasyMorph looks into environment variable at all when assessing TNS connection types?
Context:
The questions arise because when I try to setup an ORACLE TNS connector, it only works if a DATA SOURCE variable is added, as suggested by that post (the link above)
In another words, using the same credentials (user and pass) and NETWORK_ALIAS, I can only successfully connect if I have the DATA SOURCE variable set on EasyMoprh, even if the DATA SOURCE variable content is a direct CTRL+C>CTRL+V from the tnsnames.ora file that the user-only TNS_ADMIN variable points to.