User account Create-Like process creating corrupt and otherwise inaccessible user accounts in 10g
Platform: Solaris
OS: Solaris 5.9
Problem Description:
Using Grid Control to create a new user account using the 'Create Like' process results in the creation of an account that cannot be accessed (invalid username/password - access denied), and cannot be dropped.
Changing the password via SQL*Plus (alter user xxx identified by 'xxx') returns successful, but subsequent connection attempts to the specific account continue to fail with 'invalid username/password'.
Attempts to drop the account have resulted in all of the following at different times:
- hung SQL*Plus or Grid Control session
- 'cannot drop a user that is currently connected' - ( querying v$session reveals no such connection)