Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Installation Guide > Create the repository database > Create an Oracle repository database

Create an Oracle repository database

Updated: July 6, 2017

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.

To create a different type of repository database, see Create a SQL Server repository database, Create a MySQL repository database, or Create an Azure SQL repository database.

Before you start

Before you run the Repository wizard:

File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif Make sure the repository database server meets the system requirements.
File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif Install a supported version of Oracle on the database server.
File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif 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, port 8123 must be open.
File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif The SolarWinds DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.
File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif

Make sure you have credentials to a login with database administrator (DBA) privileges for the Oracle database instance.

Run the wizard

  1. To open DPA, click the button on the installation confirmation dialog, or enter one of the following URLs in a web browser:

    • http:<serverName_or_IP>:8123
    • https:<serverName_or_IP>:8124

    The Repository wizard opens automatically if the repository database has not been created.

  2. Click Create New Repository.
  3. Complete the remaining wizard panels as described in the following table.

Panel Instructions
Select Repository Database Instance Type Select Oracle as the database type.
Enter Repository Connection Information

SolarWinds DPA requires a DBA user with privileges to create a SolarWinds DPA user with access to the repository.

The DBA user is not used or stored after you complete the Repository Creation Wizard.

SolarWinds DPA creates a new Oracle schema and populates it with tables, indexes, and initial data.

Oracle database instances have three connection options:

Direct Connect

Enter the Service Name or System Identifier (SID), host name or IP address, and port. The default port is 1521.

Enter DBA credentials.

Do not use a critical production database.

Transparent Network Substrate (TNS) Connect Descriptor

The Connect Descriptor value contains everything after NAME= in the tnsnames.ora file. The beginning (DESCRIPTION= is necessary. For example:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = demo.confio.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = demo)))

Enter DBA credentials.

Lightweight Directory Access Protocol (LDAP) or TNS Name

To use this option, Oracle Name Resolution must be configured. For instructions, see Connect to Oracle using name resolution.

After you configure Oracle Name Resolution, you can use the LDAP/TNS Name when registering additional monitored database instances.

Enter DBA credentials.
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.

Minimum Oracle Parameters

db_block_buffers (or db_cache_size)

This is a critical parameter.

> 100 MB per monitored database
shared_pool_size > 50 MB
sort_area_size > 4 MB
log_buffer > 1 MB
session_cached_cursors > 10
Redo Log Size (select min(bytes) from v$log) > 10 MB
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:

  1. Next to Create New User, click Yes.
  2. Enter the user name and password.

To specify an existing account:

  1. Next to Create New User, click No.
  2. Enter the user name and password.
Specify Tablespaces for the Repository

SolarWinds DPA stores the Oracle repository in tablespaces.

  1. Select a tablespace where SolarWinds DPA stores performance data.
  2. Select a temporary tablespace for the SolarWinds DPA repository user.
Contact Information

Enter your name and email. SolarWinds DPA sends database performance reports to this address.

Summary

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.

Last modified
17:11, 7 Jul 2017

Tags

Classifications

Public