Backup job of an Oracle RAC database on Linux succeeds with an exception when client side deduplication option is enabled

book

Article ID: 100009495

calendar_today

Updated On:

Description

Error Message

Exceptions

V-79-40960-39700 - Client-side deduplication is enabled for this job, but it could not be used.

Cause

Oracle has designed and introduced a new mechanism for signal handling on Linux systems, starting with Oracle version 11gR2. This design change impacts all of the backup applications or OCI applications that also use signal handling. This impacts Backup Exec deduplication service. As a result, client side deduplication does not work.

Resolution

Oracle provides a configuration parameter that you can use to revert to the former signal handling mechanism in the event that the new signal handling mechanism impacts a backup application or OCI application.

The parameter (BEQUEATH_DETACH) should be set to “YES” to resolve this issue. You must add the parameter BEQUEATH_DETACH=YES to the SQLNET.ORA file located at ORACLE_HOME/network/admin.

If the SQLNET.ORA file is not present on the Linux server, you can copy it from $ORACLE_HOME/network/admin/samples to $ORACLE_HOME/network/admin, and then edit this file to uncomment the line BEQUEATH_DETACH=YES.

Additional references:

  • Oracle Note [ID 951654.1] Doing System Calls after Database Connection Always Returns -1 on 11.2.

  • Oracle Bug [ID 8996707] Calling system function after OCISERVERATTACH always returns -1 on 11.2

 

 

Issue/Introduction

This article describes an issue where a backup job of an Oracle RAC database on Linux succeeds with an exception when the client side deduplication option is enabled.

Additional Information

ETrack: 3176238