We are maintaining 10 internal Database through OEM 10g and using seesded reports.
When we try to create simple custom reports against one of the Target database , its failing with following error message ,
Query : select * from v$database
Error rendering element.
Exception: ORA-00942: table or view does not exist
Irrespective of any query its failing with above error. As per my understaning EM executing query against Reposistory database and not for Target.
( Example, select * from dual & v$session working , But query execution happeniing from Reposistory Database not from Target instance. )
So help us to create custom reports against Target Database .
We had the same issue but its been ages we upgraded to 12c. This is because user mgmt_view does not have access to non repository views. To make this work
grant select on v_$session to mgmt_view; OR v$database or whatever you wan an access too
For more details check metalink note for hint :
In Grid Control 10.2, Creating a Report to Query 'V$SESSION 'Fails: 'Error Rendering Element. Exception: ORA-00942 Table Or View Does Not Exist' (Doc ID 356755.1)
As you said, I have granted access to v_$database in Repository database , Now iam able to query select * from v$database.
But my requirment is to query from target database. Please guide us further.
Navigation : Reports -> Monitoring -> Database Target ( where we created custom reports ) -> MY_Report
In General Tab, we specified ''Use the specified target" to actual Target Database NAme, But still query returning form repository database value.
No there is no error, But query executing for Repository database not for Target datbase which we mentioned.
Database Instance ORCL ( parameter we specified during report submition)
Time Period Last 24 Hours EDT
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIME LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE# CONTROLFILE_TYPE CONTROLFILE_CREATED CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# CONTROLFILE_TIME OPEN_RESETLOGS VERSION_TIME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL REMOTE_ARCHIVE ACTIVATION# SWITCHOVER# DATABASE_ROLE ARCHIVELOG_CHANGE# ARCHIVELOG_COMPRESSION SWITCHOVER_STATUS DATAGUARD_BROKER GUARD_STATUS SUPPLEMENTAL_LOG_DATA_MIN SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI FORCE_LOGGING PLATFORM_ID PLATFORM_NAME RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN FLASHBACK_ON SUPPLEMENTAL_LOG_DATA_FK SUPPLEMENTAL_LOG_DATA_ALL DB_UNIQUE_NAME STANDBY_BECAME_PRIMARY_SCN
2,579,563,708 OEM Oct 13, 2010 3:21:32 PM 180,154 Oct 13, 2010 3:21:33 PM 92,680 Apr 27, 2009 4:22:50 AM NOARCHIVELOG 349,769,843 349,716,329 CURRENT Oct 13, 2010 3:21:32 PM 191,440 349,770,671 Oct 10, 2013 10:31:22 AM