Notification de proxy de test du serveur de notification Oracle reçue

Pour tester la notification reçue à l'aide du proxy Oracle Notification Server, procédez comme suit :

1. Arrêtez et démarrez le service raconssvc2 sur le noeud 1 Oracle RAC. Vous devez recevoir les événements sur fanWatcher, sur client-host :

   [oracle@racnode1 ~]$ srvctl stop service -d ORCLCDB_8p7_phx -s raconssvc2
   [oracle@racnode1 ~]$

2. Notification reçue sur le site client-host :

   [oracle@client-host ~]$ $ORACLE_HOME/jdk/bin/java -Doracle.ons.walletfile=/u01/app/client/wallet_dir-classpath ${CLASSPATH} fanWatcher "nodes=cman-host.sub12161926540.onsproxyvcn.oraclevcn.com:6200"
   Subscribing to events of type:
   Opening FAN Subscriber Window ... 
   
   ** Event Header **
   Notification Type: database/event/service
   Delivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICEMEMBER service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com instance=ORCLCDB1 database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode1 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00
   
   ** Event Header **
   Notification Type: database/event/service
   Delivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICE service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode2 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00
   
   ** Event Header **Notification Type: database/event/serviceDelivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICEMEMBER service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com instance=ORCLCDB2 database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode2 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00

   Remarques :

   Si vous configurez le proxy Oracle Notification Server sans certificats SSL et portefeuilles, vous n'avez pas besoin d'utiliser -Doracle.ons.walletfile=/u01/app/client/wallet_dir pour recevoir les événements du service de base de données.
3. Démarrez le service sur le noeud 1 d'Oracle RAC :

   [oracle@racnode1 ~]$ srvctl start service -d ORCLCDB_8p7_phx -s raconssvc2
   [oracle@racnode1 ~]$

4. Notification reçue le client-host :

   [oracle@client-host ~]$ $ORACLE_HOME/jdk/bin/java -Doracle.ons.walletfile=/u01/app/client/wallet_dir-classpath ${CLASSPATH} fanWatcher "nodes=cman-host.sub12161926540.onsproxyvcn.oraclevcn.com:6200"
   Subscribing to events of type:
   Opening FAN Subscriber Window ... 
   
   ** Event Header **
   Notification Type: database/event/service
   Delivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICEMEMBER service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com instance=ORCLCDB1 database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode1 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00
   
   ** Event Header **
   Notification Type: database/event/service
   Delivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICE service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode2 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00
   
   ** Event Header **Notification Type: database/event/serviceDelivery Time: Wed Dec 18 23:41:03 UTC 2024
   Creation Time: Wed Dec 18 23:41:03 UTC 2024
   Generating Node: cman-host
   Event payload:
   VERSION=1.0 event_type=SERVICEMEMBER service=raconssvc2.sub12161926541.onsproxyvcn.oraclevcn.com instance=ORCLCDB2 database=orclcdb_8p7_phx db_domain=sub12161926541.onsproxyvcn.oraclevcn.com host=racnode2 status=down reason=USER timestamp=2024-12-18 23:41:03 timezone=+00:00

   Remarques :

   Si vous configurez le proxy Oracle Notification Server sans certificats SSL et portefeuilles, vous n'avez pas besoin d'utiliser -Doracle.ons.walletfile=/u01/app/client/wallet_dir pour recevoir les événements du service de base de données.