- 最后登录
- 2014-2-11
- 在线时间
- 7 小时
- 威望
- 24
- 金钱
- 69
- 注册时间
- 2012-6-12
- 阅读权限
- 10
- 帖子
- 15
- 精华
- 0
- 积分
- 24
- UID
- 495
|
1#
发表于 2012-7-26 17:54:18
|
查看: 6310 |
回复: 1
调用awrgrpt.sql对RAC进行RAC 全局awr收集发现报错:
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 3656
Begin Snapshot Id specified: 3656
Enter value for end_snap: 3657
End Snapshot Id specified: 3657
insts AWRRPT_INSTANCE_LIST_TYPE;
*
ERROR at line 15:
ORA-06550: line 15, column 11:
PLS-00201: identifier 'AWRRPT_INSTANCE_LIST_TYPE' must be declared
ORA-06550: line 15, column 11:
PL/SQL: Item ignored
ORA-06550: line 47, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 48, column 4:
PL/SQL: ORA-00904: : invalid identifier
ORA-06550: line 46, column 4:
PL/SQL: SQL Statement ignored
库的环境是:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
然后打开awrgrpt.sql此脚本发现调用顺序awrgrpt.sql-》awrgdrpi.sql-》awrgdinp.sql
如果单独运行awrgdinp.sql还是报错,而且错误一样,可以定位awrgdinp.sql脚本出现错误
然后在测试环境也是了一下,调用两个脚本都报错?
=========================
请问刘大这两个脚本是不是有bug? |
|