05-15-2018 06:20 AM
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!
05-15-2018 08:00 AM
05-15-2018 11:46 AM
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.