Skip to Content

ORA-03113: end-of-file on communication channel in system copy r3load method

Dear all,

I´m doing a homogeneous system copy and during the target server copy the software provisioning manager stopped.

Import_monitor:

REPOSRC:

My system data info:

SAP EHP1 NW 7.3

Windows Server 2012 R2

Oracle 11.2.0.4

SWPM SP 19

Thnks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Mar 16, 2017 at 06:56 PM

    I solved all my oracle connection problems by updating the hosts file and adding the full host name even though my server is not in the domain

    SAP / Oracle useful errors resolved

    SM21

    SQL error 3135 occurred; work process in reconnect status

    ST22

    DBIF_REPO_SQL_ERROR

    Short text

    SQL error 3114 occurred when accessing program

    What happened?

    Error Text of the Database: "ORA-03114: not connected to ORACLE"

    Error analysis

    Error Text of the Database: "ORA-03114: not connected to ORACLE"

    Work Process trace:

    Wed Mar 15 16:01:19 2017

    check2: OCIStmtExecute() failed with -1=OCI_ERROR

    SQL error 3135: *** ERROR => Error 3135 in stmt_fetch() from oci_execute_stmt(), orpc=0

    dbsloci.c 18690] {root-id=00505694E12E1ED782B95D501A0020E2}_{conn-id=00000000000000000000000000000000}_0 ***

    ERROR => ORA-03135 occurred at SQL stmt (parse error offset=0) dbsloci.c 18693]

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2017 at 06:41 PM

    Check whether target Oracle instance is up or not.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 12:47 AM

    Hi Josué,

    Please test database connection via user <sid>adm:

    R3trans -d
    R3load -testconnect I

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 08:08 PM

    I restored system, but now i've have intermittent Oracle connectivity issue, in work processes run

    ORA-03114: Not Connected to Oracle

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 01:37 AM

    Hi Josué,

    Please attach complete one of work process trace.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded