How to connect Non-sysdba Account via RMAN, When Threaded_execution=TRUE

(Doc ID 2125305.1)

Last updated on APRIL 08, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

When threaded_execution=FALSE, non-sysdba account (ie rman) can perform RMAN duties, since it has sysbackup granted.

When threaded_execution=TRUE, it is failing with error ORA-01031

Listener setting, specific to threaded_execution has been set (DEDICATED_THROUGH_BROKER_LISTENER=ON)


$ rman target rman/rman@ora12102

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Apr 8 18:24:43 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms