Re: PLUSTRACE

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: 2000/03/25
Message-ID: <ki4D4.19648$mf.1528049@bgtnsc05-news.ops.worldnet.att.net>#1/1

That's got it!

Regards from Washington, DC

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message news:953993837.23596.0.nnrp-11.9e984b29_at_news.demon.co.uk...
>
> $ORACLE_HOME/sqlplus/admin/plustrce.sql
>
> Watch out for max_enabled_roles. This defaults
> to 20, and SYS had 20 roles enabled on installation
> of the primary database.
>
> Consequently when I first ran Plustrce.sql it pushed
> SYS's roles up to 21, and any attempt to connect
> as sys led to error 1925 -
> maximum ot 20 enabled roles exceeded.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Buck Turgidson wrote in message ...
> >That's what I thought, too, but I don't find it in
$ORACLE_HOME/rdbms/admin.
> >Grepping through the modules doesn't reveal anything, either.
> >
> >
> >Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> >news:953987718.18697.0.pluto.d4ee154e_at_news.demon.nl...
> >> Run plustrc.sql (top of my head) and I don't remember the exact
directory.
> >> Anyway there's a script for it.
>
>
>
Received on Sat Mar 25 2000 - 00:00:00 CST