|
|
我在Oracle10.2.0.4 3个节点集群环境里的第一个节点收集AWR报告报错信息如下：
SQL> @awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1399337475 ASOM 1 asom1
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type:
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from dba_hist_database_instance wr, v$database cd, v$instance ci
*
ERROR at line 13:
ORA-04063: view "SYS.DBA_HIST_DATABASE_INSTANCE" has errors
Using 1399337475 for database Id
Using 1 for instance number
from dba_hist_database_instance
*
ERROR at line 5:
ORA-06550: line 5, column 13:
PL/SQL: ORA-04063: view "SYS.DBA_HIST_DATABASE_INSTANCE" has errors
ORA-06550: line 4, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 11, column 13:
PL/SQL: ORA-04063: view "SYS.DBA_HIST_SNAPSHOT" has errors
ORA-06550: line 10, column 6:
PL/SQL: SQL Statement ignored
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
asom_db01$
麻烦大家帮我分析是什么问题导致的，谢谢。
|
|
发表于 2014-7-10 20:36:26
发表于 2014-7-13 10:58:49
楼主
