Wednesday, May 20, 2009

max_enabled_roles error in all the versions including 10.2.0.3

Today I got a mail from one of the end user that he is not able to login and he is getting the ORA-28031 error while logging.As the parameter is already set to 150 and we can not increase anymore. After doing a little search I came to know that this is a bug and resolved in 10.2.0.4.So as a work around is set role none to the user who is getting the error by usingalter user username default role none;But I am not sure is this was the way to resolve the issue.

No comments:

Post a Comment

About Me

Working as Oracle DBA for Wipro Technologies, Chennai, India