[New post] Checking user RMAN privileges getting ora-01031 insufficient privileges
SandeepSingh DBA posted: " Configured the window user for RMAN on Window platform. We created an Oracle User for RMAN backup in Oracle Database. We scheduled the script but it will generate the following errors: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========="
Configured the window user for RMAN on Window platform. We created an Oracle User for RMAN backup in Oracle Database. We scheduled the script but it will generate the following errors:
Provide the sysdba privilege to the Oracle User. ( we are using Oracle 10g thats why we provide SYSDBA but from Oracle 12c we can use SYSBACKUP as privilege.
---Provide sysdba to user Grant sysdba to username; --Provide sysbackup to user Grant sysbackup to username;
2. If first step will not fixed the issue, then our Operating system user from which we are running the RMAN commands/Scripts have member of group: ORA_DBA(windows) or OSBACKUPDBA( unix or linux)
Unix/Linux at /etc/passwd|grep -i dba
Windows as: Check User is member of following ORA_DBA group:
3. Check the SQLNET.ora file for following parameter is set to NTS value.
No comments:
Post a Comment