測試收到的 Oracle Notification Server 代理主機通知

請依照下列步驟，測試使用 Oracle Notification Server 代理主機收到的通知：
  1. 在 Oracle RAC 節點 1 上停止並啟動服務 raconssvc2。您應該會在 client-host 上接收關於 fanWatcher 的事件：
    [oracle@racnode1 ~]$ srvctl stop service -d ORCLCDB_8p7_phx -s raconssvc2
[oracle@racnode1 ~]$
  2. 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

    附註：

    如果您在沒有 SSL 憑證和公事包的情況下設定 Oracle Notification Server 代理主機，就不需要使用 -Doracle.ons.walletfile=/u01/app/client/wallet_dir 從資料庫服務接收事件。
  3. 在 Oracle RAC 節點 1 上啟動服務：
    [oracle@racnode1 ~]$ srvctl start service -d ORCLCDB_8p7_phx -s raconssvc2
[oracle@racnode1 ~]$
  4. 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

    附註：

    如果您在沒有 SSL 憑證和公事包的情況下設定 Oracle Notification Server 代理主機，就不需要使用 -Doracle.ons.walletfile=/u01/app/client/wallet_dir 從資料庫服務接收事件。