Skip to Content
author's profile photo Former Member
0
Former Member

DBIF_REPO_SQL_ERROR - ORA-03114: not connected to ORACLE

Posted on Jul 18, 2016 at 02:37 PM 1.6k Views

Hello,

In our SAP ERP system, we are having database connection lost with application servers frequently. This is happening weekly 3 times.

During disconnection of database, all the background job getting cancelled and receiving the dump

*************************

Runtime Errors DBIF_REPO_SQL_ERROR Date and Time 18.07.2016 09:43:04

Short text

SQL error 3114 occurred when accessing program

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator . You can use the ABAP dump analysis transaction ST22 to view and manage termination messages, in particular for long term reference.

ow to correct the error

Database error text........: "ORA-03114: not connected to ORACLE"

Triggering SQL statement...: "CX_SY_SQL_ERROR===============CP "

Internal call code.........: "[REPO/*/43/LOAD/CX_SY_SQL_ERROR===============CP

"**************************************************

We could not able to find any connection lost logs in database level.

Please help me to identify the cause and solving the issue.

Thanks and Regards,

Anand

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 08:43 AM
    1

    Hi All,

    Thanks for the update.

    We are taking tcpdump in one server and analyze the logs from network team.

    And also we migrated another system database server to another EsX host and monitoring the same.

    I will update you based on the result.

    Thanks,

    Anand

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2016 at 02:47 PM
    1

    Hi Anand,

    Can you share some details regarding your SAP Architecture. OS/DB release and how are the instances (SAP and DB) distributed?

    You may also want to check with the infrastructure team on the network usage report for the duration you get these disconnects in your system.

    Thanks,

    Manas

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Nicolaas Johannes Van Zyl
    Nicolaas Johannes Van Zyl
    Posted on Jul 20, 2016 at 08:04 AM
    0

    Hi,

    Please paste a section of your alertlog here and listener log files here from the time of one of the errors.

    ORA-03114: not connected to ORACLE


    Also attached a work process trace file.


    Troubleshooting wise have you checked your application servers dev_rd for any errors during startup i.e. network?


    Can all servers ping each other dns/hostname without issues. As mentioned by sriram check maybe that they are all in the same subnet.


    Also when did this issue start i.e. was there a recent change in the environment server/sap/network before issues started occurring?


    Kind Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2016 at 08:56 AM
    0

    Hello All,

    Thanks for your feedback. Now we are not having the network interrupt in the database server.

    We are not sure what is the root cause of this issue and how it got solved.

    Regards,

    Anand

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.