Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Database Performance Analyzer (DPA) > Oracle registration error

Oracle registration error

Created by Mandeville, last modified by Caroline Juszczak on Jun 08, 2017

Views: 612 Votes: 1 Revisions: 5

Updated August 2, 2016


When trying to register an Oracle instance, the wizard can error out with the following error:


org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [AnnotatedAction@34a37e84 targetAction = [RegisterMonDbAction@328c7c34 formObjectName = 'idcFormData',formObjectClass = RegisterMonDbData, formObjectScope = FLOW], attributes = map['method' -> 'calidateConnInfo']] in state 'validateConnInfo' of flow 'register-mondb-flow' -- action execution attributes were 'mapempty'


With the following error stack:


StatementCallback; SQL [SELECT tsdata.tablespace_name,tsdata.megsfree,tsdata.initial_extent,tsdata.min_extents,tsdata.next_extent,tsdata.pct_increaseDECODE (NVL (filedata.tablespace_name, ''), '', 'NO', 'YES')autoextensible FROM ( SELECT t.tablespace_name,NVL (FLOOR (SUM (f.bytes) / 1024 / 1024), 0) megsfree,

t.initial_extent,t.min_extents,t.next_extent,t.pct_increaseFROM dba_tablespaces t, dba_free_space fWHERE t.tablespace_name = f.tablespace_name(+) AND t.contents <> 'TEMPORARY' AND t.contents <> 'UNDO'

AND t.status = 'ONLINE' GROUP BY t.tablespace_name,t.initial_extent,t.min_extents,t.next_extent,t.pct_increase) tsdata,

(SELECT DISTINCT tablespace_name

FROM dba_data_files

WHERE autoextensible = 'YES' AND status = 'AVAILABLE') filedata

WHERE tsdata.tablespace_name = filedata.tablespace_name(+)

ORDER BY tablespace_name]




Any Oracle environment and version



We run this query to validate tablespace information in the target instance and it can timeout or not return expected data.



  1.  From the DPA home page, click on Options.
  2. Click on the Administration tab.
  3. Click on Advanced Options.
  4. Make sure you are on the System Options tab and make sure the support options is checked.
  5. Scroll down until you see an option ORACLE_REG_DB_USE_DEFAULT_TABLESPACE and set it to TRUE.





Last modified