今天生成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

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博客

生成AWR报告报错

最新文章