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) > Oracle registration error

Oracle registration error

Created by Mandeville, last modified by Aileen de Lara on Aug 02, 2016

Views: 517 Votes: 1 Revisions: 4

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
20:46, 1 Aug 2016

Tags

Classifications

Public