SAS Oracle Connection Error

[sewa_bal_gmail_com]

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.

[SASKiwi]

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. 

[sewa_bal_gmail_com]

@SASKiwi 

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?

[SASKiwi]

@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.

[sewa_bal_gmail_com]

@SASKiwi 

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?

[SASKiwi]

@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.

[Anand_V]

Looking at the error code it seems to be custom error developed at site by the oracle DBA or application owner. Are you able to connect to same schema, creds via sqlplus?

Here's a link I found while searching for this error code. It could be something like the example has been applied at your side. I would suggest you to check with Oracle DBA.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:68817379083269

[sewa_bal_gmail_com]

@Anand_V 

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?