Error Enabling Statistics Report
Contents |
2012 - 3:30 am UTC Category: SQL*Plus – Version: 8.1.7 Latest Followup You Asked Hi Tom When I enter the statement set autotrace on i get the following sp2-0618: cannot find the session identifier. error. SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611:
Ora-01919: Role 'plustrace' Does Not Exist
Error enabling STATISTICS report How can solve it? and we said... set up autotrace... http://asktom.oracle.com/~tkyte/article1/autotrace.html has sp2-0612: error generating autotrace explain report a howto. Reviews Write a Review Tom September 28, 2002 - 1:21 pm UTC Reviewer: khalid from Yemen Thank you correct your script February 08, 2003 - 4:56 pm UTC Reviewer: what is plustrace role in oracle A reader cd $oracle_home/rdbms/admin log into sqlplus as system run SQL> @utlxplan run SQL> create public public synonym plan_table for plan_table run SQL> grant all on plan_table to public exit sqlplus and cd $oracle_home/sqlplus/admin log into sqlplus as SYS run SQL> @plustrce run SQL> grant plustrace to public Tom Please correct create public public synonym plan_table for plan_table Remove extra public
Sp2-0611 Error Enabling Statistics Report 11g
Secondly why cant I run plustrce connect as system, and why should I log out and login again... Lastly why cant I run all the above scripts connected as scott.. thanks Followup February 09, 2003 - 3:11 pm UTC removed the extra public.... you need to "log out and login" again because I want you to create the table as system -- but the grants need to be run as "sys" or "sysdba" because a) scott cannot create a public synonym b) scott cannot run plustrce.sql successfully. Why 'SYS' why not 'SYSTEM' February 09, 2003 - 9:48 pm UTC Reviewer: Nasser Tom I understand that SCOTT does not have necessary privileges to create public synonyms and create roles. But system does have those abilities, so then why connect as SYS why not as system and create the public synonym, and run the plustrce.sql script. Followup February 09, 2003 - 9:54 pm UTC Confusion on my part here. system does the public synonym: You ask " so then why connect as SYS why not as system and create the public synonym," well, SYSTEM crea
Role If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have set autotrace on to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: PLUSTRACE Role Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to https://asktom.oracle.com/pls/asktom/f?p=100:11:7768666760391491::::P11_QUESTION_ID:5671636641855 Hybrid Mode Switch to Threaded Mode 12-12-2002,12:39 AM #1 pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 PLUSTRACE Role Hi everybody, How do i enable the plustrace role?? when i write SET AUTOTRACE ON I get the foloo error.. SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled http://www.dbasupport.com/forums/showthread.php?32261-PLUSTRACE-Role SP2-0611: Error enabling STATISTICS report what should be the problrm.. thanks pras Reply With Quote 12-12-2002,02:03 AM #2 grjohnson View Profile View Forum Posts Senior Advisor Join Date Apr 2001 Location Brisbane, Queensland, Australia Posts 1,203 GRANT PLUSTRACE TO user; OCP 8i, 9i DBA Brisbane Australia Reply With Quote 12-12-2002,03:53 AM #3 pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 Hi while granting the role plustrace to the user it gives me the error role plustrace does not exist... SQL> grant plustrace to scott; grant plustrace to scott * ERROR at line 1: ORA-01919: role 'PLUSTRACE' does not exist thanks pras Reply With Quote 12-12-2002,04:09 AM #4 Sameer View Profile View Forum Posts Advisor Join Date Sep 2001 Location Düsseldorf, Germany. Posts 588 Have you execute $ORACLE_HOME/sqlplus/admin/plustrce.sql file ?? This file must be run while logged-in as SYS. Sameer Reply With Quote 12-17-2002,06:28 AM #5 pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 Hi
Oracle Ä°ntroduction · Leave a comment 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 https://anargodjaev.wordpress.com/2014/03/10/sp2-0618-cannot-find-the-session-identifier-check-plustrace-role-is-enabled-sp2-0611-error-enabling-statistics-report/ 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 http://myorastuff.blogspot.com/2008/06/how-do-we-enable-autotrace-on-oracle.html 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 ; error enabling 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. error enabling statistics 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
Release 9.2.0.1.0 - ProductionPL/SQL Release 9.2.0.1.0 - ProductionCORE 9.2.0.1.0 ProductionTNS for 32-bit Windows: Version 9.2.0.1.0 - ProductionNLSRTL Version 9.2.0.1.0 - ProductionIf we don't set the autotrace, then we get the below error.SQL> connect scott/tiger@dba1Connected.SQL> set autotrace onSP2-0613: Unable to verify PLAN_TABLE format or existenceSP2-0611: Error enabling EXPLAIN reportSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSQL>Here are the steps to resolve the error.Step 1 Run the plustrace.sql file on sys schema.In windows, the plustrace file is residing at @$ORACLE_HOME\sqlplus\admin\plustrce.sqlIn UNIX, the plustrace file is residing at @$ORACLE_HOME/sqlplus/admin/plustrce.sqlSQL> start d:/oracle/ora92/sqlplus/admin/plustrce.sqlSQL>SQL> drop role plustrace;drop role plustrace*ERROR at line 1:ORA-01919: role 'PLUSTRACE' does not existSQL> create role plustrace;Role created.SQL>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_$session to plustrace;Grant succeeded.SQL> grant plustrace to dba with admin option;Grant succeeded.SQL>SQL> set echo offSQL>Step 2Grant the plustrace role to Scott schema.SQL> connect sys/password@dba1 as sysdbaConnected.SQL> grant plustrace to scott;Grant succeeded.SQL>Step 3Create the plan_table on sys schema and grant select privileges to Scott schema.SQL> connect sys/password@dba1 as sysdbaConnected.SQL> CREATE TABLE PLAN_TABLE (2 statement_id varchar2(30),3 plan_id number,4 timestamp date,5 remarks varchar2(4000),6 operation varchar2(30),7 options varchar2(255),8 object_node varchar2(128),9 object_owner varchar2(30),10 object_name varchar2(30),11 object_alias varchar2(65),12 object_instance numeric,13 object_type varchar2(30),14 optimizer varchar2(255),15 search_columns number,16 id numeric,17 parent_id numeric,18 depth numeric,19 position numeric,20 cost num