Search This Blog

Thursday, July 21, 2011

11gr2 Password Expired

in the 11gr1 and later we found new implemented password feature.

while login to database i am getting below error message


ORA-28002: the password will expire within 6 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Cause:
his behavior was caused because the PeopleSoft 'ConnectId' account and the 'Sysadm' account as defined in the DBA_USERS table had expired.

This happened because of a change implemented in Oracle 11g databases. In releases prior to 11g, those accounts would never expire. In 11g, they are hardcoded with an expiry date of 180 days.

Solution:
To implement the proposed solution:

1. Logon to the product database as the SYSTEM user (not the application administration user).

2. Find the profile.

SQL> select account_status, profile from dba_users where username='the PeopleSoft ConnectID';

SQL> select account_status, profile from dba_users where username='sysadm';

3. Alter the profiles with the following SQL:

SQL>ALTER PROFILE LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. Connect to the database via SqlPlus and change the schema password with the command

SQL>ALTER USER IDENTIFIED BY ;

SQL>ALTER USER SYSADM IDENTIFIED BY ;

No comments: