Applications Systems

Oracle RAC registration error on tablespace in DPA

This article shows information when registering an Oracle RAC database and throws an error on a tablespace query

First published date

11/2/2018 4:10 PM

Last published date

4/22/2025 3:12 PM

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]

Product section

Database Performance Analyzer

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.