Problem with duplicate database using rman
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 18.104.22.168.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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
You should be local in aux and remote for target
One, who thinks that the other one who thinks that know and does not know, does not know either!
Click Here to Expand Forum to Full Width