OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01925 (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01925 [message #419966]

Wed, 26 August 2009 05:29

samirorafaq
Messages: 10
Registered: August 2009
Location: INDIA

Junior Member

during log-in process.....getng a error "ORA-01925 maximum of 60 enabled roles exceeded"

try to change the parameter MAX_ENABLED_ROLES in init.ora files...but could not find the such file....

OS is Windows xp
and database is oracle9i

Please help...........

Report message to a moderator

Re: ORA-01925 [message #419981 is a reply to message #419966]

Wed, 26 August 2009 05:55

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you can't find the file how we that have no access to your server can help? Wink

Check if you are not working with a spfile:
show parameter spfile

Regards
Michel

Report message to a moderator

Re: ORA-01925 [message #419989 is a reply to message #419981]

Wed, 26 August 2009 06:35

samirorafaq
Messages: 10
Registered: August 2009
Location: INDIA

Junior Member

ya it is spfile

Report message to a moderator

Re: ORA-01925 [message #419995 is a reply to message #419989]

Wed, 26 August 2009 07:07

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

alter system set MAX_ENABLED_ROLES =... scope=spfile
and restart

Regards
Michel

Report message to a moderator

Re: ORA-01925 [message #420063 is a reply to message #419966]

Wed, 26 August 2009 18:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>during log-in process.....getng a error "ORA-01925 maximum of 60 enabled roles exceeded"
I wonder about any application where a single schema requires more than 60 roles in order to properly operate.
I certainly would like to see the actual list of ROLE that the schema has/gets.

Report message to a moderator

Re: ORA-01925 [message #420146 is a reply to message #419995]

Thu, 27 August 2009 04:29

samirorafaq
Messages: 10
Registered: August 2009
Location: INDIA

Junior Member

THANKS A LOT..... Michel
Smile

Regards

[Updated on: Thu, 27 August 2009 04:29]

Report message to a moderator

Previous Topic:	PMON failed to acquire latch, see PMON dump
Next Topic:	internals of oracle database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 04:28:06 CDT 2024