Changing Applsyspub Password in Oracle Application 11i - Part 1

APPLSYSPUB schema has sufficient privileges to perform the authentication of an Applications User (a.k.a. FND user), which includes running PL/SQL packages to verify the username/password combination and the privilege to record the success or failure of a login attempt. There is no need to change the password for APPLSYSPUB.

However, should you choose to change this password; you must use FNDCPASS
$ FNDCPASS APPS/ 0 Y SYSTEM/ ORACLE APPLSYSPUB

Steps for changing the applsyspub password:
--------------------------------------------
1) Full backup for both code and database

2) Stop all application tier server processes
     login as oracle (applmgr)
  set the Oracle Applications environment
$> cd; . ./_r11i.env
$> export apps_pwd=
$> export system_pwd=
$> FNDCPASS APPS/$apps_pwd 0 Y SYSTEM/$system_pwd ORACLE APPLSYSPUB

3)Confirm applsyspub passwords were successfully changed
Open session on Backend (Database server)
set the Oracle database environment
- login as oracle (applmgr)
- run the environment or command for the current database
$> sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri May 30 14:28:35 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn applsyspub/
Connected.
SQL> exit;
$>