Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PlusTrace not getting enabled

RE: PlusTrace not getting enabled

From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
Date: Tue, 30 Jan 2001 15:43:13 -0800
Message-ID: <F001.002A5380.20010130154052@fatcity.com>

<FONT

color=#0000ff face=Arial size=2><SPAN
class=533261223-30012001>Hi
Sanjay,
<FONT

color=#0000ff face=Arial size=2> 
<FONT

color=#0000ff face=Arial size=2>The remarks section of PLUSTRCE.SQL<FONT color=#0000ff
face=Arial size=2>, under NOTES,<SPAN
class=533261223-30012001>
says:
<FONT

color=#0000ff face=Arial size=2> 
<FONT

color=#0000ff face=Arial size=2>" <SPAN class=533261223-30012001>...
This file must be run while logged-in as SYS.<SPAN class=533261223-30012001><FONT color=#0000ff face=Arial size=2>"
 
I
tested this and got the same errors, when I executed PLUSTRCE.SQL and granted the plustrace role as system.
<FONT color=#0000ff face=Arial

size=2> 
It
worked fine when I did both again as sys.
<FONT color=#0000ff face=Arial

size=2> 
I
hopes this helps,
<FONT color=#0000ff face=Arial

size=2> 
<FONT color=#0000ff face=Arial

size=2>Ed

    <FONT face="Times New Roman"
    size=2>-----Original Message-----From: Sanjay Kumar     [mailto:ora_user_at_hotmail.com]Sent: Tuesday, January 30, 2001 4:51     PMTo: Oracle Discussion List; Oracle List     (Telelist)Subject: PlusTrace not getting     enabled
    Hi,
     
    I ran the Plustrace.sql as user System. Then I     granted that role to user Scott. After I log in as User Scott and try to set     the autotrace on, it gives me a error      
    SP2-0618: Cannot find the Session
    Identifier.  Check PLUSTRACE role is enabledSP2-0611: Error     enabling STATISTICS report
     
    Where did I go wrong?
     
    Help appreciated.
     
    Sanjay Received on Tue Jan 30 2001 - 17:43:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US