Changing Applsyspub Password in Oracle Application 11i - Part 2

This is a continuation of the post which I made earlier . Here is the link to part-1 of the post.


4) Modify <dbSID>_<DBserverName>.xml file on all tiers



After changing the APPLSYSPUB password you must propagate the change to application tier configuration files. You must edit the CONTEXT file on each tier prior to running Autoconfig.
In the CONTEXT file locate the autoconfig variable “s_gwyuid_pass” and <GWYUID oa_var="s_gwyuid” set it to the new applsyspub password,

5) Modify pref.txt file on all tiers

Edit the pref.txt file on each tier. In the pref.txt file locate the “AppsGWYUID” variable and update the APPLSYSPUB user with the new applsyspub password (APPLSYSPUB/<new applsyspub password>)


            i) cd $FND_TOP/admin/template
              cp pref.txt pref.txt_<YYYYMMDD>
              vi pref.txt
           ii) cd $ORACLE_HOME/ discwb4/util/
              cp pref.txt pref.txt_<YYYYMMDD>
               vi pref.txt

6) Modify dbc file on all tiers
 Edit the .dbc file in each tier. In the dbc file locate “GWYUID” variable and update the APPLSYSPUB user with the new applsyspub password (APPLSYSPUB/<new applsyspub password>)

              cd $FND_SECURE
              cp <Instance_name>.dbc <Instance_name>.dbc_<YYYYMMDD>
              vi <Instance_name>.dbc





7) Run AutoConfig on all application tiers

             login as oracle (applmgr)
             set the Oracle Applications environment
             $> cd; . ./<dbSID>_r11i.env #(set the Oracle Applications environment)
            $> cd $SCRIPT_TOP
            $> adautocfg.sh

8) Copy the newly edited DBC file to the 10g Application server tier

The newly edited DBC file with changed APPLSYSPUB password should be copied over to
 Application server tier (findap01 for non-prod). It should  be copied over to the secure folder in  discoverer oracle_home under 10gAS apps tier.

           1) Login to 10gAS (10g Application Server - APP)
           2) Shut down the application services
                cd  $ORACLE_HOME/opmn
               ./opmnctl stopall
          3) Log into the Application Instance.
               cd $FND_SECURE
               cp <instance_name>.dbc /u01/oradba/10gAS/product/10gASAPP/discoverer/secure
          4) Login back to 10gAS (10g Application Server - APP)
          5) Startup the services
              cd $ORACLE_HOME/opmn
              ./opmnctl startall


9) Start concurrent manager and application Services
      
  Verification
  If  problems connecting to Web Discoverer or ADI first try clearing the Jcache from your PC as follows.

                  1. Go to Start -> Settings -> Control Panel
                  2. Double click on ‘JInitiator 1.x.x’
                  3. Select Cache TAB from ‘JInitiator Control Panel’
                  4. Click the Clear JAR Cache Button.
                  5. Go to C:\Documents and Settings\Oracle Jar Cache
                       Delete all items in this folder: alt-a, delete

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;
$>