Skip to Content
Last modified by Александр Таболин on 2023/12/04 19:06
Show last authors
1 ^^[[Информационные материалы проекта UNA>>http://xwiki.una.md/bin/view/UNA/WebHome]] (% class="separator" %)»(%%) [[Регламенты Unisim-Soft>>http://xwiki.una.md/bin/view/UNA/Reglament_docs]] (% class="separator" %)»(%%) [[IT>>http://xwiki.una.md/bin/view/UNA/IT]](% class="separator" %)»(%%) [[Установка Oracle XE для сервера касс>>UNA.Install_front_casa_server]]^^
2
3 Make Oracle password never expire
4 Oracle Database Tips by Donald BurlesonAugust 20, 2015
5 Question: I am getting a password expired problem. I want to fix this user ID such that the user ID never expires the password. I want to keep my password and set Oracle to never expire my password.
6
7 How do I make a password non-expiring?
8
9 Solution for making a password never expire:
10
11 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
12 SQL> connect sys/secret_password as sysdba;
13
14 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
15 SQL> alter user sysman account unlock ;
16
17 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
18 SQL> alter user DBUSER identified by newpa$$word;
19
20 See these important notes in you want to changing_your_password.
21
22
23 Next, change the profile limit to unlimited.
24
25 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
26 SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
27
28 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
29 SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;
30
31
32 Check the password expiry date
33
34 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
35 SQL> select username, account_status, EXPIRY_DATE from dba_users where username='BURLESON';
36
37 USERNAME ACCOUNT_STATUS EXPIRY_DATE
38 ------------------------------ ---------------------------- --------
39 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
40 BACMONIT OPEN UNLIMITED