DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

[Former Member]

Hi Experts ,

Background jobs are getting failed with error DBIF_RSQL_SQL_ERROR and when we check the SM21 log says

SQL error 3113 ( Possibly network error ) WP in reconnect status.

Is this really network issue ? if not let me know the solution for this.

Thanks

Kiran.GVL

[stefan_koehler · Accepted solution]

Hi Kiran,

how often does this issue occur? Is it reproducible?

[orat11@OEL11 ~]$ oerr ORA 3113
03113, 00000, "end-of-file on communication channel"
// *Cause: The connection between Client and Server process was broken.
// *Action: There was a communication error that requires further investigation.
//          First, check for network problems and review the SQL*Net setup. 
//          Also, look in the alert.log file for any errors. Finally, test to 
//          see whether the server process is dead and whether a trace file
//          was generated at failure time.

Please check out my blog for further SQL*Net analysis and troubleshooting, if you can find no network issue (like package loss, port up and downs or whatever): http://scn.sap.com/community/oracle/blog/2013/01/02/oracle-a-short-sqlnet-research-or-how-to-drill-d...

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Thanks for the information , It happend 3 times from last 1 month.

As you suggested , i will check all the logs and come back to you.

Thanks

Kiran.GVL

[Former Member · Accepted solution]

Hi Stefan,

It has repeated today again and I have check alert log and other logs , i didn't find any erros. I came to know that there is some network issues with the client frequently.

Thanks

Kiran.GVL

[former_member206552 · Accepted solution]

Hi Kiran,

Have you tried setting

On database server find file {$ORACLE_HOME}\NETWORK\ADMIN\sqlnet.ora  and set it to SQLNET.AUTHENTICATION_SERVICES= (NONE)

Best Regards

Marius

[Former Member]

We had a network issues , now it's not repeating now.

[Former Member]

Hi Marius,

Please find th blow screenshot of SQLNET.ORA file of My Production System , If i chnage to NONE then it required a restart of SAP & Database

Thanks

Kiran.GVL

[former_member206552]

Hi Karin,

You can make the changes and just reload the listener using

lsnrctl reload

Best Regards

Marius