Issue setting environment variable that points to smb

mojaveoraclesmb

Can someone tell me the proper syntax for setting an environment variable that points to a smb volume directory?

What I have tried so far:

TNS_ADMIN=/Volumes/abc
TNS_ADMIN=smb://servername/abc
TNS_ADMIN=/servername/abc

Additional info, I have Oracle InstantClient installed and I'm trying to use SQLPlus. Except, the connection file I need is located in the shared directory located in the aforementioned smb volume. I'm trying to set the environment variable (TNS_ADMIN) such that it points Oracle to look at the smb volume, where the file is located. Nothing appears to work. Looking for guidance on what the proper syntax should be on setting an environment variable that points to a smb volume. Hope that makes sense.

Best Answer

  • Open Terminal
  • Open Finder and navigate to the folder containing the connection file
  • Drag&drop tns_names.ora into the Terminal window

The path shown is the value you need.

Related Question