RMAN backup failed with ORA-01031: insufficient privileges

Early morning I got email from unix team with given below error message.

Error Message

opyright (c) 1982, 2007, Oracle. All rights reserved.

 

RMAN> connect target system/********

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01031: insufficient privileges

 

RMAN> quit

 

Issue Identification

I noticed 10.2.0.3 RDBSM $ORACLE_HOME/bin/oracle file permission was as given below.

$ ls -l $ORACLE_HOME/bin/oracle

-rwxrwxr-x 1 orastg oinstall 134741371 May 22 17:03 oracle

 

Resolution

1. I changed oracle executable permission as given below.

   $ chmod 6751 $ORACLE_HOME/bin/oracle

   $ ls -l $ORACLE_HOME/bin/oracle

   -rwsr-s--x 1 orastg oinstall 134741371 May 22 17:03 $ORACLE_HOME/bin/oracle

2. I tried to connect system user as sysdba and it failed so I had to grant sysdba, sysoper to system user as given below.

   $sqlplus system/*****@JAI as sysdba

    

   SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 18 09:47:49 2009

    

   Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    

   ERROR:

   ORA-01031: insufficient privileges

    

   SQL> connect / as sysdba

   Connected.

   SQL> grant sysdba, sysoper to system;

   $sqlplus system/******@JAI as sysdba

   SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 18 09:51:34 2009

   Copyright (c) 1982, 2005, Oracle. All rights reserved.

    

   Connected to:

   Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

   With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options

    

   SQL>