Hi @Siva_Harish
What is the SAS Version you are using? This issue was fixed for 9.4 M1 release.
https://support.sas.com/kb/46/630.html
If you are on a higher version, I believe there could be something else that is causing the issue at your site. Can you confirm you are using the correct oracle client version that is required as per your site release version? You can check this in the system requirements document to confirm the version compatibility.
Ref: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n1pq...
https://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/66390/PDF/default/sreq.pdf
For SAS 9.4M7
DBMS Products Required:
• Oracle Database 12.1 or later
• Oracle Client 12.1 or later
Notes: Some additional configuration might be required to use the 12c, 18c, or later client. See the
Configuration Guide for SAS 9.4 Foundation for Microsoft Windows for x64 for more
information.
You can also use the Oracle Instant Client with SAS/ACCESS Interface to Oracle. However,
if you find any issues, you should switch to the full Oracle client, which is the only Oracle
client that SAS uses in official tests. SAS Technical Support will only investigate issues that
can be reproduced with the full Oracle client.
For best results, SAS recommends installing the latest patches on the client and server.
Similar issue was earlier fixed here: https://communities.sas.com/t5/Administration-and-Deployment/Can-t-connect-to-Oracle/td-p/113085