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