Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 69 Votes: 1 Revisions: 5

Updated August 2, 2016

Overview

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]

 

 

Environment

Any Oracle environment and version

 

Cause 

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

 

Resolution

  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

Tags

Classifications

Public