| jogi |
Posted: May 13, 2008 09:42:47 AM |
Total Post: 21
Joined: Jul, 2007
|
If I am creating user in oracle database, the error is "cannot create user"
cheers
Prasad |
|
|
 Murtuja |
| Posted: May 13, 2008 09:58:05 AM |  |
|
Total Post: 856
Joined: Jan, 2006
|
You need to login as DBA user to create user.
If you still get any error then please post here with entire error message and Oracle and OS version information.
|
|
|
|
|
| jogi |
| Posted: May 14, 2008 08:32:01 AM | |
|
Total Post: 21
Joined: Jul, 2007
|
Hi Murthaja
ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded
thanks and regards
Prasad
|
|
|
|
|
| Murtuja |
| Posted: May 14, 2008 10:41:38 AM | |
|
Total Post: 856
Joined: Jan, 2006
|
LICENSE_MAX_USERS specifies the maximum number of users you can create in the database. When you reach this limit, you cannot create more users. You can, however, increase the limit
ALTER SYSTEM SET LICENSE_MAX_USERS = 200;
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 12:01:03 AM | |
|
Total Post: 322
Joined: May, 2005
|
Simultaneously add same parameter in pfile/spfile LICENSE_MAX_USERS = 200.
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 12:13:56 AM | |
|
Total Post: 281
Joined: Apr, 2008
|
ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded
Cause: Maximum users in the database license limit exceeded.
Action: Increase license limit.
|
|
|
|
|
| positive |
| Posted: Aug 11, 2008 08:51:04 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
