Home » RDBMS Server » Server Administration » How to increase the MAX_ENABLED_ROLES for SYS?
How to increase the MAX_ENABLED_ROLES for SYS? [message #369878] Tue, 31 October 2000 18:59 Go to next message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi!

I got the following error:

ORA-01925 maximum of string enabled roles exceeded

Cause: The initialization parameter MAX_ENABLED_ROLES has been exceeded.

Action: Increase MAX_ENABLED_ROLES and warm start the database.

How to increase the MAX_ENABLED_ROLES for SYS?

In which table or View I can Update the above one?

Thnaks and Regards
Suresh

Report message to a moderator

Re: How to increase the MAX_ENABLED_ROLES for SYS? [message #369885 is a reply to message #369878] Thu, 02 November 2000 01:20 Go to previous message
AndreaB
Messages: 5
Registered: October 2000
Junior Member
The parameter must be set in the file INITXXX.ORA
the default value is 20
Yuo must add to your file a line like that:
MAX_ENABLED_ROLES=30

Report message to a moderator

Previous Topic: how to create pl/sql tables and how to manupulate data in that
Next Topic: Oracle8.1.6 doesn't work well
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 14:51:04 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.