Hi All,
I would like to connect to oracle database through management cosole by setting up the library.
also added server host =ip and port=xxx, sid=xx in server (tnsnames.ora)
but when I try through smc not able to connect or register tables
what else would be required to make successful library?
appreciate you help!
This problem happens commonly. I recommend following these steps:
1. On the server that you are setting up the library on, ensure that you can connect to the desired Oracle environment using a non-SAS tool, such as SQL*Plus.
2. Once you know that this works, you should have a good, validated set of connection credentials. Then, running a SAS session on that server, try setting up a connection using a base SAS libname statement.
3. Once you know that this works, you know that the SAS environment on the particular server can successfully connect to your desired Oracle environment. Then move on to setting it up in SMC.
If any of the steps fail, diagnose and remediate them at that level, then move on.
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.