Change Oracle Apps Password

Change the oracle apps password :
As per Metalink docid : 303621.1 /813653.1


Step 1 : Source the .env file at apps tier.

Step 2 : stop the Application services

· : Take these two tables to backup.

select * from FND_USER order by USER_NAME

--- CREATE TABLE SADHA_FND_USER AS SELECT * FROM FND_USER

select * from FND_ORACLE_USERID order by ORACLE_USERNAME

--- CREATE TABLE SADHA_FND_ORACLE_USERID AS SELECT * FROM FND_ORACLE_USERID

Step 3. Remove other than all_user id’s


select * from fnd_oracle_userid where oracle_username not
in(select username from all_users);

DELETE FND_ORACLE_USERID where ORACLE_ID='20003' – records
Commit;


Step 4 : To change apps password

$cd FND_TOP/bin
bash-3.00$ pwd
/B01/test/testappl/fnd/11.5.0/bin

$ FNDCPASS apps/apps 0 Y SYSTEM/MANAGER SYSTEM APPLSYS erppitti

Log filename : L1197061.log
Report filename : O1197061.out


Step 5: change the new password below files.

1. /p01/dev/devora/iAS/Apache/modplsql/cfg

cp wdbsvr.app wdbsvr.app_backup
== change appspassword as new.

1. /p01/dev/devora/8.0.6/reports60/server
cp CGIcmd.dat CGIcmd.dat_bak


Step 6: Cross check connect applsys connect new apps password.
( APPLSYS is the same password to APPS )

Sql> connect applsys
Password : newpassword



Step 6: bounce the services.

* stop listener/database
* Re-start
Listener/database
the application services