Hi,
We are getting an error while connecting to oracle. The log shows the below error. The user has all the required access to Oracle and he can access to oracle with SQL developer. Metadata access also verified.
If you google this error like I did then you will find plenty of references like this: https://stackoverflow.com/questions/30478070/how-to-solve-sql-error-ora-00604-error-occurred-at-recu...
This is not a SAS problem. I suggest you consult your Oracle DBA.
Thanks for the reply.
User is facing this error while connecting to oracle with libname statement. User already tested their oracle credentials via SQL developer tool.
How I can prove this is not sas related?
@sewa_bal_gmail_com - Can you post the SAS log of the LIBNAME statement including notes and errors? Your Oracle DBA would be able to look at the Oracle server log and see what is happening in the database.
Also it would be worth testing the LIBNAME with another username to see if you get the same error.
Here is sas libname statement and error.
I Will check if other others getting the same error.
Do you know where exactly oracle dba will check the error at the oracle side?
@sewa_bal_gmail_com - I'm not an Oracle expert. A DBA should know where to look for these types of errors and to diagnose the problem. Hopefully the Oracle server log will provide more details of where the problem lies.
Thanks for the reply.
Yes, the user can connect to oracle via SQL developer. I will connect to DBA for the same.
Is this possible we can troubleshoot this error at sas end?
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.