Error running autotrace

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 27 Nov 2008 10:04:34 -0600
Message-ID: <de807caa0811270804y3131f8e5x186e53003fe99588@mail.gmail.com>


List,

I'm trying to run autotrace. The database is 10.2.0.4. On one database this ran fine with me doing nothing. On two other databases, I get the following error.

SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report I have read the SQLPLUS manual, and Googled online for this error. I have dropped and recreated the PLUSTRACE role and granted it to the schema where I want to run this.
No luck.

Can anyone think of what I may be overlooking?

Thanks,
Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 27 2008 - 10:04:34 CST

Original text of this message