SQL Error 3113 and 3114

[Former Member]

Hi all

I am getting Sql error 3113, system logs are below:

i checked tablespaces are having enough space.

can anybody tell what is this prob

SQL error 3114 . Work processes in reconnect status

SQL error 3113 . Work processes in reconnect status

SQL error 3113 . Work processes in reconnect status

SQL error 3113 . Work processes in reconnect status

Operating system call recv failed (error no. 73 )

Perform rollback

Perform rollback

Program RM07DOCS manually terminated by user LINFIN

Call of function NiRead failed, RC: -006

Work process has left reconnect status

Work process has left reconnect status

Terminal 00046 in status DISC

Perform rollback

Delete session 003 after error 004

Error calling the central lock handler

Request (type DIA) cannot be processed

> Unable to reach central lock handler

Request (type DIA) cannot be processed

Request (type DIA) cannot be processed

Request (type DIA) cannot be processed

Request (type DIA) cannot be processed

Request (type DIA) cannot be processed

[Former Member]

Bhupendra,

Check your archiving directory too. I've seen this error when the archiver is stuck. If Oracle cannot record the changes made to the system, then it can set into this state as protection.

Additionally, you should check if the database is even running. For instance, if you were grabbing an offline oracle backup and that backup failed, the scripts may not have restarted the database (like you scheduled it from DB13)

-Tim

[madhukara_shenoy]

Hello,

Well, Is the above error is happening during the offline backup? What is the impact on the system because of the above error? Is any transaction fails?

The above error could be because of the following

1. Network issue

2. wrong client version. If you are SAP Kernel which is compatible with client 9i, then i suggest to install the latest version of the client. Ofcourse client version shouldn't be more than the version of the oracle server software.

3. and there could be other possible reasons like some error in the alert log, resource issue.

Regards,

Madhukar

[former_member433984]

what is oracle DB patchset version?

what is oracle client version?

[Former Member]

CLIENT -- OCI_920

PATCH -- 549