5.7 Check Non-Default Service

  1. Log in to Oracle Database 19c as sysadmin user.
  2. Execute this query to find all the service names with LONG:
    select NAME, NETWORK_NAME, CON_NAME, CLB_GOAL
    from gv$active_services
    where CLB_GOAL='LONG';
  3. Check that the non-default service name is not the same as the pdb / cdb name or any sys service name.