Home » RDBMS Server » Server Administration » ORA-01925 (Oracle 9i)
ORA-01925 [message #419966] Wed, 26 August 2009 05:29 Go to next message
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...........
Re: ORA-01925 [message #419981 is a reply to message #419966] Wed, 26 August 2009 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
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

Re: ORA-01925 [message #419989 is a reply to message #419981] Wed, 26 August 2009 06:35 Go to previous messageGo to next message
samirorafaq
Messages: 10
Registered: August 2009
Location: INDIA
Junior Member
ya it is spfile
Re: ORA-01925 [message #419995 is a reply to message #419989] Wed, 26 August 2009 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system set MAX_ENABLED_ROLES =... scope=spfile
and restart

Regards
Michel
Re: ORA-01925 [message #420063 is a reply to message #419966] Wed, 26 August 2009 18:47 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: ORA-01925 [message #420146 is a reply to message #419995] Thu, 27 August 2009 04:29 Go to previous message
samirorafaq
Messages: 10
Registered: August 2009
Location: INDIA
Junior Member
THANKS A LOT..... Michel
Smile Smile Smile Smile 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:
  


Current Time: Mon Dec 05 05:08:15 CST 2016

Total time taken to generate the page: 0.13461 seconds