Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PlusTrace not getting enabled
<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
![]() |
![]() |