Oracle users are locked and oracle users are locked

Oracle users are locked and oracle users are locked

Sqlplus sys/password @ localhost: 1521/cmsx as sysdba

 

SQL * Plus: Release 11.2.0.1.0 Production on Monday July 21 13:33:13 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alert user cmsuser account unlock;
SP2-0734: Unknown command starting with "alert user..."-ignore the remaining lines.
SQL> alter user cmsuser account unlock;

The user has changed.

SQL>

Oracle user locking

1. You can use alter user ID account unlock to unlock this user first

2. this mechanism is set in the user's profile. profile is mainly used to manage system resources and user authorization orders. You can open it and check that there is a FAILED_LOGIN_ATTEMPTS parameter in it, you can also use it with other parameters to manage resources and dispatch orders. The system has a default profile named default.

Example:
1. Resource
Create profile luck_prof limit
Sessions_per_user 8
CPU _ per_session 16800
Logical_reads_per_session 23688
Connect_time 268
Idle_time 38;
2. For example, modify default
Alter profile default limit
Password_life_time 60
Password_grace_time 10
Password_reuse_time 1800
Failed_login_attempts 3
Pasword_lock_time 1/1440;

Specify a profile when creating or modifying a user, for example:

Create user wuser
Identified by wuser
.......
Profile luck_prof;

We hope that the above information can help you solve the problem.

Oracle prompts the user to be locked and cannot be resolved

Use sysdba to log on and unlock
For example, to unlock a scott user, you can:
Sqlplus/as sysdba
Alter user scott identify by password account unlock;
Password is the new password.