We upgraded our 11gr2 DB to 12c. Now if we set parameter alter system set temp_undo_enabled=TRUE;
We get alert in the alert log as ORA-55526: temporary tablespace to store temporary undo not available and many things fail. Even adpatch fails. What temporary table setting shall be done to keep this parameter true and not get this error?
Is this an EBS database, since you refer to adpatch ? What version of EBS and which MOS Doc did you follow for the upgrade ?