Notifica proxy del test di Oracle Notification Server ricevuta

Seguire questa procedura per eseguire il test della notifica ricevuta utilizzando il proxy Oracle Notification Server:
  1. Arrestare e avviare il servizio raconssvc2 nel nodo 1 di Oracle RAC. Dovresti ricevere gli eventi su fanWatcher, su client-host:
    [oracle@racnode1 ~]$ srvctl stop service -d ORCLCDB_8p7_phx -s raconssvc2
    [oracle@racnode1 ~]$
  2. Notifica ricevuta sul sito 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

    Nota

    Se si imposta il proxy di Oracle Notification Server senza certificati e wallet SSL, non è necessario utilizzare -Doracle.ons.walletfile=/u01/app/client/wallet_dir per ricevere gli eventi dal servizio di database.
  3. Avviare il servizio nel nodo 1 di Oracle RAC:
    [oracle@racnode1 ~]$ srvctl start service -d ORCLCDB_8p7_phx -s raconssvc2
    [oracle@racnode1 ~]$
  4. Notifica ricevuta su 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

    Nota

    Se si imposta il proxy di Oracle Notification Server senza certificati e wallet SSL, non è necessario utilizzare -Doracle.ons.walletfile=/u01/app/client/wallet_dir per ricevere gli eventi dal servizio di database.