Re: Error running autotrace
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- Date: Mon, 1 Dec 2008 10:01:27 -0600
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@xxxxxxxxx>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@xxxxxxxxxxxxxxxxxxx
> http://www.opitz-consulting.ch
>
> OCP 9i/10g SCSA SCNA
> =========================
>
>
>
> On Thu, Nov 27, 2008 at 5:04 PM, Dennis Williams <
> oracledba.williams@xxxxxxxxx> 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
>>
>
>
Other related posts:
