When using Oracle 11.2.0.3 version or higher, if the database ID for auxiliary instance is changed using NID script, the table restore from snap or File System backup copy and database cloning restores will fail with the following error message:
NID-00106: LOGIN to target database failed with Oracle error:
ORA-01017: invalid username/password; logon denied
To resolve this issue, install the Oracle update 13366202 on the destination database.