Enterprise Manager Generic (MOSC)

MOSC Banner

User account Create-Like process creating corrupt and otherwise inaccessible user accounts in 10g

edited Feb 11, 2009 12:43PM in Enterprise Manager Generic (MOSC) 3 commentsAnswered
RDBMS: Oracle 10.2.0.3

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center