Database Administration (MOSC)

MOSC Banner

ORA-01918: user '' does not exist

edited Jul 8, 2014 5:27AM in Database Administration (MOSC) 1 commentAnswered ✓

Dear Colleague,

I have problem can't lock user, I have no idea what might happen. Could you give me a clue.

I can query to dba_users got the username but when every time i alter user <username> account lock; error is coming.

below is the example,

15:20:16 SQL> select username, account_status, lock_date, expiry_date, created, profile, password from dba_users

where15:20:18   2   username in ('app1','app2','app3','app4','app5');

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE EXPIRY_DA CREATED   PROFILE  PASSWORD

------------------------------ -------------------------------- --------- --------- --------- -------- ------------------------------

app1                           OPEN                                                 02-JUN-14 DEFAULT

app2                           OPEN                                                 08-NOV-12 DEFAULT

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