-
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>
-
You must connect as a user that has SYSDBA privileges.
-
I think this is an issue with my oracle password file.
In my init.ora file I have the following:
*.remote_login_passwordfile='EXCLUSIVE'
When I go into sqplus and try to grant permissions I get the error below.
How do you tell the database what the location of the orapwd file?
This is the part I am not getting.Is there some parameter in the init.ora that does this? Ie orapwd_file=$ORACLE_HOME/dbs/orapass
Does the password file have to contain the name of the SID init like
the init.ora file?
sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 25 07:30:14 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 Engin
e options
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL>
-
You should use orapwd to create the file in $ORACLE_HOME/dbs. The filename must be of the format orapw<sid>.
-
and do NOT grant sysdba to system - do not touch oracle accounts, create your own
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|