SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report


C:\Users\Administrator>sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 18:12:15 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> create user DB_TEST identified by TEST;
create user DB_TEST identified by TEST
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8

SQL> create user DB_TEST identified by Oracle123_Anar
 2 ;
User created.
SQL>
SQL>
SQL> grant create session to DB_TEST;
Grant succeeded.
SQL> grant select on sys.anar to DB_TEST;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Users\Administrator>
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 18:16:26 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn DB_TEST/Oracle123_Anar
Connected.
SQL>
SQL> sho user
USER is "DB_TEST"
SQL>
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL>
C:\Users\Administrator>sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 18:19:30 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> drop role plustrace;
drop role plustrace
 *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist

SQL>
SQL> create role plustrace;
Role created.
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$statname to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL>
SQL> grant plustrace to DB_TEST
 2 ;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 18:30:56 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn DB_TEST/Oracle123_Anar
Connected.
SQL>
SQL>
SQL> set autotrace on
SQL> select * from sys.anar;
no rows selected

Execution Plan
----------------------------------------------------------
Plan hash value: 340375921
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 13 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| ANAR | 1 | 13 | 2 (0)| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
 - dynamic sampling used for this statement (level=2)

Statistics
----------------------------------------------------------
 1 recursive calls
 0 db block gets
 4 consistent gets
 0 physical reads
 0 redo size
 282 bytes sent via SQL*Net to client
 408 bytes received via SQL*Net from client
 1 SQL*Net roundtrips to/from client
 0 sorts (memory)
 0 sorts (disk)
 0 rows processed
SQL>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: