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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018


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:
$FND_SECURE  → .dbc file
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: