Problem with duplicate database using rman
Hello,
I'm trying to clone oracle database from existing database on remote server. First I prepared the same file structure on auxilary server as on target is, created passwd file on aux, created init.ora file on aux from spfile from target database, copied backup from target on the same file structure on aux host and updated lister.ora configuration on aux and tnsnames on target host. I started database instance on aux (with the same sid as it is on target) in nomount mode. I'm getting following error while I try to initiate the command as shown below from rman on target. Kindly help me resolving this.
Recovery Manager: Release 9.2.0.5.0
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target
connected to target database: ORCL (DBID=924445643)
RMAN> connect auxiliary sys/passwd@conn_string_to_aux
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
