4 Operational Issues and Troubleshoot

This topic provides information on operational issues and troubleshooting.

Patch set edition will not be dropped, if there are active connections to the schema pointing to Patch set Edition.

Exception in dropping edition java.sql.SQLException: ORA-38805: edition is in use

Clear such sessions and process Stage 4 again to get the Patch set Edition dropped.

Below query would help to list all editions in the Schema. At the end of process, only Base Edition should be present.

Select * FROM all_editions