Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Database Performance Analyzer (DPA) > Error registering Oracle database in DPA Map Empty

Error registering Oracle database in DPA Map Empty

Created by Robert Holtam, last modified by Jamin Walters on Sep 27, 2016

Views: 16 Votes: 2 Revisions: 7

Overview

You get the following error when trying to register an Oracle instance:

 

Environment

DPA version 9.1.85 and later

Cause 

This occurs during the building of the TEMP TABLESPACE and TABLESPACE drop-down lists of the second wizard screen.

 

Since there is a failure building the lists, the web-flow dumps a stack trace. Other possible cause is the Oralce recycle bin on the Repository database being full. 

 

The source code fix is to catch the DataAccessException thrown by Spring JDBC and log the error, and then proceed with a new status of DATAFILE_ACCESS_ERROR, which causes the application to use the database's default tablespaces.

 

 

Resolution

Check that the Oracle repository recycle bin is not full. 

 

Set the system property ORACLE_REG_DB_USE_DEFAULT_TABLESPACES=true.

This will force the wizard to only display SYSTEM - Default for the Tablespace, and TEMP - Default for the Temp Tablespace.

 

From the DPA home page, Go to Options>Administration Tab>Advanced Options>Support Options Tab and search for

" ORACLE_REG_DB_USE_DEFAULT_TABLESPACES

Click on the name to display the Edit Option box, click the drop down arrow and set to "True" and click the update button.

 

 

Last modified
14:03, 27 Sep 2016

Tags

Classifications

Public