Oracle 19c Server

Oracle Password Expiration

By default, Oracle passwords expire in 180 days.

LeasePak does not require disabling Oracle password expiration and NetSol does not recommend it. The following instructions are informational only.

Check with your Security Officer before disabling Oracle password expiration.

Disabling Oracle Password Expiration For All Users

1. Log on the DBMS host as the Oracle software owner.
2. Enter at the Unix prompt:

   % sqlplus / as sysdba

3. Change the current container to the PDB by entering at the sqlplus prompt:

   SQL> alter session set container = PDB_name;

4. Modify the DEFAULT profile by entering at the sqlplus prompt:

   SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

Disabling Oracle Password Expiration for LeasePak Users Only

1. Log on the DBMS host as the Oracle software owner.
2. Enter at the Unix prompt:

   % sqlplus / as sysdba

3. Change the current container to the PDB by entering at the sqlplus prompt:

   SQL> alter session set container = PDB_name;

4. Create an Oracle profile with an unlimited password lifetime by entering at the sqlplus prompt:

   SQL> create profile profile_name limit PASSWORD_LIFE_TIME unlimited;

5. Assign the profile to each LeasePak user by entering at the sqlplus prompt:

   SQL> alter user username profile profile_name;