Home » RDBMS Server » Server Administration » ora-01925??
ora-01925?? [message #171818] Thu, 11 May 2006 10:43 Go to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
hi all,
after doing all the pre-requisites for setting autotrace on,'
i reconnected as system. When i tried to reconnect as sys i got the following error:
ora-01925:maximum of 20 enabled roles exceeded
What could be the reason??

Thanks and regards
yasir hashmi

Report message to a moderator

Re: ora-01925?? [message #171822 is a reply to message #171818] Thu, 11 May 2006 11:01 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Increase your MAX_ENABLED_ROLES setting.

Report message to a moderator

Re: ora-01925?? [message #171934 is a reply to message #171818] Fri, 12 May 2006 06:31 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
Or try to revoke some roles from system user.

-Sai Jeedigunta

Report message to a moderator

Previous Topic: X orale
Next Topic: Configure SGA urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:29:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.