- Installer Zero Downtime Database Setup & Operational Guide
- Operational Issues and Troubleshooting
1.7 Operational Issues and Troubleshooting
This section briefs on the common issues and its troubleshooting methods.
- If there are objects with version number other than 1 and While enabling editions for the User <Schema name> in section Pre-Requisite will result with the below error
- Patch set edition will not be dropped in section Drop Patch Set Edition 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 section Drop Patch Set Edition to process again to get the Patch set Edition dropped
Below query would help to list all editions in the Schema. At the end of process Drop Patch Set Edition, only Base Edition should present.