Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Adding Oracle Databases

Register database

Firstly, register new monitored Oracle Database(s) with APPM by navigating to Repository -> Databases -> Create Database. Following fields are required:

  • Collector Name - name of database and also name of Postgres schema containing its samples. Use lowercase when possible.
  • Connection String - TNS Connection string in format hostname:port/service_name.
  • APPM Schema - Name of Oracle Database schema that will be created in one of the following steps.
  • History Days - Samples older than this number of days are automatically deleted from repository.

Note

This step won’t touch your database yet.

Create / Upgrade Schema

Important

This step creates/updates APPM2 and APPM_COLLECTOR schemas on your Oracle database.

Navigate to Repository -> Databases. Then follow either Automatic or Manual method.

Automatic Method

Select Oracle database(s) on which you wish to create/upgrade APPM2 and APPM_COLLECTOR schemas and click Upgrade Schema button (it creates the schemas if they don’t yet exist). You will need to enter SYSDBA credentials in order to allow APPM to create them.

Note that every SQL sent to Oracle database during the installation of those schemas is logged in /srv/appm/vol/wf-log/server.log.

Manual Method

or, if you don’t want to provide SYSDBA credentials, click appm.sql link to download the script and execute it yourself as sqlplus / as sysdba @appm.sql. Then do the same with collector.sql.

Additional Information

Installation will create/update APPM2 schema which includes views to V$ performance views. It does not include any data, because samples are stored in separate repository database.

Global objects that are created as a part of APPM installation are named like APPM_<NAME>, where APPM_ is a constant prefix.

Created schema could take up to 250MB of disk space.

Post-Installation

Restart following services in order to force APPM collector to reconnect:

systemctl restart aba-appm
systemctl restart appm_collector # optional and only available in EE edition