ORA-28001: the password has expired

1. When Oracle UCM is started, the console reports an error.
The following exception occurs when you view logs:

------

#### <2011-12-14 02:21:13 P.M. CST> <Info> <JDBC> <unis-1fb1a542b4> <UCM_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic. kernel. default (self-tuning) '> <anonymous> <1323843673405> <BEA-001156> <Stack trace associated with message 001129 follows:
Java. SQL. SQLException: ORA-28001: the password has expired

------

Java. SQL. SQLException: ORA-28001: the password has expired.

The password for Oracle11g has expired.

Cause: it is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by default.

2. solution:

Log on as an administrator:
C: \> sqlplus/as sysdba

View the password validity period settings of the specified profile (such as default:
SQL> select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';

PROFILE
------------------------------------------------------------
RESOURCE_NAME
------------------------------------------------------------
RESOURCE_TYPE
----------------
LIMIT
------------------------------------------------------------

DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
180

------------------------------------------------------------

The default password is valid for 180 days.

Perform the following operations to change the value to an indefinite period:
SQL> alter profile default limit password_life_time unlimited;
SQL> commit;

Run the following command again:
SQL> select * from dba_profiles where profile = 'default' and resource_name = 'passw
ORD_LIFE_TIME ';

PROFILE
------------------------------------------------------------
RESOURCE_NAME
------------------------------------------------------------
RESOURCE_TYPE
----------------
LIMIT
------------------------------------------------------------

DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
UNLIMITED
------------------------------------------------------------

The value of LIMIT is "UNLIMITED ".

Then reset the account.

The SQL command is:
SQL> alter user system identified by Welcome1;
SQL> alter user UCM_OCS identified by Welcome1;

If the user account is locked, the UNLOCK Command is:

SQL> alter user UCM_OCS identified by oracle account unlock;

3. After the password is reset and enabled, UCM starts properly.
Note that the UCM_OCS user password must be the same as the original password for resetting. Otherwise, the ucm idc service cannot be started.