SQL message: ORA-03113: end-of-file on communication

[jorge_velasquez]

Hi Experts,

We having an issue with Oracle message

Dump also explains this:

The termination occurred in ABAP program "SAPMSSY2", in "GET_CNTL_VALUES". T
main program
was "SAPMSSY2".

In the source code, the termination point is in line 60 of (Include)
program "RSBTCTRC".
Program "SAPMSSY2" was started as a background job.

Job name.......
Job initiator..
Job number...... " "
The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedu
"GET_CNTL_VALUES" "(FORM)".
This exception was not handled locally or declared in the RAISING
clause in the procedure's signature however.
The procedure is in program "SAPMSSY2                                ". The
source code begins in line 26 of
(include) program "RSBTCTRC                                ".

I also checked 335199  - ora-3113 collective note

Regards.

[Former Member]

Hi,

Any Oracle/Client changes happened on this environment?

First check the result of R3trans -dx and paste the error lines.

Regards,

Nick Loy

[jorge_velasquez]

Hi Nick,

It shows no errors:

C:\Users\SIDadm>r3trans -dx

This is r3trans version 6.24 (release 741 - 27.03.14 - 20:14:03 ).

unicode enabled version

r3trans finished (0000).

[Former Member]

Restart your PAS and paste the error logs if you face any issue while doing R3trans -dx.

Check Oracle client as well.

Regards,

Nick Loy

[Reagan]

Check the Oracle database alert log for more information.

Also check for issues with the archive logs due to file system space issue.

Regards

RB

[former_member188883]

Hi Jorge,

Looks like there is some network problem resulting into ORA-3113.

To troubleshoot & diagnose Oracle connectivity problems, I like to start at the simplest, outermost level, and follow this checklist:

- Check with "ping" using the IP address

- Check with "ping" using DNS name (e.g. "tnsping <SID>")

- Try telnet to the IP on port 1521 (telnet IP <Listener Port>)

- Check with "tnsping" using TNS service name

Also check alert_<SID>.log file for more information on the ora error.

Please check and share the results.

Regards,

Deepak Kori

[jorge_velasquez]

Hi Deepak,

This is PAS on Windows Server and Oracle RAC Linux for Data Base,

I checked :

Ping, telnet, tnsping and everything is ok.

on alert_<SID>.log find this:

TNS-12535: TNS:operation timed out
TNS-00505: Operation timed out
    ns main err code: 12535
    nt secondary err code: 110

    ns secondary err code: 12560
    nt OS err code: 0

[former_member188883]

Hi Jorge,

Please set the value of parameter sqlnet.recv_timeout to some high value under sqlnet.ora

restart listener and then check the results.

Regards,

Deepak Kori