topic SAS server with oracle interface in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/SAS-server-with-oracle-interface/m-p/673676#M19582 <P>Hi ,</P><P>&nbsp;</P><P>I have got a error to connect oracle data base .</P><P class="x_xmsonormal"><SPAN>ERROR: ORACLE connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.</SPAN></P><P class="x_xmsonormal"><SPAN>ERROR: Error in the LIBNAME statement</SPAN></P><P class="x_xmsonormal"><SPAN>I am very new to SAS administration .So any one guide me how to resolve this error.</SPAN></P><P class="x_xmsonormal"><SPAN>I need some knowledge how oracle database and SAS is connected .</SPAN></P><P class="x_xmsonormal">Thanks ,</P><P>Ashee</P> Fri, 31 Jul 2020 11:49:00 GMT Ashee 2020-07-31T11:49:00Z SAS server with oracle interface https://communities.sas.com/t5/Administration-and-Deployment/SAS-server-with-oracle-interface/m-p/673676#M19582 <P>Hi ,</P><P>&nbsp;</P><P>I have got a error to connect oracle data base .</P><P class="x_xmsonormal"><SPAN>ERROR: ORACLE connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.</SPAN></P><P class="x_xmsonormal"><SPAN>ERROR: Error in the LIBNAME statement</SPAN></P><P class="x_xmsonormal"><SPAN>I am very new to SAS administration .So any one guide me how to resolve this error.</SPAN></P><P class="x_xmsonormal"><SPAN>I need some knowledge how oracle database and SAS is connected .</SPAN></P><P class="x_xmsonormal">Thanks ,</P><P>Ashee</P> Fri, 31 Jul 2020 11:49:00 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-server-with-oracle-interface/m-p/673676#M19582 Ashee 2020-07-31T11:49:00Z Re: SAS server with oracle interface https://communities.sas.com/t5/Administration-and-Deployment/SAS-server-with-oracle-interface/m-p/673687#M19583 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/339876">@Ashee</a>&nbsp;,</P> <P>&nbsp;</P> <P>Please see the chapter "SAS/ACCESS Interface to Oracle" in the document below. Make sure you have set all of the environment variables:</P> <P><A href="https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf" target="_blank" rel="noopener">https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf</A>&nbsp;</P> Fri, 31 Jul 2020 12:01:54 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-server-with-oracle-interface/m-p/673687#M19583 alexal 2020-07-31T12:01:54Z