Testar Notificação de Proxy do Oracle Notification Server Recebida

Siga estas etapas para testar a notificação recebida usando o proxy do Oracle Notification Server:

1. Interrompa e inicie o serviço raconssvc2 no Oracle RAC Node 1. Você deve receber eventos no fanWatcher, no client-host:

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

2. Notificação recebida no 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

   Observação:

   Se você configurar o proxy do Oracle Notification Server sem certificados e wallets SSL, não será necessário usar -Doracle.ons.walletfile=/u01/app/client/wallet_dir para receber os eventos do serviço de banco de dados.
3. Inicie o serviço no Nó 1 do Oracle RAC:

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

4. Notificação recebida em 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

   Observação:

   Se você configurar o proxy do Oracle Notification Server sem certificados e wallets SSL, não será necessário usar -Doracle.ons.walletfile=/u01/app/client/wallet_dir para receber os eventos do serviço de banco de dados.