Create an Oracle repository database
After you install DPA, you must create the repository database, which holds the performance data that DPA collects. Use this procedure to create an Oracle repository database.
Oracle multitenant databases
You can create the DPA repository database on an Oracle pluggable database (PDB), but not a container database (CDB). If you create the repository on a PDB, the PDB can be moved:
- If the PDB is moved to another CDB on the same server, the connection string does not change. No action is required.
If the PDB is moved to a CDB on a different server, the connection string changes. You must update the connection string in the
repo.propertiesfile in the following location:
Before you start
Before you run the Repository wizard:
|Make sure the repository database server meets the system requirements.|
|Install a supported version of Oracle on the database server.|
|If you run the wizard from a different computer (not the server where DPA was installed), make sure the required firewall port is open. By default, ports 8123 and 8124 must be open.|
|The DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.|
Make sure you have credentials to a login with database administrator (DBA) privileges for the Oracle database instance.
Run the wizard
To open DPA, enter one of the following URLs in a web browser:
The Repository wizard opens automatically if the repository database has not been created.
- Click Create New Repository.
Complete the remaining wizard panels as described in the following table.
|Select Repository Database Instance Type||Select Oracle as the database type.|
|Enter Repository Connection Information||
|Repository Database Server Warnings||
If your repository database server meets the minimum requirements, the wizard skips this step.
DPA shows a report of the current Oracle parameters with values below the recommended minimum. SolarWinds recommends correcting these parameters before continuing. You can continue without fixing these parameters, but parameter values below the recommend minimums may affect the performance of the repository.
|Enter Repository Login||
DPA can create the repository administrator account, or you can specify an existing account. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.
To create a new account:
To specify an existing account:
|Specify Tablespaces for the Repository||
DPA stores the Oracle repository in tablespaces.
Enter your name and email. DPA sends database performance reports to this address.
Review the information and click Create Repository.
|Finished Repository Creation||
After the repository has been created, click Register Database Instance to start registering instances, or close the wizard and register instances later.