https://communities.sas.com/t5/SAS-Programming/How-use-tnsnames-in-SAS-Viya-LTS-2024-09-when-accessing-Oracle/m-p/967198#M376305 <P>Hi experts,</P> <P>&nbsp;</P> <P>SAS Viya LTS 2024.09 ships with an Oracle Client built into the SAS Viya deployment.</P> <P>I want to setup a CASLIB or a LIBNAME which points to an Oracle DB and I would like to define a <STRONG>tnsname</STRONG>&nbsp;(in tnsnames.ora) to be used in the <STRONG>path=</STRONG>&nbsp;option but I am not sure how to accomplish this. I don't even know where the tnsnames.ora file is and whether I should edit it.</P> <P>&nbsp;</P> <P>Thanks.</P> Thu, 22 May 2025 07:55:36 GMT EyalGonen 2025-05-22T07:55:36Z https://communities.sas.com/t5/SAS-Programming/How-use-tnsnames-in-SAS-Viya-LTS-2024-09-when-accessing-Oracle/m-p/967198#M376305 <P>Hi experts,</P> <P>&nbsp;</P> <P>SAS Viya LTS 2024.09 ships with an Oracle Client built into the SAS Viya deployment.</P> <P>I want to setup a CASLIB or a LIBNAME which points to an Oracle DB and I would like to define a <STRONG>tnsname</STRONG>&nbsp;(in tnsnames.ora) to be used in the <STRONG>path=</STRONG>&nbsp;option but I am not sure how to accomplish this. I don't even know where the tnsnames.ora file is and whether I should edit it.</P> <P>&nbsp;</P> <P>Thanks.</P> Thu, 22 May 2025 07:55:36 GMT https://communities.sas.com/t5/SAS-Programming/How-use-tnsnames-in-SAS-Viya-LTS-2024-09-when-accessing-Oracle/m-p/967198#M376305 EyalGonen 2025-05-22T07:55:36Z