SP2-0310: unable to open file when running AWR report [message #533952] |
Thu, 01 December 2011 23:40  |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
 
|
|
Hi,
When i run the awr report from sqlplus , i get below error message.
Quote:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL>
SQL> @?/rdbms/admin/awrrpt
SP2-0310: unable to open file "/usr/local/oracle/product/9.2.0/rdbms/admin/awrrpt.sql"
SQL>
Also i dont find the awrrpt.sql in the following path.
Quote:
$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory
$
Is it something related to permissions on file ?
Please tell me how to run the awr report ?
Thanks
[Updated on: Thu, 01 December 2011 23:44] Report message to a moderator
|
|
|
|
|
|
|