To use the AlienApp for Oracle Database in USM Anywhere, you need to enable the audit trail in Oracle Database and grant audit access to the Oracle Database user account that will be connected to USM Anywhere.
Set Up Oracle Audit Trail
To turn on the audit trail for Oracle Database, refer to the Oracle documentation Enabling or Disabling the Standard Audit Trail.
To grant audit access for the user account
Log into Oracle Database by entering the Oracle Service Identifier (SID) password with the following command:
Once you have logged in, enable audit access for the user with the following command:
AUDIT ALL BY <USER> BY ACCESS
Connecting the AlienApp for Oracle Database in USM Anywhere
After obtaining the credentials, you must configure the connection within USM Anywhere.
To enable the AlienApp for Oracle Database
- In USM Anywhere, go to Data Sources > AlienApps.
- Click the Available Apps tab.
- Search for the AlienApp, and then click the tile.
- Click Configure API.
If you have more than one deployed USM Anywhere Sensor, select the sensor that you want to use for the enabled AlienApp.
AlienApps operate through a deployed sensor and use APIs to integrate with the connected third-party technology. Select the sensor that can access the integration endpoint. The HTTPS connections to the API will originate from this sensor, so it is important to make sure the sensor has network access to the AlienApp API endpoints.
Enter your Oracle information into the following fields:
- Database Host Name
- Port number
- Oracle Service Identifier (SID)
- Click Save.
Verify the connection.
After USM Anywhere completes a successful connection to the Oracle Database APIs, a icon displays in the Health column.
If the icon displays, there is a problem with the connection. The Message column provides information about the issue. Repeat the steps to fix the configuration or troubleshoot your Oracle Database connection.