ORA-20025 when running awrsqrpt.sql
I'm running awrsqrpt.sql to get an AWR report on a specific SID. It takes the start and end time values with no issue, but after I enter the SID I get the following error:
Specify the SQL Id
~~~~~~~~~~~~~~~~~~
Enter value for sql_id: 290
SQL ID specified: 290
declare
*
ERROR at line 1:
ORA-20025: SQL ID 290 does not exist for this database/instance
ORA-06512: at line 22
The SID is there and active:
SQL> select STATUS FROM V$SESSION WHERE SID=290;
STATUS
--------
ACTIVE
It's there and active, there's nothing in the knowledge base for this specific issue for ORA-20025. Any suggestions?
Barry Niconienko