ash report failing

I was trying to run the ash report it is failing..

This is the script

SYS@EWGEN5P SQL> RETURN awrrpt_html_type_table PIPELINED;
SP2-0734: unknown command beginning "RETURN awr..." - rest of line ignored.
SYS@EWGEN5P SQL>select name from v$database;

NAME
---------
EWGEN5P

SYS@EWGEN5P SQL>exitoracle@puchdsclgen5001:/appl/oracle/EWGEN5P/exp01/exp[EWGEN5P]:
===> sqlplus / as sysdba
SP2-0734: unknown command beginning "exitoracle..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "===> sqlpl..." - rest of line ignored.
SYS@EWGEN5P SQL>
SYS@EWGEN5P SQL>SQL*Plus: Release 11.2.0.2.0 Production on Thu Apr 3 08:51:30 2014
SP2-0734: unknown command beginning "SQL*Plus: ..." - rest of line ignored.
SYS@EWGEN5P SQL>
SYS@EWGEN5P SQL>Copyright (c) 1982, 2010, Oracle.  All rights reserved.
SP2-0734: unknown command beginning "Copyright ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>
SYS@EWGEN5P SQL>
SYS@EWGEN5P SQL>Connected to:
SP2-0734: unknown command beginning "Connected ..." - rest of line ignored.
SYS@EWGEN5P SQL>Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
SP2-0734: unknown command beginning "Oracle Dat..." - rest of line ignored.
SYS@EWGEN5P SQL>With the Partitioning, OLAP, Data Mining and Real Application Testing options
  2
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>DBMS_WORKLOAD_REPOSITORY.ASH_REPORT_HTML(
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>   l_dbid          IN NUMBER,
SP2-0734: unknown command beginning "DBMS_WORKL..." - rest of line ignored.
SP2-0224: invalid starting line number
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0734: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_inst_num      IN NUMBER,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SYS@EWGEN5P SQL>   l_btime         IN DATE,
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_etime         IN DATE,
   l_options       IN NUMBER    DEFAULT 0,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0224: invalid starting line number
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_slot_width    IN NUMBER    DEFAULT 0,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_sid           IN NUMBER    DEFAULT NULL,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>   l_sql_id        IN VARCHAR2  DEFAULT NULL,
SP2-0223: No lines in SQL buffer.
SP2-0224: invalid starting line number
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SYS@EWGEN5P SQL>   l_wait_class    IN VARCHAR2  DEFAULT NULL,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_service_hash  IN NUMBER    DEFAULT NULL,
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SYS@EWGEN5P SQL>   l_module        IN VARCHAR2  DEFAULT NULL,
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_action        IN VARCHAR2  DEFAULT NULL,
SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_client_id     IN VARCHAR2  DEFAULT NULL,
SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL>   l_plsql_entry   IN VARCHAR2  DEFAULT NULL)
SP2-0223: No lines in SQL buffer.
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0223: ..." - rest of line ignored.
SYS@EWGEN5P SQL>SYS@EWGEN5P SQL> RETURN awrrpt_html_type_table PIPELINED;
SP2-0734: unknown command beginning "RETURN awr..." - rest of line ignored.
SYS@EWGEN5P SQL>select name from v$database;
SP2-0734: unknown command beginning "SYS@EWGEN5..." - rest of line ignored.
SYS@EWGEN5P SQL>SP2-0734: unknown command beginning "SP2-0734: ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
tonydbaAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
It looks like you have copied some commands and pasted them into sqlplus.

It looks like it might have been a shell script not a SQL script.

If it is a shell script, it needs to be executed from the Unix prompt not a sqlplus prompt.

If you can show what it is you are trying to run or where you got it from, we can offer additional advice.
0
 
tonydbaAuthor Commented:
I am wrong from my side ...I realize the mistake
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.