After
implementing PASSWORD_LIFE_TIME TO 30 DAYS for default
profile, applsyspub user’s password was expired after 30 days.
Following error is observed after logging in to application,
Solution:-
We altered
the profile of APPLSYSPUB user from
default to EBS_APPS and rested the password of APPLSYSPUB user.
|
SQL> SELECT
USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE FROM DBA_USERS WHERE
USERNAME='APPLSYSPUB'; USERNAME ACCOUNT_STATUS EXPIRY_DATE PROFILE --------------------
-------------------- --------------- ------------------------- APPLSYSPUB EXPIRED 27-MAR-21 DEFAULT
SQL> ALTER USER APPlSYSPUB PROFILE EBS_APPS;
User altered.
|
· Shutdown application service.
|
[appltest@vm1test
scripts]$ cd $ADMIN_SCRIPTS_HOME [appltest@vm1test
scripts]$ adstpal.sh |
· Reset APPLSYSPUB password using
FNDCPASS OR AFPASSWD .
Note:- APPLSYSPUB password must be in UPPER CASE due
to internal code dependencies.
|
[appltest@vm1test
scripts]$ AFPASSWD -c APPS -o applsyspub Enter the ORACLE
password of Application Object Library 'APPSUSER': Connected
successfully to APPS. Enter the password
for your 'SYSTEM' ORACLE schema: Enter the password
for your 'SYSTEM' ORACLE schema: Connected
successfully to SYSTEM. Log file:
AFPWD_TEST_042697.log Enter new password
for user [applsyspub]: Verify new password
for user [applsyspub]:
|
· Make following changes in application
context file.
Take a backup of application context file.
|
[appltest@vm1test scripts]$ cp $CONTEXT_FILE TEST_vm1test.xml_bkp [appltest@vm1test scripts]$ vi $CONTEXT_FILE Look for following parameter s_gwyuid and s_gwyuid_pass
Make changes like this From <GWYUID
oa_var="s_gwyuid">APPLSYSPUB/PUB</GWYUID>
To <GWYUID oa_var="s_gwyuid">APPLSYSPUB/NEWAPPLSYSPUBPASSWD</GWYUID>
From
<password
oa_var="s_gwyuid_pass">PUB</password>
To <password
oa_var="s_gwyuid_pass"> NEWAPPLSYSPUBPASSWD </password> |
· Run autoconfig on application tier
|
[appltest@vm1test scripts]$ sh adautocfg.sh
|
· Start application and now error should be resolved.
