ORA-01722 When Selecting SQL ID At SQL Monitor On The Database Home Page
(Doc ID 2569132.1)
Last updated on AUGUST 23, 2019
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
In Enterprise Manager (EM) Cloud Control, Navigate to Database homepage --> at SQL Monitor section --> requesting drill down on running SQL IDs, the screen keeps loading.
<EM_INSTANCE_HOME>/sysman/log/emoms.trc file had the following error stack,
[EMUI_07_50_21_/console/database/instance/sqlMonitorXml] ERROR sqlmonitor.SqlMonitorDetail logp.251 - getMonitorDetailXML: Failed to initialize object: ORA-01722: invalid number
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document