Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting error of ORA-01031: insufficient privileges

user637405Nov 21 2018 — edited Dec 2 2018

i have installed 11.2.0.1.0 on oel 5.9 64 bit.

rman target sys/abcd123@RAC auxiliary sys/abcd123@DRRAC

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Nov 18 23:21:28 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  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

----------------------------------------------------

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS                            TRUE  TRUE  FALSE

-----------------------------------

show parameter password;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_login_passwordfile            string      EXCLUSIVE

###################################

cat $ORACLE_HOME/rdbms/lib/config.c

/*  SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access.  */

/*  Refer to the Installation and User's Guide for further information.  */

/* IMPORTANT: this file needs to be in sync with

              rdbms/src/server/osds/config.c, specifically regarding the

              number of elements in the ss_dba_grp array.

*/

#define SS_DBA_GRP "oinstall"

#define SS_OPER_GRP "oinstall"

#define SS_ASM_GRP ""

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP};

any solutions are much appreciated.

thanks

Comments
Post Details
Added on Nov 21 2018
12 comments
3,514 views