Prueba de notificación de proxy de Oracle Notification Server recibida

Siga estos pasos para probar la notificación recibida mediante el proxy de Oracle Notification Server:
  1. Pare e inicie el servicio raconssvc2 en el nodo 1 de Oracle RAC. Debe recibir eventos en fanWatcher, en client-host:
    [oracle@racnode1 ~]$ srvctl stop service -d ORCLCDB_8p7_phx -s raconssvc2
[oracle@racnode1 ~]$
  2. Notificación recibida en 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:

    Si configura el proxy de Oracle Notification Server sin certificados SSL y carteras, no necesita utilizar -Doracle.ons.walletfile=/u01/app/client/wallet_dir para recibir los eventos del servicio de base de datos.
  3. Inicie el servicio en el nodo 1 de Oracle RAC:
    [oracle@racnode1 ~]$ srvctl start service -d ORCLCDB_8p7_phx -s raconssvc2
[oracle@racnode1 ~]$
  4. Notificación recibida en 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:

    Si configura el proxy de Oracle Notification Server sin certificados SSL y carteras, no necesita utilizar -Doracle.ons.walletfile=/u01/app/client/wallet_dir para recibir los eventos del servicio de base de datos.