Oracle Pre-Upgrade Check Failed – DMSYS schema exists in the Database

Problem

Pre-upgrade check failed with following error when upgrade database 

The DMSYS schema exists in the database. Prior to performing an upgrade Oracle recommends that the DMSYS schema, and its associated objects be removed from the database.

Solution

Make sure the schema is not being used, then do the following 

SQL> CONNECT / AS SYSDBA;
SQL> DROP USER DMSYS CASCADE;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS'; 

SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';

If the above query return non-zero values then do the following to remove public synonyms referring DMSYS objects 

SQL> SET HEAD OFF
SQL> SPOOL drop_dmsys.sql
SQL> SELECT 'Drop public synonym ' ||'"'||SYNONYM_NAME||'";' FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SPOOL OFF
SQL> @drop_dmsys.sql
SQL> EXIT;

Output post processor error - java.io.FileNotFoundException

Problem

Concurrent request completed with following error

One or more post-processing actions failed. Consult the OPP service log for details.

When we check Output post processor log below error appear

java.io.FileNotFoundException: <path> (No such file or directory)

Solution

Set the xml/BI publisher with valid temp directory

 Go to XML Publisher Administration responsibility -> Home -> Administration -> Configuration -> Properties -> General
And Enter with valid path or clear the value of Temporary directory

Reference

Output Post Processor Log File Contains java.io.FileNotFoundException (No such file or directory) Error (Doc ID 463388.1)