Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-01031: insufficient privileges RMAN

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
Not what you were looking for? View more on this topic or Ask a question