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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.