Re: Error running autotrace

Thanks Stefan. You put me on the right track. I examined the roles in the database that works and the database that didn't. When I granted the SELECT_CATALOG_ROLE, that did the trick.

Dennis

On Thu, Nov 27, 2008 at 10:10 AM, Stefan Knecht <knecht.stefan_at_gmail.com>wrote:

> What does a select * from session_roles return for the session you're
> trying to use it in ?
>
> Stefan
>
>
> =========================
>
> Stefan P Knecht
> Senior Consultant
> Systems Engineering
>
> OPITZ CONSULTING Schweiz GmbH
> Seestrasse 97
> CH-8800 Thalwil
>
> Mobile +41-79-571 36 27
> stefan.knecht_at_opitz-consulting.ch
> http://www.opitz-consulting.ch
>
> OCP 9i/10g SCSA SCNA
> =========================
>
>
>
> On Thu, Nov 27, 2008 at 5:04 PM, Dennis Williams <
> oracledba.williams_at_gmail.com> wrote:
>
>> 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