Home » SQL & PL/SQL » SQL & PL/SQL » SP2-0310: unable to open file when running AWR report (10.2.0.4.0, Sun 5.8)
SP2-0310: unable to open file when running AWR report [message #533952] Thu, 01 December 2011 23:40 Go to next message
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

Re: SP2-0310: unable to open file when running AWR report [message #533954 is a reply to message #533952] Thu, 01 December 2011 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>SP2-0310: unable to open file "/usr/local/oracle/product/9.2.0/rdbms/admin/awrrpt.sql"

AWR did not exist in V9.2, as best as I recall.
Re: SP2-0310: unable to open file when running AWR report [message #533955 is a reply to message #533952] Thu, 01 December 2011 23:43 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Please past the "awrrpt.sql" script. you are working windows or unix?
Re: SP2-0310: unable to open file when running AWR report [message #533957 is a reply to message #533954] Thu, 01 December 2011 23:46 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Yes awrrpt.sql does not exist in the following path.

$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory


What to do in such case ?


Thanks
Re: SP2-0310: unable to open file when running AWR report [message #533977 is a reply to message #533957] Fri, 02 December 2011 00:52 Go to previous message
Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use the correct Oracle home version.

Regards
Michel
Previous Topic: Syntax Why ?
Next Topic: query on v$session - status column
Goto Forum:
  


Current Time: Sat Aug 02 00:19:29 CDT 2025