Oracle Change Password unlock

1. How to modify the Oracle user password

when logging in as SYSDBA, you can modify other users ' passwords, such as: SQL> alter user name identified by new password; user changed. This is to change the USER01 user password to USER10

If you want to log in, I'll be just looking for a database user login successful, the other database password modified successfully

-----------------------------------------------------
[Oracle Initial password]
Internal/oracle
Sys/change_on_install
System/manager
Scott/tiger
Sysman/oem_temp

2.Reason and method of Oracle user being locked

the reason and method of the Oracle user being locked is told that the test user is locked when logging in1, the DBA role of the user login, unlock, set the specific time format, in order to view the specific time SQL> Alter SESSIONSetNls_date_format= ' yyyy-mm-dd Hh24:mi:ss ';　　Session altered. 2, view the specific lock time SQL>SelectUsername,lock_date fromDba_userswhereUsername=' TEST '; USERNAME lock_date------------------------------ -------------------TEST the-Geneva-Ten  ,:Wuyi:Geneva 　　 3, Unlock SQL>alter user test account unlock;　　User altered. 4, check that the IP caused by the test user is locked view $oracle_home/network/admin/log/Listener.log LogTen-mar- the  ,:Wuyi:Geneva* (Connect_data= (sid=lhoms) (server=dedicated) (Cid= (program=oracle) (HOST=OMSTESTDB) (user=oraoms))) * (ADDRESS= ( PROTOCOL=TCP) (host=10.69.1.11) (port=49434)) * Establish * lhoms *0 　　 Ten-mar- the  ,:Wuyi:Geneva* (Connect_data= (sid=lhoms) (server=dedicated) (Cid= (program=oracle) (HOST=OMSTESTDB) (user=oraoms))) * (ADDRESS= ( PROTOCOL=TCP) (host=10.69.1.11) (port=49435)) * Establish * lhoms *the 0www.examda.com exam is so big that it is above ten.69.1. 11 IP attempts multiple failed logins caused by the lock note: The general database by default is 10 attempts to lock the user after the failure1, viewing the value of failed_login_attemptsSelect* fromDba_profiles2, modified to 30 times the alter profiledefaultLimit failed_login_attempts -; 3, modified to unlimited (not recommended for security reasons) alter profiledefaultLimit Failed_login_attempts Unlimited;

Original: http://blog.csdn.net/ppp_10001/article/details/5696704

Oracle Change Password unlock