ORA-01031: insufficient privileges RMAN

[Former Member]

Hello, we are using Solution Manager DB13 for remote Oracle Backups. I have created SOLMANSIDadm and OPS$SOLMANsidadm users part of DBA and OPER groups.

DBVerify, Update Stats are working fine. But Backups are failing with the below exception. As I can see that it is giving command as

RMAN> connect target *

instead of connect target / or connect target

16:17:16 11.11.2011 BR0317I 'Alter tablespace SYSTEM end backup' successful

16:17:16 11.11.2011

16:17:16 11.11.2011 BR0280I BRBACKUP time stamp: 2011-11-11 16.17.12

16:17:16 11.11.2011 BR0530I Cataloging backups of all database files...

16:17:16 11.11.2011 BR0278E Command output of 'SHELL=/bin/sh /oracle/NPP/112_64/bin/rman nocatalog':

16:17:16 11.11.2011

16:17:16 11.11.2011 Recovery Manager: Release 11.2.0.2.0 - Productionon Fri Nov 11 16:17:12 2011

16:17:16 11.11.2011

16:17:16 11.11.2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

16:17:16 11.11.2011

16:17:16 11.11.2011 RMAN>

16:17:16 11.11.2011 RMAN> connect target *

16:17:16 11.11.2011 RMAN-00571: ===========================================================

16:17:16 11.11.2011 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

16:17:16 11.11.2011 RMAN-00571: ===========================================================

16:17:16 11.11.2011 ORA-01031: insufficient privileges

16:17:16 11.11.2011

16:17:16 11.11.2011 RMAN> *end-of-file*

16:17:16 11.11.2011

16:17:16 11.11.2011 RMAN>

16:17:16 11.11.2011 host command complete

16:17:16 11.11.2011

16:17:16 11.11.2011 RMAN> 2> 3> 4> 5> 6> 7> 8>

16:17:16 11.11.2011 RMAN-00571: ===========================================================

16:17:16 11.11.2011 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

16:17:16 11.11.2011 RMAN-00571: ===========================================================

16:17:16 11.11.2011 RMAN-03002: failure of catalog command at 11/11/2011 16:17:13

16:17:16 11.11.2011 RMAN-06171: not connected to target database

16:17:16 11.11.2011

16:17:16 11.11.2011 RMAN>

Is there any way to control the

connect target *

in DB13 of Solution manager?

If I have logged in as the user and the backups went fine.

Thanks

Srikanth M

[Former Member]

After I have changed the groups of brbackup brarchive from sapsys to dba with permission 6756 it has started working.

https://service.sap.com/sap/support/notes/776505

[Former Member]

Hi,

The system is trying to logon wth OPS$ user, but facing with ORA-01031 error. Execute sapdba_role.sql

And check ora<sid> is member of dba group.

Best regards,

Orkun Gedik

[Former Member]

That is what I have mentioned above :

If I have logged in as the user and the backups went fine.

If I login as SOLMANSIDadm and do the backup on that Host it is fine. User does have sapdba and conn role of that database.

Thanks

Srikanth M

[Former Member]

Could you provide the output of the statements below at the remote database?

select username from dba_users;

Best regards,

Orkun Gedik

[Former Member]

Here the XXX is Oracle SID and YYY is SOLMAN SID.

SQL> select username from dba_users;

USERNAME

-

---

OPS$YYYADM

OPS$XXXADM

OPS$ORAXXX

SYS

SYSTEM

DBSNMP

SAPSR3DB

YYYADM

OUTLN

DIP

ORACLE_OCM

USERNAME

-

---

APPQOSSYS

12 rows selected.

[former_member188883]

Hi,

Please refer to the following SAP notes . Follow the steps mentioned pertaining to your platform.

SAP note 361641 Creating OPS$ users on UNIX

SAP note 50088 Creating OPS$ users on Windows NT/Oracle

Hope this helps in resolving the issue.

Regards,

Deepak Kori

[Former Member]

This is not first time working with RMAN, I was looking for expert answers. I'll figure this out.

Thanks

Srikanth M