EM 12c, 13c: oracle_dbconfig Metric Collection Gives Error "ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only"
(Doc ID 2620811.1)
Last updated on DECEMBER 26, 2019
Applies to:
Enterprise Manager Base Platform - Version 13.3.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
Database configuration metrics are not collected for a standby database.
Execution of the oracle_dbconfig metric returns following errors:
$emctl control agent runCollection <DBTarget_Name>:oracle_database oracle_dbconfig
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
oracle_dbconfig:db_tablespaces:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_rollback_segs:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_options:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_dbNInstanceInfo:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_components:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_invobj_cnt:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_autotask_client:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_feature_usage:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
high_water_mark_stats:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_cpu_usage:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_users:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_services:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
oracle_dbconfig:db_tablespaces:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_rollback_segs:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_options:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_dbNInstanceInfo:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_components:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_invobj_cnt:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_autotask_client:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_feature_usage:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
high_water_mark_stats:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_cpu_usage:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_users:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
db_services:ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |