OCI Database Management Service Does Not List Management Data For Tablespace And Other Parameters
(Doc ID 2974156.1)
Last updated on OCTOBER 03, 2023
Applies to:
OCI Database Management Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
On OCI Console, For a Pluggable Database, Navigating to Observability & Management -> Database Management -> Fleet summary -> Managed database details -> Resources -> Management
No data is showing for the options below.
Tablespaces
Users
Database parameters
Cluster cache
Jobs
Error :
A problem was encountered: QueryExecutionFailed: ORA-00942: table or view does not exist
If the problem persists, contact Oracle support and provide the following opc-request-id: <PC-REQUEST-ID>
A problem was encountered: QueryExecutionFailed: ORA-00942: table or view does not exist
If the problem persists, contact Oracle support and provide the following opc-request-id: <PC-REQUEST-ID>
Navigating to Performance Hub also throwing below message.
GRANT CREATE PROCEDURE to <MONITORING_USER> ;
GRANT SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE to <MONITORING_USER> ;
GRANT ALTER SYSTEM to <MONITORING_USER>;
GRANT ADVISOR to <MONITORING_USER>;
GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <MONITORING_USER>;
GRANT SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE to <MONITORING_USER> ;
GRANT ALTER SYSTEM to <MONITORING_USER>;
GRANT ADVISOR to <MONITORING_USER>;
GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <MONITORING_USER>;
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 |