Hi Sanjay,
 
The remarks section of PLUSTRCE.SQL, under NOTES, says:
 
" ... This file must be run while logged-in as SYS."
 
I tested this and got the same errors, when I executed PLUSTRCE.SQL and granted the plustrace role as system.
 
It worked fine when I did both again as sys.
 
I hopes this helps,
 
Ed
-----Original Message-----
From: Sanjay Kumar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 4:51 PM
To: 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 enabled
SP2-0611: Error enabling STATISTICS report
 
Where did I go wrong?
 
Help appreciated.
 
Sanjay

Reply via email to