Oracle Error ORA-19525: tempfile for the clone database must be renamed

Oracle Error Message

ORA-19525: tempfile for the clone database must be renamed

Reason for the Error

Opening a clone database failed because Oracle server forces the tempfile to be renamed, in order to avoid overwriting the primary tempfile.

Solution

Rename the tempfiles manually or automatically by using the DB_FILE_NAME_CONVERT initialization parameter.