Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PLUSTRACE
$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 ...Received on Sat Mar 25 2000 - 00:00:00 CST
>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.