执行awrrpt.sql数据库巡检时,输入snapshots id时提示错误
大家好:
我的环境是 SUSE Linux Enterprise Server 11 + Oracle 11gR2,有两个数据库: orcl 和 demo。
我在 demo 数据库中运行 awrrpt.sql 检查脚本时,在输入起始Snap Id 为 1,结束 Snap Id 为 2时,提示错误,如下:
SQL> @/oracle/product/database/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3559378370 DEMO 1 demo
Elapsed: 00:00:00.01
Elapsed: 00:00:00.01
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: text
Type Specified: text
Elapsed: 00:00:00.00
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 3559378370 1 DEMO demo SLES11
Using 3559378370 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
demo DEMO 1 13 May 2013 11:00 1
&