topic Re: SAS Oracle Connection Error in Administration and Deployment

SAS Oracle Connection Error

sewa_bal_gmail_com — Thu, 30 Apr 2020 21:23:53 GMT

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.

Re: SAS Oracle Connection Error

SASKiwi — Thu, 30 Apr 2020 23:59:02 GMT

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-recursive-sql-level-1

This is not a SAS problem. I suggest you consult your Oracle DBA.

Re: SAS Oracle Connection Error

sewa_bal_gmail_com — Fri, 01 May 2020 00:44:43 GMT

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

Re: SAS Oracle Connection Error

SASKiwi — Fri, 01 May 2020 00:56:53 GMT

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

Re: SAS Oracle Connection Error

sewa_bal_gmail_com — Fri, 01 May 2020 01:06:11 GMT

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

Re: SAS Oracle Connection Error

SASKiwi — Fri, 01 May 2020 02:32:36 GMT

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

Re: SAS Oracle Connection Error

AnandVyas — Fri, 01 May 2020 06:46:53 GMT

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

Re: SAS Oracle Connection Error

sewa_bal_gmail_com — Fri, 01 May 2020 13:32:28 GMT

@AnandVyas

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?