sys user not connecting

[sri_dba]

Hi Everyone,

My sys user is not connecting.The following error msg i got.

ORA-01925: maximum of 20 enabled roles exceeded
Warning: You are no longer connected to ORACLE.

My parameter shows [ max_enabled_roles = 20] in my sql.

But i am unable to find the same in my init.ora file.
How can i change the max_enabled_roles value into init.ora file.

Pls help.Thanx in advance.

[TimHall]

Hi.

If it's not in your init.ora then add it:

max_enabled_roles=100

Then restart your instance.

Cheers

[gnagesh]

Originally posted by sri_dba
Hi Everyone,

My sys user is not connecting.The following error msg i got.

ORA-01925: maximum of 20 enabled roles exceeded
Warning: You are no longer connected to ORACLE.

My parameter shows [ max_enabled_roles = 20] in my sql.

But i am unable to find the same in my init.ora file.
How can i change the max_enabled_roles value into init.ora file.

Pls help.Thanx in advance.

Try this.

shutdown the database and increase the value of the
init.ora file parameter max_enabled_roles to a value greater than the default will resolve this problem.

Alternatively try INTERNAL to connect.


Hope this helps.

[sri_dba]

Thanx for ur answer.

I have one more doubt, my init.ora is not showing the max_enbled_roles.
But my show parameter command shows max_enabled_roles = 20.

is it possible, it would be great if u clear this doubt.

[adewri]

Add the line
max_enabled_roles = 100
to ur init parameter file.

[sri_dba]

Thanx a lot .It works fine.

[efrijters]

Originally posted by sri_dba

I have one more doubt, my init.ora is not showing the max_enbled_roles.
But my show parameter command shows max_enabled_roles = 20.

is it possible, it would be great if u clear this doubt.

MAX_ENABLED_ROLES has a default value of 20 and because of that the parameter doesn't have to be in the init.ora. If you want to overrule the default value, then you must specify it in the init.ora.

I hope this takes the doubt away.

Erik

[sri_dba]

Now I am so clear.Thanx a lot and it works fine now.

Srini