One of client’s OEM agent is working fine, but OEM console show “Agent Unreachable’ for this agent and all the other targets monitored by this agent.
Read more of this content when you subscribe today.
After two nodes OMS upgraded to new version, when clicking BI Publisher Enterprise Reports, the follow error “Server not initialized. Please make sure the repository is ready.” occurs:
Sometimes you might get the following errors:
“Cannot retrieve the list of reports from BI Publisher. Enterprise Manager cannot establish a connection to BI Publisher.”
Read more of this content when you subscribe today.
The status of the materialized view with 30 million records is ‘UNUSABLE’, so a complete refresh is required to fix this problem .
The complete refresh process ran for 3 hours, then we have to kill it.
SQL> execute dbms_mview.refresh(MVIEW1','c');
^C^C
^C^C^C^C^C^C^C
BEGIN dbms_mview.refresh('MVIEW1','c'); END;
*
ERROR at line 1:
ORA-12152: TNS:unable to send break message
Elapsed: 03:11:16.16
There are a couple of following ways to speed up this complete refresh, one of them only takes 27 minutes.
Read more of this content when you subscribe today.
The materialized view was in good status until when changes its refresh mode:
SQL> select MVIEW_NAME,REFRESH_MODE,REFRESH_METHOD,STALENESS
dba_mviews
where mview_name='MVIEW1';
MVIEW_NAME REFRES REFRESH_ STALENESS
-------------- ---------- --------- ----------
MVIEW1 COMMIT FAST FRESH
SQL> alter materialized view MVIEW1 refresh fast on demand;
SQL> select MVIEW_NAME,REFRESH_MODE,REFRESH_METHOD,STALENESS
dba_mviews
where mview_name='MVIEW1';
MVIEW_NAME REFRES REFRESH_ STALENESS
-------------- ---------- --------- ------------------
MVIEW1 COMMIT FAST COMPILATION_ERROR
SQL> alter materialized view MVIEW1 compile;
Materialized view altered.
SQL> select MVIEW_NAME,REFRESH_MODE,REFRESH_METHOD,STALENESS
dba_mviews
where mview_name='MVIEW1';
MVIEW_NAME REFRES REFRESH_ STALENESS
-------------- ---------- --------- --------------------
MVIEW1 COMMIT FAST UNUSABLE
It might be a bug ? not quite sure why. In this situation, the materialized view has to be refreshed completed or rebuilt.
This post demonstrates how to create and maintain a materialized view refresh group in Oracle database.
Read more of this content when you subscribe today.
Make DBA Life Easy 