生成AWR报告报错

今天生成oracle AWR报告的时候，报错SP2-0042，这里小记一下。现在还不知道是什么原因造成的，请有

知道的指点一下。

OS：AIX
DB：10.2.0.4.0

$cd $ORACLE_HOME/rdbms/admin

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 16 12:11:18 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @awrrpt.sql
SP2-0042: unknown command "awrrpt.sql" - rest of line ignored.

将@替换成start执行
SQL> start awrrpt.sql

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1072320112 ORACLE              1 oradb1

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:

现在可以正常生成AWR报告。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25373498/viewspace-752800/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25373498/viewspace-752800/