I can't connect to the database using RMAN using sysbackup.
I tried both ways .
a) I created a user and granted that user 'sysbackup' privilge.
b) I unlocked the default sysbackup user .
with sys , I can connect to the database via RMAN with no issues.
What am I missing ?
Thanks
SQL> show user
USER is "SYS"
SQL> alter user sysbackup identified by XXXX account unlock;
User altered.
C:\>rman target sysbackup/XXXX
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 4 16:36:28 2015
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
C:\>sqlplus sysbackup/o as sysbackup
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 4 16:37:01 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show user
USER is "SYSBACKUP"
SQL>