Skip to Content
avatar image
Former Member

DBIF_RSQL_SQL_ERROR -SQL error 3113 occurred when accessing table

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

Capture3.PNG (127.6 kB)
Capture2.PNG (204.8 kB)
Capture1.PNG (120.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 24, 2013 at 12:44 PM

    Hi Kiran,

    how often does this issue occur? Is it reproducible?

    [orat11@OEL11 ~]$ oerr ORA 311303113, 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2013 at 05:44 AM

    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


    Capture5.PNG (11.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2013 at 10:09 AM

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

    Add comment
    10|10000 characters needed characters exceeded