Skip to Content

URGENT: DBIF_REPO_SQL_ERROR - not even OSS has been able to help!

Hello Experts!

Since May 1th we have been having a very serious problem with the general performance generating dump code ORA-03113 and ORA-3114 which has grown constantly. We have had to reinitiate the system repeatedly.

The following activities were made:

 Replacement of a damaged disc of a volume used by the server located

in SAN, which generated a process of reconstruction of RAID 5

 Approximately 2 Days after the process had been initiated there's a problem of slowness and disconnection of users generating the following errors:

- DBIF_NTAB_SQL_ERROR

- DBIF_RTAB_SQL_ERROR

- DBIF_REPO_SQL_ERROR

With the following detail:



ORACLE error 3113 encountered ORA-03113: communication end-of-cases

out on channel.

ORACLE error 3114 encountered ORA-03114: not connected to ORACLE.

 We have increased the Redo log to 100 Mb. Alse we have reorganized table CE4VE01. Possibility of corrupt blocks in the data base was verified.

 We have Installed local additional discs to the server for the handling

of the paging files that they were in SAN

 The network cables were changed, they were changed to different ports, and extended to 100 Mbps Full Duplex in switch

 We've changed the Network cards by new ones of the

same original model

 The Drivers were updated and we verified the presence of the latest firmware

 We have made tests of stress to all hardware, which indicated

that there were no problems in the components

At the moment the infrastructure of communications was OK, but the errors continued as well as the shutdowns of the system

We have also followed the OSS instructions described below:

We setted all the database parameter as per the SAP note 124361.

We applied the latest oracle patch level as per the SAP note 539921.

Thanks in advace for your help!,

Frinee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 22, 2007 at 03:32 PM

    > ORACLE error 3113 encountered ORA-03113:

    > communication end-of-cases

    > out on channel.

    > ORACLE error 3114 encountered ORA-03114: not

    > connected to ORACLE.

    Those errors indicate, that the shadow process was terminated.

    What do you see in your Oracle alert<SID>.log when this error occurs? What's in the corresponding .trc file in saptrace/usertrace?

    --

    Markus

    Add comment
    10|10000 characters needed characters exceeded