Oracle 12c backup jobs fail with error: e000848c - Unable to attach to a resource. Ensure that the selected resource exists and is online, and then try again. If the server or resource no longer exists, remove it from the...

book

Article ID: 100015110

calendar_today

Updated On:

Description

Error Message

In beremote.log collected on the Oracle remote server, the following errors can be observed.

Oracle Logon Failure, insufficient privileges: Error code (1031)
Returning E_RMAN_LOGON_INSUFFICIENT_PRIVILEGES error (0xe000100d)
OCIINTERCONNECT::LogonOracle: Logon is Unsuccessful
OCIInterconnect : Logon Failed. Error = -536866803

 

On the Media server the SGMON shows the following error:

ERROR: 10 Error: Invalid device
dataStartBackup: ERROR returning: 0x10, 16
ERROR: 13 Error: Invalid state to process request
ERROR: received TBE message: 0xE000848C while processing backup set: 'Oracle-Win::\\ORACLE-FQDN-NAME\ORACLE-DATABASE' (0000000008088CF0)

 

Cause

The account used to backup the ORACLE 12c databases does not have the appropriate privileges.

 

Resolution

A user with the SYSBACKUP privileges, either by enabling this account or by creating an account and grant it the  SYCBACKUP privilege,  has to be configured in Oracle 12c  and used to backup Oracle 12c. 

 

 

 

Issue/Introduction

Oracle 12C backup jobs fail with error: e000848c - Unable to attach to a resource. Ensure that the selected resource exists and is online, and then try again. If the server or resource no longer exists, remove it from the selections. UMI: V-79-57344-33932 - Unable to attach to a resource. Ensure that the selected resource exists and is online, and then try again
Powered by Wolken Software