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
4. Connect to the database via SqlPlus and change the schema password with the command
SQL>ALTER USER
SQL>ALTER USER SYSADM IDENTIFIED BY
No comments:
Post a Comment