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