Hi ,
I have got a error to connect oracle data base .
ERROR: ORACLE connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
ERROR: Error in the LIBNAME statement
I am very new to SAS administration .So any one guide me how to resolve this error.
I need some knowledge how oracle database and SAS is connected .
Thanks ,
Ashee
@Ashee ,
Please see the chapter "SAS/ACCESS Interface to Oracle" in the document below. Make sure you have set all of the environment variables:
https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Join SUGA
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.