Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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

Create an Oracle repository database

Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 42 Votes: 0 Revisions: 3

After you install DPA and open it for the first time, you must create a repository database.

To use an Oracle instance as the repository database:

  1. On the Select Repository Database Instance Type page, click Oracle.
  2. Click Next.

Enter 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
  • Transparent Network Substrate (TNS) Connect Descriptor
  • Lightweight Directory Access Protocol (LDAP) or TNS Name

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.

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.

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. The wizard allows you to 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

Allow DPA to create the user

SolarWinds recommends this method because DPA requires special permissions that existing users may not have.

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

Create the user manually

  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

  1. Confirm the repository information, and click Create Repository.
  2. Click Register Database Instance to Monitor to continue.
Last modified
13:51, 15 Sep 2016

Tags

Classifications

Public