By default, an Oracle user password will expire every 180 days. When this happens, the password will have to be reset in order to connect to the database. If the user password has expired, follow these steps to reset it:

(In our example, Commstownspatial is the Oracle user whose password has expired, and ‘comms’ is the name of the database. The password is ‘focus’. Replace ‘Commstownspatial’ with the appropriate username and ‘comms’ with the correct database name.)

Open an administrative command prompt and key in the following:

                Sqlplus commstownspatial/focus@comms

 

 Oracle displays an error message stating the password has expired and allows the user to key in a password.

After typing and entering in the password, retype it and hit ENTER to confirm the change.

 

To prevent the password from expiring in the future, the following syntax can be entered in:

                  SQL>Alter profile default limit password_life_time unlimited;      [ENTER]