How to Update Database Tier to Latest Code

Updating database tier nodes with the latest code, by performing the following steps:

On the application tier (login as the applmgr user):

Source the run edition environment file.

UNIX:

$cd $APPL_TOP/APPSPHASE1_acetest.env

$ . APPSPHASE1_acetest.env run

Windows:

C:\> <RUN_BASE>\EBSapps\appl\envshell<CONTEXT_NAME>.cmd

Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out.

$ perl $AD_TOP/bin/admkappsutil.pl

On the database tier (login as the oracle user):

Source the environment for RDBMS ORACLE_HOME.

UNIX:

$ cd  $ORACLE_HOME

$ . /$ORACLE_HOME/$CONTEXT_NAME.env

Windows:

C:\> <RDBMS ORACLE_HOME>\<CONTEXT_NAME>.cmd

Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.

Unzip appsutil.zip, under <RDBMS ORACLE_HOME>.

$ cd $ORACLE_HOME

$ unzip -o appsutil.zip

Run AutoConfig on <RDBMS ORACLE_HOME>.

UNIX:

$ sh <RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

Windows:

C:\> <RDBMS_ORACLE_HOME>\appsutil\scripts\<CONTEXT_NAME>\adautocfg.cmd

Note: For Oracle RAC systems, the above steps need to be executed on each Oracle RAC node. For more details, refer to Oracle E-Business Suite Setup Guide, Release 12.2.

Run AutoConfig on the run file system:-

As the applmgr user, run AutoConfig on application tier nodes by executing whichever of these commands applies to your system:

UNIX:

$ sh $INST_TOP/admin/scripts/adautocfg.sh