Home » RDBMS Server » Backup & Recovery » RMAN-04005: error from target database: ORA-01031: insufficient privileges (Solaris 10, Oracle 11G)
RMAN-04005: error from target database: ORA-01031: insufficient privileges [message #420785] Wed, 02 September 2009 04:13 Go to next message
usuaria11
Messages: 4
Registered: August 2009
Junior Member
Hello,

I have a problem while I try to connect to RMAN in Oracle11.
I have a unix User mdu that belongs to group of the oracle user.:

$ id
uid=105(oracle) gid=101(orainst)

mdu@/users/mdu/mdu/log> id
uid=26119(mdu) gid=101(orainst)

I have a database and a user of that database also called mdu with dba privileges.
I try to connect to RMAN login as the unix user "mdu" and I received the error:

mdu@/users/mdu> rman target mdu/mdu nocatalog

Recovery Manager: Release 11.1.0.6.0 - Production on Mié Sep 2 10:48:01 2009

Copyright (c) 1982, 2007, 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

If I login as the oracle user and I try the same it works:

$ rman target mdu/mdu nocatalog

Recovery Manager: Release 11.1.0.6.0 - Production on Mié Sep 2 11:05:55 2009

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

connected to target database: MDU (DBID=1757729775)
using target database control file instead of recovery catalog

RMAN>


I think It must be a permissions problem. Someone know which directory of the oracle installation the RMAN need to read or write when I connect to RMAN as I said? (the connection is a local connection).

I have the following parameters for the database:

os_roles = false
remote_os_roles = false
remote_login_passwordfile = none


Thank you very much, I´m lost!






Re: RMAN-04005: error from target database: ORA-01031: insufficient privileges [message #420793 is a reply to message #420785] Wed, 02 September 2009 04:55 Go to previous message
usuaria11
Messages: 4
Registered: August 2009
Junior Member
The problem is solved. The oracle user had two groups associated and my unix user was associated only to the main group for oracle, but not to the second one.

Thanks.
Previous Topic: creating test database
Next Topic: How good is Hyperbac technology for Oracle's backup
Goto Forum:
  


Current Time: Tue Apr 23 18:24:08 CDT 2024