I have detected zombie services in the database associated with my Central server (version 22.10), while the corresponding entries appear to be consistent in the database of my Remote server. Could you please advise on the recommended procedure to clean up these orphaned/zombie services and properly identify them?
Central DB :
+---------+------------+------------------------------+-------------------------------------+-------+-----------------+
| host_id | service_id | name | display_name | notes | notes |
+---------+------------+------------------------------+-------------------------------------+-------+-----------------+
| 446 | 3686 | hostname.sup.fr | [ORACLE]-JDEDEV-INDEX_INVALID | | |
| 446 | 3687 | hostname.sup.fr | [ORACLE]-JDEDEV-TABLESPACES_NUMBERS | | |
| 446 | 3688 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_MISSING | | |
| 446 | 3689 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_RECYCLEBIN | | |
| 446 | 3690 | hostname.sup.fr | [ORACLE]-JDEDEV-FRA | | |
| 446 | 3691 | hostname.sup.fr | [ORACLE]-JDEDEV-SWITCHES | | |
| 446 | 3692 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_PARAMETER | | |
| 446 | 3693 | hostname.sup.fr | [ORACLE]-JDEDEV-LOCKLONG | | |
| 446 | 3694 | hostname.sup.fr | [ORACLE]-JDEDEV-JOBS | | |
| 446 | 3695 | hostname.sup.fr | [ORACLE]-JDEDEV-REBOOT | | |
| 446 | 3696 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_STATUS | | |
| 446 | 3697 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_FAILED | | |
| 446 | 3698 | hostname.sup.fr | [ORACLE]-JDEDEV-ALERT_RDBMS | | |
| 446 | 3699 | hostname.sup.fr | [ORACLE]-JDEDEV-SESSIONS | | |
| 446 | 3700 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_ARCHIVELOG_MODE | | |
| 446 | 3701 | hostname.sup.fr | [ORACLE]-JDEDEV-PROCESS | | |
| 446 | 3702 | hostname.sup.fr | [ORACLE]-JDEDEV-TABLESPACES_USAGE | | |
| 446 | 3917 | hostname.sup.fr | [ORACLE]-JDEDEV-INDEX_INVALID | | ORACLE_INSTANCE |
| 446 | 3918 | hostname.sup.fr | [ORACLE]-JDEDEV-TABLESPACES_NUMBERS | | |
| 446 | 3919 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_MISSING | | ORACLE_INSTANCE |
| 446 | 3920 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_RECYCLEBIN | | ORACLE_INSTANCE |
| 446 | 3921 | hostname.sup.fr | [ORACLE]-JDEDEV-FRA | | ORACLE_INSTANCE |
| 446 | 3922 | hostname.sup.fr | [ORACLE]-JDEDEV-SWITCHES | | ORACLE_INSTANCE |
| 446 | 3923 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_PARAMETER | | ORACLE_INSTANCE |
| 446 | 3924 | hostname.sup.fr | [ORACLE]-JDEDEV-LOCKLONG | | ORACLE_INSTANCE |
| 446 | 3925 | hostname.sup.fr | [ORACLE]-JDEDEV-JOBS | | ORACLE_INSTANCE |
| 446 | 3926 | hostname.sup.fr | [ORACLE]-JDEDEV-REBOOT | | ORACLE_INSTANCE |
| 446 | 3927 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_STATUS | | ORACLE_INSTANCE |
| 446 | 3928 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_FAILED | | ORACLE_INSTANCE |
| 446 | 3929 | hostname.sup.fr | [ORACLE]-JDEDEV-ALERT_RDBMS | | ORACLE_INSTANCE |
| 446 | 3930 | hostname.sup.fr | [ORACLE]-JDEDEV-SESSIONS | | ORACLE_INSTANCE |
| 446 | 3931 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_ARCHIVELOG_MODE | | ORACLE_INSTANCE |
| 446 | 3932 | hostname.sup.fr | [ORACLE]-JDEDEV-PROCESS | | ORACLE_INSTANCE |
| 446 | 3933 | hostname.sup.fr | [ORACLE]-JDEDEV-TABLESPACES_USAGE | | ORACLE_INSTANCE |
| 446 | 160847 | hostname.sup.fr | [ORACLE]-JDEDEV-EXPIRED_USERS | | ORACLE_INSTANCE |
On my Remote server:
+---------+------------+------------------------------+-------------------------------------+-------+-----------------+
| host_id | service_id | name | display_name | notes | notes |
+---------+------------+------------------------------+-------------------------------------+-------+-----------------+
| 446 | 3917 | hostname.sup.fr | [ORACLE]-JDEDEV-INDEX_INVALID | | ORACLE_INSTANCE |
| 446 | 3919 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_MISSING | | ORACLE_INSTANCE |
| 446 | 3920 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_RECYCLEBIN | | ORACLE_INSTANCE |
| 446 | 3921 | hostname.sup.fr | [ORACLE]-JDEDEV-FRA | | ORACLE_INSTANCE |
| 446 | 3922 | hostname.sup.fr | [ORACLE]-JDEDEV-SWITCHES | | ORACLE_INSTANCE |
| 446 | 3923 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_PARAMETER | | ORACLE_INSTANCE |
| 446 | 3924 | hostname.sup.fr | [ORACLE]-JDEDEV-LOCKLONG | | ORACLE_INSTANCE |
| 446 | 3925 | hostname.sup.fr | [ORACLE]-JDEDEV-JOBS | | ORACLE_INSTANCE |
| 446 | 3926 | hostname.sup.fr | [ORACLE]-JDEDEV-REBOOT | | ORACLE_INSTANCE |
| 446 | 3927 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_STATUS | | ORACLE_INSTANCE |
| 446 | 3928 | hostname.sup.fr | [ORACLE]-JDEDEV-BACKUP_RMAN_FAILED | | ORACLE_INSTANCE |
| 446 | 3929 | hostname.sup.fr | [ORACLE]-JDEDEV-ALERT_RDBMS | | ORACLE_INSTANCE |
| 446 | 3930 | hostname.sup.fr | [ORACLE]-JDEDEV-SESSIONS | | ORACLE_INSTANCE |
| 446 | 3931 | hostname.sup.fr | [ORACLE]-JDEDEV-DB_ARCHIVELOG_MODE | | ORACLE_INSTANCE |
| 446 | 3932 | hostname.sup.fr | [ORACLE]-JDEDEV-PROCESS | | ORACLE_INSTANCE |
| 446 | 3933 | hostname.sup.fr | [ORACLE]-JDEDEV-TABLESPACES_USAGE | | ORACLE_INSTANCE |
| 446 | 160847 | hostname.sup.fr | [ORACLE]-JDEDEV-EXPIRED_USERS | | ORACLE_INSTANCE |
+---------+------------+------------------------------+-------------------------------------+-------+-----------------+