Test Oracle Notification Server Proxy Notification Received

Follow these steps to test the notification received using Oracle Notification Server proxy:

1. Stop and start the service raconssvc2 on Oracle RAC Node 1. You should receive events on fanWatcher, on the client-host:

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

2. Notification received on the 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

   Note:

   If you set up the Oracle Notification Server proxy without SSL certificates and wallets, you don't need to use -Doracle.ons.walletfile=/u01/app/client/wallet_dir to receive the events from database service.
3. Start the service on Oracle RAC Node 1:

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

4. Notification received on 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

   Note:

   If you set up the Oracle Notification Server proxy without SSL certificates and wallets, you don't need to use -Doracle.ons.walletfile=/u01/app/client/wallet_dir to receive the events from database service.