rman insufficient privileges
Can somebody explain this why my SQPLUS connection works and my RMAN
connection does not and how do I rectify the RMAN issue.
$ sqlplus system/system@PBH1020
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 24 15:29:37 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine option
$ rman TARGET SYSTEM/SYSTEM@PBH1020 CATALOG rman/rman@CAT1020
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Mar 24 15:29:46 2009
Copyright (c) 1982, 2005, Oracle. 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
Yet this works
$ rman TARGET / CATALOG rman/rman@CAT1020
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Mar 24 15:37:33 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PBH1020 (DBID=3969725195)
connected to recovery catalog database
RMAN>