测试收到 Oracle Notification Server 代理通知
执行以下步骤以测试使用 Oracle Notification Server 代理收到的通知:
- 在 Oracle RAC 节点 1 上停止并启动服务 raconssvc2。您应在
fanWatcher
的client-host
上收到活动:[oracle@racnode1 ~]$ srvctl stop service -d ORCLCDB_8p7_phx -s raconssvc2 [oracle@racnode1 ~]$
- 在
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
即可从数据库服务接收事件。 - 在 Oracle RAC 节点 1 上启动服务:
[oracle@racnode1 ~]$ srvctl start service -d ORCLCDB_8p7_phx -s raconssvc2 [oracle@racnode1 ~]$
- 在
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
即可从数据库服务接收事件。