| Max Role problem(ORA-28031: maximum of 148 enabled roles exceeded) [message #338511] |
Tue, 05 August 2008 04:56  |
dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon
|
Member |
|
|
Hi have a SID in oracle10g databse under which i create my oracle users.
I already have more than 50 users in my SID.
Now when i try to loing through System its saying "ORA-28031: maximum of 148 enabled roles exceeded)".
Neither i can access this SID nor i can delete any role from this but i can access the existing users i have creating under this SID.
Please suggest how can i tackle this problem.
Thanx in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Max Role problem(ORA-28031: maximum of 148 enabled roles exceeded) [message #338868 is a reply to message #338844] |
Wed, 06 August 2008 02:34  |
dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon
|
Member |
|
|
As i alredy explained I cann't login through this SID(eisidb).
like when i say system/pwd@SID it gives me max-role problem.
so i cann't run the command as told by you.
I login into some new SID lets say emqa
sql> connect system/pwd@emqa
>> connect sys as sysdba;
>> pwd
now i run urs commands and go the following result;
SQL> show parameter role;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 150
os_roles boolean FALSE
remote_os_roles boolean FALSE
SQL> select startup_time from v$instance;
STARTUP_T
---------
06-AUG-08
I believe these values are for emqa SID not for the eisidb.
Please suggest how would i know the paramter for eisidb(which is not working).
Please correct me if i m wrong.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
