Unlock Sysadmin Account....

The password of the SYSADMIN user can be changed and so unlocked by using the FNDCPASS tools .


**********************************************************

A ) Please take a backup of the tables FND_USER and FND_ORACLE_USERID :

create table XXX_USER as select * from FND_USER

create table XXX_ORACLE_USERID as select * from FND_ORACLE_USERID

B ) - Change the password of SYSADMIn using FNDCPASS:

1. Keep all services running.

2. Login via the OS level by way of the applmgr user.

3. cd $FND_TOP/bin

4. Run FNDCPASS to change the SYSADMIN password
(IMPORTANT: Change ONLY the SYSADMIN password)

FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN <New Password>

5. Restart the Apache, Forms, Reports, 8.0.6 listener and concurrent manager services.

6. To test, login into the applications as the SYSADMIN user and the new password.
Also test by login with your own user .

7. Verify that a concurrent program such as Active Users runs.


Thanks,
Suresh.B