Database - RAC/Scalability (MOSC)

MOSC Banner

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center