RMAN Auxiliary connect fails with ORA-01031: INSUFFICIENT PRIVILEGES
There may be a mismatch in the “case” of characters between these items on the host where the auxiliary database resides:
1) The entry in the listener.ora file for service_name for the auxiliary instance.
2) The entry for db_name in the init<sid>.ora file for the auxiliary instance.
3) The naming of the password file.
4) The $ORACLE_SID for the auxiliary instance.
If all four items have matching case characters, you may find the errors connecting remotely via the password file are resolved.
The init<sid>.ora file:
The password file:
$ ORACLE_SID=PROD; export ORACLE_SID
$ORACLE_SID and password file is must be same.