Oracle Auto Service Request

Can I configure SNMP to send alerts to Oracle ASR in Oracle Database Appliance release 19.23?

No, SNMP cannot be configured in Oracle Database Appliance release 19.23 with Oracle ASR. Starting with 19.21, ASR is configured to receive fault alerts using an XML payload over the HTTPS network of Oracle ASR Manager.

Where are the XML payload templates for Oracle ASR present?

The XML payload templates are present in the /opt/oracle/asr/asrXMLTemplates/ directory. These templates are used to create an XML payload which is populated with the required fault information and is sent to the Oracle ASR Manager for further processing. Hence, these templates must not be modified.

How is the HTTPS network of Oracle ASR Manager used?

Starting with Oracle Database Appliance release 19.21, the HTTPS network is used, instead of the HTTP network. Hence, to enable HTTPS connection between Oracle ASR Manager and Oracle Database Appliance, the HTTPS certificate of Oracle ASR manager is imported into the keystore of the DCS agent and the keystore of Java used by Oracle ASR, and the certificate of the DCS agent is imported into the keystore of Oracle ASR Manager.

How do I verify if Oracle ASR is configured correctly?

Oracle ASR configuration can be verified using the

odacli
          test-asr

command. This command tests the connection between Oracle ASR Manager, and the Oracle Database Appliance host, and Oracle ILOM. When you run the command, an email is sent to the registered email ID, if the test is successful. Following is the command output for a successful run:

Job details                                                     
----------------------------------------------------------------
                     ID:  3a3eca9e-94c8-4081-be9f-2a65962f6acf
            Description:  Test ASR
                 Status:  Success
                Created:  September 5, 2023 1:43:52 PM CST
                Message: 
  
Task Name                                Start Time                          End Time                            Status   
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Test ASR                                 September 5, 2023 1:43:52 PM CST    September 5, 2023 1:43:52 PM CST    Success

How do I list the assets configured with Oracle ASR Manager?

List the assets configured with Oracle ASR Manager with the /opt/asrmanager/bin/asr list_asset command.

[root@node1 ~]# /opt/asrmanager/bin/asr list_asset
IP_ADDRESS   HOST_NAME        SERIAL_NUMBER PARENT_SERIAL ASR ASR_STATUS PROTOCOL SOURCE   LAST_HEARTBEAT          PRODUCT_NAME      
----------   ---------        ------------- ------------- --- ---------- -------- ------   --------------          ------------      
1605NM10JF   scaoda6s003-ilom 1605NM10JF                  Y   Active     HTTP     ILOM_XML 2023-12-08 07:24:13.703 ORACLE SERVER X8-2
10.128.5.125 scaoda6s003      1605NM10JF                  Y   Active     HTTP     ESSW_XML NA                      ORACLE SERVER X8-2

Where are the logs generated by Oracle ASR stored?

The logs generated by Oracle ASR are stored in the /var/opt/asrmanager/log/ directory.

What is the difference between Oracle ASR of type internal and external ?

With Internal Oracle ASR, Oracle Database Appliance assets are registered with an Oracle ASR Manager installed and running on the same appliance. With external Oracle ASR, Oracle Database Appliance assets are registered with an Oracle ASR Manager that runs on a remote appliance.

How do I configure external Oracle ASR in Oracle Database Appliance release 19.23?

See the chapter Configuring and Using Oracle Auto Service Request in the Oracle Database Appliance Deployment and User's Guide for your hardware model.

Can I list assets if Oracle ASR is configured as external?

No, assets cannot be listed if Oracle ASR is configured as external on Oracle Database Appliance because Oracle ASR Manager is not installed on the same applaince.

Can I modify the current Oracle ASR configuration?

Yes, you can modify Oracle ASR configuration using the odacli modify-asr command for internal Oracle ASR configuration type. You cannot modify external Oracle ASR configuration with the same command because Oracle ASR is configured with an external Oracle ASR Manager. To modify external Oracle ASR configuration, you must delete the current Oracle ASR configuration with the odacli delete-asr command and configure it again with the odacli configure-asr command after updating the repository with the modified Oracle ASR configuration zip file. For the complete procedure, see the chapter Configuring and Using Oracle Auto Service Request in the Oracle Database Appliance Deployment and User's Guide for your hardware model.

What happens to the Oracle ASR configuration while patching Oracle Database Appliance from release 19.20.0.1 to 19.21 and later?

In Oracle Database Appliance release 19.20.0.1, Oracle ASR is configured with SNMP protocol for fault alerts. In release 19.21 and later, Oracle ASR is configured with an XML payload for fault alerts. Hence, if Oracle ASR was configured before patching, it must be reconfigured after updating the DCS components but before you run the odacli update-server command. This is required to ensure that Oracle ASR is configured with the new changes before the server is updated. To reconfigure Oracle ASR, delete it using the odacli delete-asr command and run the odacli configure-asr command with the same parameter values as before.

Why is the DCS agent restarted while deleting Oracle ASR?

While configuring Oracle ASR, the HTTPS certificate of Oracle ASR Manager is imported into the Java keystore of the Java installed on the appliance because the Java binaries are used by Oracle ASR Manager. While deleting Oracle ASR configuration, the imported certificate is removed from the Java keystore. Hence, after removing the certificate, DCS agent must be restarted to reload the keystore.