Start up only the Oracle Weblogic Admin Server on the run edition application tier file system.

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

AD.C

Usage:

**** Patch 21841299 ****

Create $ORACLE_HOME/appsutil/admin on the database server.

Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.

Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

Set the environment to point to ORACLE_HOME on the database server.

Use SQL*Plus to run the script:

UNIX:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/

adgrants.sql<

APPS schema name>

adop phase=apply patches=21841299 hotpatch=yes

Instructions for running AD Grants *** check adgrants in patch 24494551.

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

Usage:

Create $ORACLE_HOME/appsutil/admin on the database server.

Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory.

Copy the higher version of adgrants.sql (UNIX) to

$ORACLE_HOME/appsutil/admin.

Set the environment to point to ORACLE_HOME on the database server.

Use SQL*Plus to run the script:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/

adgrants.sql

<APPS schema name>

adop phase=apply patches=24578455,24494551,25025325 merge=yes

TXK C

adop phase=apply patches=21830810 hotpatch=yes

adop phase=apply patches=18525466,23569114,23705992 hotpatch=yes merge=yes

After applying this patch, update all Database Tier Nodes with the code level provided by this patch, by performing the following steps :

**** After applying the above Patch 23705992 ***

On the Application Tier (as the APPLMGR user):

. Run AutoConfig on the RUN file system.

Note:

Customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfigtemplates provided via this patch before running AutoConfig.

.Source the environment variables for Oracle Applications

UNIX:

. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env

. Execute admkappsutil.pl utility to create the file appsutil.zip

perl<AD_TOP>/bin/admkappsutil.pl

This will create appsutil.zip in <INST_TOP>/admin/out

Note:

For exact details on how to run Autoconfig and how to create appsutil.zip, please refer to the Oracle E-Business Suite Setup Guide for Release 12.2.

On the Database Tier (as the ORACLE user):

. Source the environment variables for RDBMS ORACLE_HOME

UNIX:

cd <RDBMS ORACLE_HOME>

. ./<RDBMS ORACLE_HOMEglt;/<CONTEXT_NAME>.env

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

. Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>

cd <ORACLE_HOME>

unzip -o appsutil.zip

3. Re-run adpreclone.pl on the database tier and on the primary node of the Application tier

Note:

Since new updates included in this patch have been applied to the system, adpreclone must be executed again in order to apply them into the clone directory structures used during cloning.

perl adpreclone.pl dbTier

perl adpreclone.pl appsTier

Migrate Latest Code to Database Tier

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

On the Application Tier (as the APPLMGR user):

Source the environment variables for Oracle E-Business Suite.

UNIX

$ . ./<APPL_TOP>/APPS<CONTEXT_NAME>.env

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 (as the ORACLE user):

Source the environment variables for RDBMS ORACLE_HOME.

UNIX

$ cd <RDBMS ORACLE_HOME>

$ . ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME> .env

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

Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.

$ cd <ORACLE_HOME>

$ unzip -o appsutil.zip

Run AutoConfig on <RDBMS ORACLE_HOME>.

Note: For more details, refer to Oracle E-Business Suite Setup Guide, Release 12.2.

Run AutoConfig on the run file system.

On the Application Tier (as the APPLMGR user):

Run AutoConfig on the run file system.

Note: Before running AutoConfig, customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfig templates provided via this patch.

Note: For exact details on how to run AutoConfig and how to create appsutil.zip, refer to the Oracle E-Business Suite Setup Guide, Release 12.2.