Oracle Change Password unlock

Source: Internet
Author: User
Tags log log

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.