rman insufficient privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: rman insufficient privileges

Hybrid View

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    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>

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You must connect as a user that has SYSDBA privileges.

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    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>

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    You should use orapwd to create the file in $ORACLE_HOME/dbs. The filename must be of the format orapw<sid>.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width