Question Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table in Technology Q&A

DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

Former Member — Mon, 24 Jun 2013 02:11:22 GMT

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

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

stefan_koehler — Mon, 24 Jun 2013 12:44:54 GMT

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-down-network-related-ora-errors

Regards

Stefan

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

Former Member — Mon, 24 Jun 2013 14:02:42 GMT

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

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

Former Member — Tue, 25 Jun 2013 03:44:42 GMT

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

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

former_member206552 — Wed, 26 Jun 2013 05:23:00 GMT

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

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

Former Member — Wed, 26 Jun 2013 05:44:50 GMT

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

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

former_member206552 — Wed, 26 Jun 2013 07:28:44 GMT

Hi Karin,

You can make the changes and just reload the listener using

lsnrctl reload

Best Regards

Marius

Re: DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

Former Member — Fri, 05 Jul 2013 10:09:31 GMT

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