How to connect to target as non-sysdba account when threaded_execution=TRUE ?
I have created an account: RMAN_BACKUP.
Granted RMAN_BACKUP: sysbackup.
On DB where threaded_execution=TRUE:
rman target rman_backup/rman_backup
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Apr 7 09:50:14 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
On DB where threaded_execution=FALSE:
rman target rman_backup/rman_backup
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Apr 7 09:57:12 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=3883942179)