Hi @Dmitriy1 Try to Right Click on the Library/Libname in SAS Management Console and selecting "Display Libname Statement". You'll see the Generated Libname Statement does not match the syntax of your definition! Hence you are getting the Error!
While the SAS/ACCESS to ORACLE Documentation shows an example on how connects to Oracle without updating the TNSNAMES.ORA file
libname x oracle user=myusr1 pw=mypwd1
path="(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=TCP)(HOST=pinkfloyd)(PORT=1521))
)
(CONNECT_DATA=
" (SID=alien)
" )
" )
" ";
That doesn't mean, the SAS Management Console would translate the library definition the same way!
It's safer to modify the TNSNAMES.ora file accessible to your SAS Server(s) to include the Oracle connection settings.
Just my 2 cents,
Ahmed
... View more
