Check Non-Default Service

  1. Log in to Oracle Database 19c as a sysadmin user.
  2. Execute this query to find all the service names with LONG as the service type:
    select NAME, NETWORK_NAME, CON_NAME, CLB_GOAL
    from gv$active_services
    where CLB_GOAL='LONG';
  3. In the list of service names with LONG as the service type, ensure that the non-default service name is not same as the PDB, CDB, or any SYS service name.