Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

24

积分

0

好友

0

主题
1#
发表于 2012-7-26 17:54:18 | 查看: 6339| 回复: 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?
2#
发表于 2012-7-26 17:55:23
在网上找了几个地方都没有,看到此错误的解决,希望刘大解释一下

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-25 14:40 , Processed in 0.044279 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569