ORA-01031 with RMAN Duplicate

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 7 Apr 2008 20:47:41 -0700 (PDT)
Message-ID: <793108.69933.qm@web38915.mail.mud.yahoo.com>

Ok, I'll admit, I'm stumped. I'm trying to do an active database duplication between two different servers. I've got the AUX instance setup and I can successfully connect to it from the target database box and query v$instance.

I can start RMAN, connecting successfully to the target and the aux instance.

However when I start the duplicate, It fails with this error:

ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server

(full output at the end of this email)...

So, I can connect with SQLPlus but the duplicate fails.... any ideas?

---

RMAN> duplicate target database to 'dup11g' from active database spfile nofilenamecheck;

Starting Duplicate Db at 07-APR-08
using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=170 device type=DISK

contents of Memory Script:
{

   backup as copy reuse
   file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\SPFILETSPUPG11G.ORA' auxiliary format  'D:\ORACLE\PRODUCT\11.1.0.6\DB_1\DATABASE\SPFILEDUP11G.ORA' ;    sql clone "alter system set spfile= ''D:\ORACLE\PRODUCT\11.1.0.6\DB_1\DATABASE\SPFILEDUP11G.ORA''"; }
executing Memory Script

Starting backup at 07-APR-08
allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=115 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/07/2008 21:42:36

RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/07/2008 21:42:36

ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server




 

Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 07 2008 - 22:47:41 CDT