Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
howto:ora18oln7 [2019/10/06 13:30]
ibk [Monitor Used Space]
howto:ora18oln7 [2020/04/09 11:37] (current)
ibk
Line 356: Line 356:
       )       )
     )     )
- 
-~~DISCUSSION|Comments and Discussion~~ 
  
 ==== Monitor Used Space ==== ==== Monitor Used Space ====
Line 401: Line 399:
       2535      2.476       2535      2.476
 </​code>​ </​code>​
 +
 +==== Disable Password Expire ====
 +
 +You may vant to disable password expire at least for system and the BPS superuser.
 +
 +As system, check used profiles:
 +<​code>​
 +select profile from DBA_USERS where username = '​SYSTEM';​
 +select profile from DBA_USERS where username = '​LU_AGRAR';​
 +</​code>​
 +
 +Check settings of the profiles, for example the DEFAULT profile:
 +<​code>​
 +select resource_name,​limit from dba_profiles where profile='​DEFAULT';​
 +</​code>​
 +
 +Set to unlimited:
 +<​code>​
 +alter profile DEFAULT limit password_life_time UNLIMITED;
 +</​code>​
 +