Thursday, November 27, 2014

SP2-0618: Cannot find the Session Identifier.

Today I could not enabled autorace and reason was SP2-0618.

After looking for in google I found solution and now want to share it.

 SQL> set autotrace traceonly;   
 SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled   
 SP2-0611: Error enabling STATISTICS report  

To enable autotrace PLUSTRACE role should be exists! If not exists create it.

Under $ORACLE_HOME\sqlplus\admin\ you may execute by SYS user

 SQL> @$ORACLE_HOME\sqlplus\admin\plustrce.sql; 

Another way you may just manually create plustrace role and assign select on necessary views;

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. 

At the end grant plustrace role to needed user;
SQL> grant plustrace to ulfet;   
Grant succeeded. 

No comments:

Post a Comment

Cannot access dba_directories inside procedure

 Recently I faced one of familiar Oracle error ORA -00942 : table or view does not exist   I got it in while compiling procedure, becaus...