Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 35 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
07:20, 8 Jun 2017

Tags

Classifications

Public