DBMS_SERVICE.START_SERVICE is resetting EDITION back to previous Edition
Hi,
- Oracle Version: 19.12.0.0.0
- Operating System: Red Hat Enterprise Linux Server release 7.6 (Maipo)
- Environment Type: Single Instance
We use Edition Based Redefinition and, in order for DBMS_SCHEDULER to be able to reference PL/SQL Packages in an specific Edition, we create a specific Service (TMS_MIG_SCHEDULER_SERVICE) which is assigned an explicit EDITION value.
This approach has worked successfully for the last 3 years and the EDITION property has been updated several times, using this pattern:
exec DBMS_SERVICE.STOP_SERVICE('TMS_MIG_SCHEDULER_SERVICE'); exec dbms_service.modify_service(service_name => 'TMS_MIG_SCHEDULER_SERVICE',edition => '<EditionName>',modify_edition => TRUE); exec dbms_service.start_service('TMS_MIG_SCHEDULER_SERVICE');