Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, February 10, 2016

How to change APPLSYSPUB password in EBS.


Change APPLSYSPUB password



Shutdown the apptier:
 
Backup and change PWD in the below files:
$CONTEXT_FILE
$FND_SECURE  → .dbc file
$IAS_CONFIG_HOME/Apache/Jserv/etc/formservlet.ini
appTier .env files ($APPL_TOP)

sqlplus / as sysadb

SQL> create table applsys.fnd_oracle_userid_02102016 as select * from applsys.fnd_oracle_userid;

Table created.

SQL> create table applsys.fnd_user_02102016 as select * from applsys.fnd_user;

Table created.


Change password:
FNDCPASS apps/xxxxxxxxxxxx 0 Y system/xxxxxxxxxxxx ORACLE APPLSYSPUB xxxxxxxxxxxx


Start the apptier:

No comments: