SP2-0618: The session identifier cannot be found. Enable exam PLUSTRACE role SP2-0611: An error occurred while enabling STATISTICS reporting, sp2-0618plustrace

SP2-0618: The session identifier cannot be found. Enable exam PLUSTRACE role SP2-0611: An error occurred while enabling STATISTICS reporting, sp2-0618plustrace

Problem description and solution:

SQL * Plus: Release 11.2.0.1.0 Production on Saturday January 10 14:31:44 2015

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Enter User name: scott enter password:

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set autotrace on;

SP2-0618: The session identifier cannot be found. Enable check PLUSTRACE role

SP2-0611: An error occurred while enabling STATISTICS reports

SQL> conn/as sysdba is connected.

SQL> @ E: \ app \ test \ product \ 11.2.0 \ dbhome_1 \ sqlplus \ admin \ plustrce. SQL;

SQL> drop role plustrace;

The role has been deleted.

SQL> create role plustrace;

The role has been created.

SQL> grant select on v _ $ sesstat to plustrace;

Authorization successful.

SQL> grant select on v _ $ statname to plustrace;

Authorization successful.

SQL> grant select on v _ $ mystat to plustrace;

Authorization successful.

SQL> grant plustrace to dba with admin option;

Authorization successful.

SQL> set echo off

SQL> conn scott/scott is connected.

SQL> set autotrace on;

SP2-0618: The session identifier cannot be found. Enable check PLUSTRACE role

SP2-0611: An error occurred while enabling STATISTICS reports

SQL> conn sys/as sysdba

Enter the password: connected.

SQL> grant plustrace to public;

Authorization successful.

SQL> conn ec/ec is connected. SQL> set autotrace on;

---- Successful