RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

Active database duplication RMAN-04006

Problem:-

RMAN> connect target sys/oracle@amer

connected to target database: AMER (DBID=1314861233)

RMAN> connect auxiliary sys/oracle@euro

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

Solution:-  

1. Login with auxiliary database(EURO) and run the following command.

[oracle@euro dbs]$ . oraenv

ORACLE_SID = [euro] ?  

The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle

[oracle@euro dbs]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 11:27:55 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area  828608512 bytes

Fixed Size                  1339684 bytes

Variable Size             490737372 bytes

Database Buffers          331350016 bytes

Redo Buffers                5181440 bytes

SQL> select * from v$pwfile_users;

no rows selected

If output is no row select  then  you need to copy orapw file from  source db.

1. Login to source database.

2. scp orapwamer from source server /u01/app/oracle/product/11.2.0/dbhome_1/dbs to target server /u01/app/oracle/product/11.2.0/dbhome_1/dbs

3. Login into target database(auxiliary).

cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/

mv orapwamer orapweuro

exit

[oracle@euro admin]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 11:46:20 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys/oracle@amer

connected to target database: AMER (DBID=1314861233)

RMAN> connect auxiliary sys/oracle@euro

connected to auxiliary database: EURO (not mounted)