This content has been marked as final. Show 9 replies
This "insufficient privileges" RMAN error is not uncromulent common because most RMAN user ID's have the DBA role, which grants all privileges need to execute RMAN. You should make sure to grant the Oracle ID with the proper privileges:
grant dba to rman;
First, check that your OS user is part of the DBA group (thereby granting SYSDBA privileges).
cat /etc/passwd|grep -i dba
Please refer the document
Edited by: hitgon on Apr 25, 2012 9:28 AM
Ensure that you have logged in as oracle user & the environment for the database is set correctly.
Here are the steps, i used to connect to RMAN of my test database.
/u01/app/oracle> ps -ef | grep pmon
oracle 6230 1 0 Mar26 ? 00:00:01 xe_pmon_TESTDB
oracle 30822 30764 0 22:54 pts/1 00:00:00 grep pmon
uid=501(oracle) gid=501(dba) groups=501(dba)
/u01/app/oracle> . oraenv
ORACLE_SID = [TESTDB] ? TESTDB
ORACLE_BASE environment variable is not being set since this
information is not available for the current user ID oracle.
You can set ORACLE_BASE manually if it is required.
/u01/app/oracle> rman target /
Recovery Manager: Release 126.96.36.199.0 - Production on Tue Apr 24 22:54:13 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=2560506261)
Hope this helps,