ORA-01925: maximum of 20 enabled roles exceeded

I'm new to Oracle (<48hrs) and need to figure out how to set the max number of roles. This is 8i on NT and I recieve the error while trying to login as SYS via SQL Plus. Thanks for the help
patrickwmcleanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sudhi022299Connect With a Mentor Commented:
increase the initialization parameter MAX_ENABLED_ROLES to a higher value and then retstart your instance.

Regards,
Sudhi.
0
 
sudhi022299Commented:
if you need the steps to do it post a comment.
0
 
sudhi022299Commented:
8i on nt platform ?

hmmmm...
let me get the directory structure correct.

c:\orant\database\initorcl.ora --- this is the file for Oracle8 but for 8i they changed it to just init.ora and it'll be aviable in a directory called as "orcl". Just do a search for this dir and you'll get the file.

Open the file and specify
MAX_ENABLED_ROLES = 50

or any higher value than that is already present in the file.

Save the file.

go to a command prompt.
c:\> svrmgrl.exe

svrmgr> connect internal/oracle
connected.
svrmgr> shutdown
.....
....
svrmgr> startup

After you get the message "databse opened" , try connecting to the db.

Regards,
Sudhi.
0
 
patrickwmcleanAuthor Commented:
Thanks that did the trick...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.