### Define Product Dependencies in applprod.txt

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Example configuration file structure for defining product dependencies and installation requirements.

```text

# ##################################################

# Payables

# ##################################################

#

# application id, abbreviation, shortname, prefix

200 ap SQLAP APP

# multiple product installations for msob, "controlled release", shared only

# optional fourth field is "stub product". default is No

Yes No No No

# multilingual, has NLADD.sql

Yes Yes

# install oracle id, default ORACLE username, default ORACLE password

200 AP AP

# concurrent conflict set id (logical database id)

0

# minimum version you can upgrade from, for shared and for fully-installed

8.0.57 8.0.57

# shared products; this lists fnd and some subset of:

**fnd ax ak az gl inv po fa ar ont as per pay mfg bom eng wip pa dt xla ce qa crp mrp ff**

# product libraries needed for "make -f <product>.mk all"

fnd alr inv bom crp eng mrp wip po gl ar pay ff dt ap fa

# when install this product, set these other products to install

**ax ak az

# requires that these other products are fully installed or installing

ax ak az

#**
```

--------------------------------

### Start All Application Tier Server Processes on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of starting all application tier processes using the adstrtal.sh script.

```shell
$ adstrtal.sh
You are running adstrtal.sh version 120.24
Enter the APPS username: <APPS username>
Enter the APPS password: <APPS password>
Enter the WebLogic Server password: <WLS password>
```

--------------------------------

### Start an AD Utility

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example command to launch an AD utility, such as AD Administration.

```shell
$ adadmin
```

--------------------------------

### Accessing adop Help and Examples

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Commands to display the help usage statement or parameter examples for the adop utility.

```bash
adop -help
```

```bash
adop -examples
```

--------------------------------

### Start Application Tier Services (Windows)

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Command format and execution for starting services on Windows.

```batch
<process script name> [stop | start]
```

```batch
$ adstrtal.cmd
You are running adstrtal.cmd version 120.24
Enter the Applications username: <APPS username>
Enter the Applications password: <APPS password>
Enter the WebLogic Server password: <WLS password>
```

```batch
$ adstrtal.cmd -secureapps
You are running adstrtal.cmd version 120.24
Enter the Applications username: <Concurrent Manager operator username>
Enter the Applications password: <Concurrent Manager operator password>
Enter the WebLogic Server password: <WLS password>
```

--------------------------------

### Start Application Tier Services (UNIX)

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Commands for starting services on UNIX, including secure options and password piping.

```bash
{ echo $APPSUSER ; echo $APPSPASS ; echo $WLSADMIN ; } | adstrtal.sh @ -nopromptmsg
```

```bash
$ adstrtal.sh -secureapps
You are running adstrtal.sh version 120.24
Enter the Applications username: <Concurrent Manager operator username>
Enter the Applications password: <Concurrent Manager operator password>
Enter the WebLogic Server password: <WLS password>
```

--------------------------------

### Example adop options usage

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Demonstrates the syntax for passing multiple options to the adop utility.

```text
adop options=nocopyportion,nogenerateportion
```

--------------------------------

### Query Product Installation Status

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Use this SQL query with the APPS account to list all applications and their current installation status.

```sql
set pages 20000;
col application_id for 9999;
col application_name for A50;
col status for A1;
col application_short_name for A10;
select fa.application_id,
fa.application_short_name,
fpi.status,
fatl.application_name
from
fnd_product_installations fpi,
fnd_application fa,
fnd_application_tl fatl
where
(
fa.application_id = fpi.application_id and
fa.application_id = fatl.application_id and
fatl.language = 'US'
)
order by fa.application_short_name;
```

--------------------------------

### Start AD Controller

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530135.htm

Launch the AD Controller utility from the command line.

```bash
adctrl
```

--------------------------------

### AD Utility Prompt Example

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of a standard command-line prompt requesting an ORACLE password with a default value.

```text
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

Press [Return] to accept the default value, or type a new value
after the colon and press [Return]. Read the prompts carefully
to make sure you supply the correct information.
```

--------------------------------

### AD Relink Command Line Examples

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Examples of using command line arguments to control the relinking process.

```shell
adrelink force=n
```

```shell
adrelink force=n backup_mode=all
```

--------------------------------

### Running adfhrept.sql on UNIX and Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example commands to execute the adfhrept.sql script for file version history of admorgb.pls.

```bash
$ cd $AD_TOP/patch/115/sql
$ sqlplus <APPS username>/<APPS password> \
@adfhrept.sql admorgb.pls N 01/01/2013 01/31/2013 \
ALL ALL ALL N N N N N
```

```cmd
C:>\ cd %AD_TOP%\patch\115\sql
C:>\ sqlplus <APPS username>/<APPS password> @adfhrept.sql admorgb.pls  N 01/01/2013 01/31/2013 ALL ALL ALL N N N N N
```

--------------------------------

### Define Product Groupings in RapidWiz.ini and adlicmgr.ini

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Example of mapping a product family to a list of application IDs.

```ini
Financials={101,140,200,222,240,260,600,8400,8401,8450,8901,231,673} 
```

--------------------------------

### Start Managed Server in Independence Mode

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Starts a managed server using local configuration files instead of contacting the Admin Server.

```bash
$ admanagedsrvctl.sh start forms-c4ws_server1 -msimode
```

--------------------------------

### AD Utility Log File Prompt Example

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of the prompt displayed when an AD utility requests a log file name.

```text
<utility name> records your <utility name> session in a text file you specify.
Enter your <utility name> log file name or press [Return] to accept the
default name shown in brackets.

Filename [<utility name>.log] :
```

--------------------------------

### View contents of an execution directory

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Example of the file structure within a specific execution directory.

```text
-155
 - 20170727_140633
   adop.log
   - prepare$ cd 20170727_140633
```

--------------------------------

### Display adop examples

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Use this command to view a comprehensive list of available flags and options for the adop utility.

```bash
$ adop -examples
```

--------------------------------

### Monitor Patching Cycles with adopmon

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example output of the adopmon utility during the finalize phase.

```text
$ adopmon

Running script. Press Ctrl-C to quit.

Enter the APPS password: 

2015/08/04 11:59:02 testsystem          EVENT        Checking for existing adop sessions.
2015/08/04 11:59:02 testsystem          EVENT        Checking for pending hotpatch session.
2015/08/04 11:59:02 testsystem          EVENT        Checking for pending cleanup session.
2015/08/04 11:59:02 testsystem          EVENT        Continuing with existing session [Session ID: 66].
2015/08/04 11:59:02 testsystem          EVENT        ADOP (C.Delta.7)
2015/08/04 11:59:02 testsystem          EVENT        Session ID: 66
2015/08/04 11:59:02 testsystem          EVENT        Node: testsystem
2015/08/04 11:59:02 testsystem          EVENT        Phase: finalize
2015/08/04 11:59:02 testsystem          EVENT        Log: /u01/orauser/usertest/fs_ne/EBSapps/log/adop/66/adop_20150804
                                                     _115825.log
2015/08/04 11:59:03 testsystem          EVENT        Verifying existence of context files in database.
2015/08/04 11:59:04 testsystem          EVENT        Verifying data dictionary.
2015/08/04 11:59:35 testsystem          EVENT        Running finalize phase database actions.
2015/08/04 11:59:35 testsystem          EVENT        Log: @ADZDSHOWLOG.sql "2015/08/04 11:59:35"
2015/08/04 11:59:35 testsystem          EVENT        Finalize System
2015/08/04 12:00:01 testsystem          EVENT        Executing FINALIZE actions
2015/08/04 12:00:01 testsystem          EVENT        Compiling invalid objects.
2015/08/04 12:00:01 testsystem          EVENT        Compile Edition: V_20150804_1041
2015/08/04 12:01:55 testsystem          EVENT        Generating log report.
2015/08/04 12:01:55 testsystem          EVENT        Output: /u01/orauser/usertest/fs_ne/EBSapps/log/adop/66/finalize_2
                                                     0150804_115825/usertest_testsystem/adzdshowlog.out
2015/08/04 12:01:56 testsystem          EVENT        The finalize phase completed successfully.
```

--------------------------------

### Running adphrept.sql on UNIX and Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example commands to execute the adphrept.sql script for January 2012 patch details.

```bash
$ cd $AD_TOP/patch/115/sql
$ sqlplus <APPS username>/<APPS password> \
@adphrept.sql 3 ALL ALL 01/01/2012 01/31/2012 \
ALL ALL ALL ALL ALL N N N N N jan09.xml
```

```cmd
C:>\ cd %AD_TOP%\patch\115\sql
C:>\ sqlplus <APPS username>/<APPS password> @adphrept.sql 3 ALL ALL 01/01/2009 01/31/2009 ALL ALL ALL ALL ALL N N N N N jan09.xml
```

--------------------------------

### Patching Status Output Example

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Sample output display for an adop status check.

```text
Current Patching Session ID: 5
Node Name       Node Type       Phase       Status          Started          
              Finished                       Elapsed
 --------------- --------------- ----------- ---------------
 ------------------------------ ------------------------------ ------------
 patchtest1      master          PREPARE     COMPLETED       06-MAY-13
 11:31:38 -07:00      07-MAY-13 12:27:51 -07:00      0:56:13
                                 APPLY       COMPLETED       07-MAY-13
 04:19:17 -07:00      07-MAY-13 04:43:12 -07:00      0:23:55
                                 CUTOVER     COMPLETED       07-MAY-13
 05:54:03 -07:00      07-MAY-13 05:57:57 -07:00      0:03:54
                                 CLEANUP     COMPLETED       07-MAY-13
 09:14:33 -07:00      07-MAY-13 09:22:46 -07:00      0:08:13
```

--------------------------------

### AD Administration Task-Specific Prompt

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of a prompt displayed when running the Generate Product JAR files task.

```text
Do you wish to force generation of all jar files? [No]:
```

--------------------------------

### Example Manifest File Content

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

A text file documenting the location and names of patch zip files for use with the -manifest option.

```text
/d01/prodappl/patches/p3903945_12_GENERIC.zip
/d01/prodappl/patches/p3892799_12_GENERIC.zip
/d01/prodappl/patches/p3874740_12_LINUX.zip
```

--------------------------------

### Start AD Controller for second node

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Launch AD Controller on the second node and assign workers 5-8.

```bash
$ adctrl distributed=y
Enter the worker range: 5-8
```

--------------------------------

### Verify oraInst.loc content

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example content for the oraInst.loc file specifying the global inventory location.

```text
inventory_loc=/oracle/oraInventory
```

--------------------------------

### Start AD Controller for third node

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Launch AD Controller on the third node and assign workers 9-12.

```bash
$ adctrl distributed=y
Enter the worker range: 9-12
```

--------------------------------

### Locate the AD_LOG_HOME directory

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Example path for the top-level directory where adop log files are stored.

```text
/u01/R122_EBS/fs_ne/EBSapps/log/adop
```

--------------------------------

### View session ID structure in ADOP_LOG_HOME

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Example of the session ID directory structure within the log home.

```text
$ADOP_LOG_HOME
 - 100
 - 101
 - 102
 - 155
```

--------------------------------

### Manage Oracle Net Services Listener on Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use addlnctl.cmd to start or stop the listener process.

```batch
C:\> addlnctl.cmd [start|stop] <listener_name>
```

```batch
C:\> addlnctl.cmd start PROD
```

--------------------------------

### Validate System for Patching

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run this command to perform system checks before starting a patching cycle.

```bash
$ adop -validate
```

--------------------------------

### Disabling Validation in adop

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Example command to run the prepare phase with validation bypassed.

```bash
adop phase=prepare validation=bypass
```

--------------------------------

### Perform AFPASSWD Partial Migration

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T174305.htm

Example command to perform a partial migration to a specific advanced hash mode.

```bash
AFPASSWD -m [FSHA384|FSHA512]
```

--------------------------------

### Start AD Controller for distributed processing

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Launch the AD Controller session on secondary nodes with the distributed flag enabled.

```bash
$ adctrl distributed=y
```

--------------------------------

### Manage Oracle Net Services Listener on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use addlnctl.sh to start, stop, or check the status of the listener process.

```bash
$ addlnctl.sh [start|stop] <listener_name>
```

```bash
$ addlnctl.sh start PROD
```

--------------------------------

### Initiate Patch Application Assistant

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Execute the admsi.pl script to launch the PAA interface for generating and managing instance-specific patch installation instructions.

```bash
$ admsi.pl
```

--------------------------------

### Full SQL Report Configuration Entry

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T221119.htm

Example of a complete cReport configuration including the script definition and key column mapping.

```xml
<cReport type="SQL 'group="Custom Reports">
<title>sysdate.sql</title> <script name="sysdate1.sql" protected="no" execMode="JDBC"
parameters="unknown">
</script>
<keyColumns>
<column position="1" key="REQUEST_ID"/>
</keyColumns>
</cReport>
```

--------------------------------

### Map Application IDs to Short Names

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Example mapping of application IDs to their corresponding Oracle E-Business Suite short names.

```text
GL,OFA,AP,AR,PN,CE,AX,IGI,PSB,PSA,FV,BNE,IBY
```

--------------------------------

### Handle Abandoned Node Error

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Displayed when starting a new adop session while abandoned nodes exist in the system.

```text
Node(s) <abandoned_node_list> were abandoned in a previous patching cycle. To recover these node(s), follow the instructions in My Oracle Support article KB818111.
```

--------------------------------

### View execution ID structure for a patching cycle

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Example showing multiple execution timestamps under a specific patching cycle session ID.

```text
$ADOP_LOG_HOME
- 155
 - 20170727_140633
 - 20170727_154820
 - 20170728_125014
```

--------------------------------

### Adop Summary Report Format

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example output format for the summary report generated after an adop command in a multi-node environment.

```text
Format of Summary Report
------------------------
Node ebsint1 : COMPLETED
 - Prepare status: COMPLETED
Node ebsint2 : COMPLETED
 - Prepare status: COMPLETED
```

--------------------------------

### Handling Re-application of Patches in adop

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example of the warning message displayed by adop when attempting to re-apply a patch without the forceapply option.

```text
[WARNING] Skipping the application of patch 14125999_AR since it has been already applied
[WARNING] Hint: Patches can be applied again by specifying options=forceapply when invoking adop
```

--------------------------------

### Migrate to EBS Installation Central Inventory

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Command to migrate application tier Oracle Homes to the instance-specific central inventory.

```perl
$ perl <FND_TOP>/patch/115/bin/txkMigrateInventory.pl -contextfile=<CONTEXT_FILE>
```

--------------------------------

### Execute Prepare phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Initiates a new online patching cycle.

```bash
$ adop phase=prepare
```

--------------------------------

### Execute Cutover phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Transitions the system to the newly patched environment.

```bash
$ adop phase=cutover
```

--------------------------------

### Set the Environment File

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Commands to initialize the environment for Oracle E-Business Suite on UNIX and Windows.

```UNIX
$ . APPS<CONTEXT_NAME>.env
```

```Windows
%APPL_TOP%\envshell.cmd
```

--------------------------------

### Configure Index Creation Logging

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Specify the logging flag to ensure index creation supports database media recovery and standby databases.

```shell
adop flags=logging
```

--------------------------------

### Execute adop apply phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run the apply phase using an input file to specify patch details.

```bash
$ adop phase=apply input_file=<inputfile.txt>
```

--------------------------------

### Run adop phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

General syntax for executing a specific adop phase.

```bash
$ adop phase=<phase_name>
```

--------------------------------

### Run Prepare Phase with skipsyncerror

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Use this command to restart the prepare phase while allowing processing to continue despite synchronization errors.

```bash
adop phase=prepare skipsyncerror=yes
```

--------------------------------

### Run AD Configuration Script on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530134.htm

Executes the adutconf.sql script to generate a system configuration report in the current directory.

```bash
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS schema username>/<APPS schema password> \
@$AD_TOP/sql/adutconf.sql
```

--------------------------------

### Stop Concurrent Processing Server on Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of stopping the Concurrent Processing server using the adcmctl.cmd script.

```batch
C:\> adcmctl.cmd stop
You are running adcmctl.cmd version 120.19
Enter the APPS username: <APPS username>
Enter the APPS password: <APPS password>
```

--------------------------------

### Run AD Splicer to Add Off-Cycle Products

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Execute the AD Splicer utility from the admin directory to register new products. Ensure the environment is set before running the command.

```UNIX
$ cd $APPL_TOP/admin
$ adsplice
```

```Windows
C:\>cd %APPL_TOP%\admin
C:\>adsplice
```

--------------------------------

### Perform System Cleanup and Edition Management

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Commands to prepare, actualize, finalize, cutover, and perform a full cleanup of the system.

```bash
$ adop phase=prepare
$ adop phase=actualize_all
$ adop phase=finalize finalize_mode=full
$ adop phase=cutover
$ adop phase=cleanup cleanup_mode=full
```

--------------------------------

### Stop Concurrent Processing Server on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Example of stopping the Concurrent Processing server using the adcmctl.sh script.

```shell
% adcmctl.sh stop
You are running adcmctl.sh version 120.19
Enter the APPS username: <APPS username>
Enter the APPS password: <APPS password>
```

--------------------------------

### Verify Environment Variables

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Commands to check that environment variables are correctly configured after initialization.

```UNIX
$ echo $TWO_TASK
$ echo $ORACLE_HOME
$ echo $PATH
```

```Windows
C:\> echo %LOCAL%
C:\> echo %ORACLE_HOME%
C:\> echo %PATH%
C:\> echo %APPL_CONFIG%
```

--------------------------------

### AD Administration Usage Syntax

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Displays the command line syntax and available configuration options for AD Administration.

```text
usage: adadmin [help=y]

                adadmin
                                [printdebug=y|n][localworkers=<localworkers>]
                                [flags=hidepw|trace]

                adadmin Non-Interactive mode
                                [defaultsfile=<$APPL_TOP/admin/SID/defaultsfile>]
                                [logfile=<logfile>][interactive=y|n]
                                [workers=workers>][menu_option=ASK_NAME>][restart=y|n]
```

--------------------------------

### Start/Stop Services on Multiple Nodes

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use the -allnodes option to manage services across all application tier nodes from the primary node.

```bash
$ adstrtal.sh -mode=allnodes
 $ adstpall.sh -mode=allnodes
```

--------------------------------

### Monitor cutover status

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Example of an informational message displayed when the cutover phase is waiting for the internal concurrent manager to shut down.

```text
[STATEMENT] [END 2013/10/28 23:47:16] Waiting for ICM to go down
```

--------------------------------

### Database recyclebin configuration

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Required database initialization parameter setting to ensure online patching cleanup functions correctly without SYS privileges.

```text
#########
#
# recyclebin parameter
#
# The database recyclebin must be turned off to allow
# the cleanup phase of the online patching cycle to be
# performed without having to connect as SYS.
#
```

--------------------------------

### Manage JFR Recordings with jcmd

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T575556.htm

Utility commands for starting, checking, dumping, and stopping JFR recordings for a specific process ID.

```bash
jcmd <PID>.<action> [options]
```

```bash
$ jcmd 7000 JFR.start name=MyRecording settings=profile delay=20s duration=2m filename=/EBS12jfr/myrecording.jfr
```

```bash
$ jcmd 7000 JFR.check
```

```bash
$ jcmd 7000 JFR.dump name=MyRecording filename=/EBS12jfr/dump.jfr
```

```bash
$ jcmd 7000 JFR.stop name=MyRec_cp
```

--------------------------------

### Run adop with an Input File

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Specify an input file to provide arguments to the adop utility.

```bash
$ adop phase=apply input_file=<input_file.txt> 
```

--------------------------------

### Execute adop apply with analytics

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run the apply phase with the analytics parameter enabled.

```bash
$ adop phase=apply analytics=yes
```

--------------------------------

### Execute AD Administration with Multiple Arguments

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Shows how to pass multiple token=value pairs to the adadmin utility separated by a space.

```bash
$ adadmin printdebug=y flags=hidepw
```

--------------------------------

### Prepare individual patches for synchronization

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Move individual patches into the merged patch directory to ensure they are available for the next prepare phase.

```bash
$ pwd
$ /u01/R122_EBS/fs_ne/EBSapps/patch
$ mv 111 /u01/R122_EBS/fs_ne/EBSapps/patch/test
$ mv 222 /u01/R122_EBS/fs_ne/EBSapps/patch/test
$ cd /u01/R122_EBS/fs_ne/EBSapps/patch/test
$ ls
111  222  fnd  u_merged.drv
```

--------------------------------

### Manager Idle Status Message

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530135.htm

Example of the console output displayed when the manager becomes idle due to failed or waiting workers.

```text
ATTENTION: All workers either have failed or are waiting:

FAILED: file cedropcb.sql on worker 1.
FAILED: file adgrnctx.sql on worker 2.
FAILED: file aftwf01.sql on worker 3.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.
```

--------------------------------

### Pass Multiple Parameters on Command Line

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Provide multiple parameter-value pairs on a single command line separated by spaces.

```text
printdebug=y flags=hidepw
```

--------------------------------

### Remove Patch Base Directory

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Deletes the patch base directory to facilitate a single file system development environment setup.

```bash
$ rm -rf $PATCH_BASE
```

--------------------------------

### Define a custom report in oamcustext.amx

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T221119.htm

Example entity structure for defining a custom SQL report, including grouping, protection, and execution mode.

```xml
<cReport type="SQL" group="DefaultC">
<title>sysdate.sql</title> <script name="sysdate.sql" protected="yes" execMode="SQLPLUS" parameters="unknown">
</script>
</cReport>
```

--------------------------------

### Run adop phase command

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

General syntax for executing a specific phase of the online patching cycle.

```bash
adop phase=<phase_name>
```

--------------------------------

### Source the patch file system environment

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530135.htm

Execute this command to set the environment before running AD utilities.

```bash
$ source <patch APPL_TOP path>/APPS<CONTEXT_NAME>.env
```

--------------------------------

### Example worker failure message

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530135.htm

A sample error log output showing an ORA-01630 error encountered during a SQL execution by an AD worker.

```text
AD Worker error:
The following ORACLE error:

ORA-01630: max # extents (50) reached in temp segment in tablespace TSTEMP
occurred while executing the SQL statement:

CREATE INDEX AP.AP_INVOICES_N11 ON AP.AP_INVOICES_ALL (PROJECT_ID, TASK_ID)
NOLOGGING STORAGE (INITIAL 4K NEXT 512K MINEXTENTS 1 MAXEXTENTS 50
PCTINCREASE 0 FREELISTS 4) PCTFREE 10 MAXTRANS 255 TABLESPACE  APX

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error
above
```

--------------------------------

### Execute adop with delta synchronization mode

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Use the prepare_sync_mode parameter to specify delta synchronization during the prepare phase.

```bash
$ adop phase=prepare prepare_sync_mode=delta
```

--------------------------------

### adop Command Line Usage

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

General syntax for executing the adop utility using command line arguments or an input file.

```APIDOC
## adop Command Line

### Description
adop is a non-interactive utility used for patching. Arguments can be passed directly on the command line or via an input file.

### Usage
$ adop phase=apply input_file=<input_file.txt>
$ adop parameter1=value1 parameter2=value2

### Parameters
- **phase** (string) - Required - The patching phase to execute (e.g., apply).
- **input_file** (string) - Optional - Path to a text file containing parameter=value pairs.
- **parameter=value** (string) - Optional - Configuration arguments passed in name=value format.
```

--------------------------------

### Define input file for adop apply

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Format for the input file used to define worker counts and patch lists.

```text
workers=<number of workers>
patches=<patch number 1>:<driver file 1>.drv, <patch number 2>:<driver file 2>.drv ...
```

--------------------------------

### Force JAR File Generation Prompt

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Prompt displayed when running the Generate Product JAR Files task.

```text
Do you wish to force generation of all jar files? [No]
```

--------------------------------

### Check OPatch inventory with local pointer

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Command syntax for checking inventory when using a local inventory pointer file.

```bash
$ opatch lsinventory -invPtrLoc <path to oraInst.loc file>
```

--------------------------------

### Manage Oracle Database on Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use addbctl.cmd to control the database instance on Windows platforms.

```batch
C:\> addlnctl.cmd [start|stop] <listener_name>
```

```batch
C:\> addbctl.cmd stop normal
```

--------------------------------

### Product File Backup Path

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

The source and destination paths for backing up product files during the copy portion of a unified driver.

```text
<PROD>_TOP/<subdir(s)>/<old_file_name>
```

```text
<patch_dir>/backup/<system_name>/<appl_top_name>/<prod>/<subdir(s)>/<old_file_name>
```

--------------------------------

### Set Run File System Environment

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Source the environment file to configure the run file system before performing patching tasks.

```bash
$ source <EBS install base>/EBSapps.env run
```

--------------------------------

### Set the EBS Environment

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Initializes the system configuration parameters required for AD utilities.

```shell
$ . <EBS_ROOT>/EBSapps.env run
```

--------------------------------

### Access AD Administration Help

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use the help=y argument to display available arguments and options for the AD Administration utility.

```bash
adadmin help=y
```

--------------------------------

### Manage SSH with txkRunSSHSetup.pl

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Uses the provided Perl script to enable or verify SSH connectivity across multiple hosts.

```perl
$ perl $AD_TOP/patch/115/bin/txkRunSSHSetup.pl enablessh -contextfile=<CONTEXT_FILE> -hosts=h1,h2,h3$
```

```perl
$ perl $AD_TOP/patch/115/bin/txkRunSSHSetup.pl verifyssh -contextfile=<CONTEXT_FILE> -hosts=h1,h2,h3 \
-invalidnodefile=<filename to report ssh verification failures>
```

--------------------------------

### Abort and Cleanup Commands

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Execute these commands in sequence to reset the environment when synchronization errors cannot be automatically resolved.

```bash
adop phase=abort
adop phase=cleanup cleanup_mode=full
adop phase=fs_clone force=yes
```

--------------------------------

### Run adop session for distributed workers

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Initiate an adop session using an input file to manage worker distribution.

```bash
$ adop phase=apply input_file=myinput.txt
```

--------------------------------

### Verify Environment Variables

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Check environment variables to confirm the correct file system is sourced.

```bash
$ echo $FILE_EDITION
run
$ echo $TWO_TASK
dbSID
```

```bash
$ echo $FILE_EDITION
patch
$ echo $TWO_TASK
dbSID_patch
```

--------------------------------

### Suite Products Configuration in adlicmgr.ini

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Defines the suite families available when selecting the License E-Business Suite option.

```ini
[Suite Products]
Suite Families={Basic,Marketing & Sales Intelligence,Supply Chain & Order Management Intelligence,Procurement Intelligence,Service Intelligence,Projects intelligence,Financials Intelligence,Balanced Scorecard,Enterprise Planning and Budgeting,Profitability Manager,Marketing,TeleSales,Field Sales,Order Management,Inventory Management,Purchasing,Discrete Manufacturing,Process Manufacturing,TeleService,Service Contracts,Project Costing,Project Billing,Financials,Human Resources}
```

--------------------------------

### Enable Logging via Command Line JVM System Properties

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T359301.htm

Use these system properties to enable logging for a Java application run from the command line.

```bash
/local/java/jdk1.2.2/bin/java \ 
-DAFLOG_ENABLED=TRUE -DAFLOG_LEVEL=STATEMENT \
-DAFLOG_MODULE=% -DAFLOG_FILENAME=/path/to/apps.log MyClass
```

--------------------------------

### Run adop cleanup with analytics

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Execute the cleanup phase with analytics enabled to generate a status report.

```bash
$ adop phase=cleanup analytics=yes
```

--------------------------------

### Execute fs_clone Phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run this command from the run file system to clone the run file system to the patch file system.

```bash
$ adop phase=fs_clone
```

--------------------------------

### adop Preinstall Mode

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Execution mode for updating AD utilities or applying pre-upgrade patches without database connectivity.

```APIDOC
## adop preinstall=y

### Description
Preinstall mode is used during upgrades to update AD utilities or apply pre-upgrade patches. It performs file copying, version comparison, and executable relinking without requiring a database connection.

### Parameters
- **preinstall** (string) - Required - Set to 'y' to enable preinstall mode.
```

--------------------------------

### Parameters for adfhrept.sql

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Required parameters for running the adfhrept.sql script to display file change information.

```text
<filename> <latest file version only? (Y/N) \
<start_date (mm/dd/rr or ALL)> <end_date (mm/dd/yyyy or ALL)> \
<patchtype/ALL> <language/ALL> \
<appltop/ALL> <limit to forms server? (Y/N)> \
<limit to web server? (Y/N)> \
<only patches that change DB? (Y/N)>
```

--------------------------------

### Run Technology Inventory Utility on Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T499006.htm

Commands to execute the inventory utility on Windows application and database tiers.

```shell
perl %FND_TOP%\patch\115\bin\TXKScript.pl 
-script=%FND_TOP%\patch\115\bin\txkInventory.pl 
-txktop=%APPLTMP% 
-contextfile=%CONTEXT_FILE% 
-appspass=_password_ 
-outfile=%APPLTMP%\Report_Inventory.html
```

```shell
perl %ORACLE_HOME%\appsutil\bin\TXKScript.pl 
-script=%ORACLE_HOME%\appsutil\bin\txkInventory.pl 
-txktop=%ORACLE_HOME%\appsutil\temp 
-contextfile=%CONTEXT_FILE% 
-appspass=_password_ 
-outfile=%ORACLE_HOME%\appsutil\temp\Report_Inventory.html 
```

--------------------------------

### adop Command Line Parameters

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

The adop utility accepts various parameters to configure patching phases, logging, and execution behavior.

```APIDOC
## adop Command Line Parameters

### Description
The adop utility supports several parameters to manage patching operations. Parameters are passed via the command line.

### Parameters
- **phase** (string) - Optional - Comma-separated list of phases (e.g., prepare, apply). Note: abort and fs_clone cannot be combined with other phases.
- **loglevel** (string) - Optional - Amount of information logged (STATEMENT, PROCEDURE, EVENT, WARNING, ERROR, UNEXPECTED). Default is EVENT.
- **input_file** (string) - Optional - Absolute path to the input file.
- **patches** (string) - Optional - Comma-separated list of patches to apply. Format: <Patch Number> or <Patch Directory>:<Patch Driver File>.
- **hotpatch** (string) - Optional - yes/no. Superseded by apply_mode; retained for backward compatibility.
- **prompt** (string) - Optional - yes/no. Default is 'yes'. Set to 'no' for non-interactive mode.
- **workers** (integer) - Optional - Number of parallel workers.
- **defaultsfile** (string) - Optional - Absolute path to custom defaults file. Default: $APPL_TOP/admin/$TWO_TASK.
- **patchtop** (string) - Optional - Absolute path to patch location. Default: $PATCH_TOP.
- **allowcoredump** (string) - Optional - yes/no. Default is 'no'.
- **analytics** (string) - Optional - yes/no. Default is 'no'.
- **validation** (string) - Optional - full/bypass. Default is 'full'.
```

--------------------------------

### Java Flight Recorder JVM Parameters

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T575556.htm

JVM arguments added to startup scripts when JFR is enabled via AutoConfig.

```text
-XX:+UnlockCommercialFeatures -XX:+FlightRecorder
```

--------------------------------

### AD Administration Menu Options

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

List of valid menu options that can be passed to the menu_option argument to execute specific tasks.

```text
RELINK                                       Relink Applications programs
GEN_MESSAGES                            Generate message files
GEN_FORMS                                       Generate form files
GEN_REPORTS                             Generate reports files
GEN_JARS                                        Generate product JAR files
VALIDATE_APPS                           Validate APPS schema
CMP_INVALID                             Compile APPS schema
CMP_MENU                                        Compile menu information
CREATE_GRANTS                           Recreate grants and synonyms for APPS schema
CMP_FLEXFIELDS                  Compile flexfield data in AOL tables
MAINTAIN_MLS                            Maintain multi-lingual tables
CHECK_DUAL                                      Check DUAL table
RELOAD_JARS                             Reload JAR files to database
COPY_FILES                                      Copy files to destinations
CHECK_FILES                             Check for missing files
LIST_SNAPSHOTS                          List snapshots
UPDATE_CURRENT_VIEW     Update current view snapshot
CREATE_SNAPSHOT                         Create named snapshot
EXPORT_SNAPSHOT                         Export snapshot to file
IMPORT_SNAPSHOT                         Import snapshot from file
DELETE_SNAPSHOT                         Delete named snapshot(s)
CONVERT_CHARSET                         Convert character set
SCAN_APPLTOP                            Scan the APPLTOP for exceptions
SCAN_CUSTOM_DIR                         Scan a CUSTOM directory for exceptions
```

--------------------------------

### Run adopscanlog utility

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Commands for scanning adop log directories for errors and warnings using various parameters.

```bash
$ adopscanlog
```

```bash
$ adopscanlog -latest=yes
```

```bash
$ adopscanlog -latest=yes -phase=<phase_name>
```

```bash
$ adopscanlog -session_id=<number>
```

```bash
$ adopscanlog -scan_dir=<full path of directory to scan>
```

```bash
$ adopscanlog -help
```

--------------------------------

### Define adop parameters in an input file

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Parameters in an input file must follow the 'name=value' format with one parameter per line.

```text
phase=apply
patches=123456
workers=8
```

--------------------------------

### Manage Oracle Database on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use addbctl.sh to control the database instance with specific shutdown modes.

```bash
$ addbctl.sh [start|stop] {immediate|abort|normal}
```

```bash
$ addbctl.sh stop normal
```

--------------------------------

### Execute adop patching cycle phases

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Standard sequence of commands to perform an online patching cycle.

```bash
$ adop phase=prepare

$ adop phase=apply patches=<patch number>

$ . <EBS_ROOT>/EBSapps.env patch
$ sqlplus apps/apps @my_custom_script_01
$ sqlplus apps/apps @my_custom_script_02
...

$ adop phase=finalize

$ adop phase=cutover
$ . <EBS_ROOT>/EBSapps.env run

$ adop phase=cleanup
```

--------------------------------

### Create appsutil.zip

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Generates the appsutil.zip file on the application tier run file system.

```perl
$ perl <AD_TOP>/bin/admkappsutil.pl
```

--------------------------------

### Relink AD Executables via Command Line

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Syntax for running the AD Relink utility on UNIX and Windows platforms.

```shell
$ adrelink.sh force={y | n} [<optional arguments>] <ad program name>
```

```shell
C:\> sh adrelink.sh force={y | n} [<optional arguments> <ad program name>
```

--------------------------------

### Create Statistics Table with FND_STATS.CREATE_STAT_TABLE

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T174306.htm

Creates the required table for backing up statistics. Use the version with arguments to specify custom schema, table, and tablespace names.

```PL/SQL
FND_STATS.CREATE_STAT_TABLE ;

FND_STATS.CREATE_STAT_TABLE (
   schemaname  IN  VARCHAR2, 
   tabname     IN  VARCHAR2, 
   tblspcname  IN  VARCHAR2);
```

--------------------------------

### Unzip Patch Files

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Extract the downloaded patch files into the designated directory.

```bash
$ unzip p99999999.zip
```

--------------------------------

### Product Families Configuration in adlicmgr.ini

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T469980.htm

Defines the product families available when selecting the License Component Application option.

```ini
[Product Families]
All Families={All,Intelligence,Marketing & Sales,Channel Revenue Management,Order Management,Logistics,Supply Chain Planning,Procurement,Manufacturing,Asset Lifecycle Management,Service,Projects,Product Lifecycle Management,Financial,Human Resources,Learning Management,Master Data Management - Customer Hub for B2B,Master Data Management - Customer Hub for B2C,Master Data Management - Site Hub,Master Data Management - Administrative & Development,Master Data Management - Product Information Management,Master Data Management - Vertical Product Hub,Product Hub Options,Interaction Center Technology,Financial Services,Communications/Utilities,Public Sector/University,High Tech,Aerospace Defense and Transportation}
```

--------------------------------

### Running AD Relink on UNIX and Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Commands to execute the AD Relink utility on different operating systems.

```shell
S adrelink.sh force=n "ad <executable name>"
```

```shell
C:\> sh adrelink.sh force=n "ad <executable name>"
```

--------------------------------

### Run Technology Inventory Utility on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T499006.htm

Commands to execute the inventory utility on UNIX application and database tiers.

```shell
perl $FND_TOP/patch/115/bin/TXKScript.pl 
-script=$FND_TOP/patch/115/bin/txkInventory.pl 
-txktop=$APPLTMP  
-contextfile=$CONTEXT_FILE 
-appspass=_password_ 
-outfile=$APPLTMP/Report_Inventory.html
```

```shell
perl $ORACLE_HOME/appsutil/bin/TXKScript.pl 
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl 
-txktop=$ORACLE_HOME/appsutil/temp 
-contextfile=$CONTEXT_FILE 
-appspass=_password_ 
-outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html
```

--------------------------------

### Enable Logging via C Environment Variables

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T359301.htm

Set these environment variables before executing a C process to configure logging behavior.

```csh
!#/bin/csh
setenv AFLOG_ENABLED Y
setenv AFLOG_LEVEL STATEMENT
setenv AFLOG_MODULE %
setenv AFLOG_FILENAME /path/to/apps.log
./C-Executable
```

--------------------------------

### Execute AD Administration with Logfile Argument

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Demonstrates the incorrect usage of uppercase tokens and the corrected lowercase format for the adadmin utility.

```bash
$ adadmin LOGFILE=TEST.LOG
```

```bash
$ adadmin logfile=test.log
```

--------------------------------

### Resume Failed Cutover Phase

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run this command to resume and complete a cutover process that failed with an 'Invalid Credentials' error after the database patch edition was promoted.

```bash
adop phase=cutover action=nodb
```

--------------------------------

### Set Environment Variables on Windows

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Command to initialize the environment variables required for AD utilities on Windows systems.

```shell
C:\> . ./apps.sh
```

--------------------------------

### Migrate Passwords with AFPASSWD

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T174305.htm

Use these commands to initiate password migration. The -m option performs migration with invalid user removal disabled, while -M enables it.

```bash
AFPASSWD [-c _<APPSUSER>_[@_<TWO_TASK>_]] -m _<HASH-MODE>_
```

```bash
AFPASSWD [-c _<APPSUSER>_[@_<TWO_TASK>_]] -M _<HASH-MODE>_
```

--------------------------------

### Custom Synchronization Driver section

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Add custom patching commands between the Begin and End Customization markers in the driver file.

```text
#Begin Customization
...
#End Customization
```

--------------------------------

### Change APPS, APPLSYS, and APPS_NE Passwords

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T174305.htm

Use the SYSTEM mode to synchronize passwords across the APPS, APPLSYS, and APPS_NE schemas. Ensure all application tier services are shut down before execution.

```shell
FNDCPASS <logon> 0 Y <SYSTEM username>/<SYSTEM password>  SYSTEM \ 
        <username> <new_password> 
```

```shell
FNDCPASS <APPS username> 0 Y <SYSTEM username>/<SYSTEM password> SYSTEM APPLSYS <new_password>
```

--------------------------------

### Invoke adopreports utility

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Run the diagnostic reports utility by providing the APPS username and password.

```bash
$ adopreports <APPS username> <APPS password>
```

--------------------------------

### Abort and perform full cleanup

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Execute a combined command to abort the current patching cycle and immediately perform a full cleanup.

```bash
$ adop phase=abort,cleanup cleanup_mode=full
```

--------------------------------

### Relink AD Executables with Backup

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Command to relink all AD executables while creating a backup of the original files.

```shell
$ adrelink.sh force=y backup_mode=all
```

--------------------------------

### Locate System-Generated Defaults File

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

The path to the system-generated defaults file. If corrupted, AutoConfig will automatically regenerate it.

```text
$APPL_TOP/admin/<SID>/adalldefaults.txt
```

--------------------------------

### Handle Prepare Phase Failure

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Displayed when the prepare phase fails on secondary nodes during an apply or cutover attempt.

```text
Prepare phase failed on node <node_name>. If you choose to proceed with cutover, node <node_name> will be marked as abandoned. Do you want adop to continue processing on completed nodes [y/n]?
```

--------------------------------

### Run AD Job Timing Report on UNIX

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530134.htm

Execute the adtimrpt.sql script via SQL*Plus to generate a timing report for a specific session ID.

```bash
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS username>/<APPS password> @$AD_TOP/admin/sql/adtimrpt.sql \
<session id> <output file>
```

--------------------------------

### Set environment for run edition

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Commands to configure the environment for the run edition before executing management scripts.

```bash
$ . <EBS_ROOT>/EBSapps.env run
$ adstrtal.sh
```

--------------------------------

### adop Command Parameters

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Reference for parameters used to control the behavior of the adop utility during various patching phases.

```APIDOC
## adop Parameters

### Description
The adop utility accepts various parameters to control the execution of patching phases such as prepare, apply, finalize, cutover, cleanup, fs_clone, and abort.

### Parameters

#### Apply Phase Parameters
- **abandon** (yes/no) - Optional - Specifies whether to abandon a previous failed attempt to apply a patch. Default is 'no'. Mutually exclusive with 'restart'.
- **restart** (yes/no) - Optional - Specifies if the previous failed patch apply should be restarted. Default is 'no'. Mutually exclusive with 'abandon'.
- **apply_mode** (online/downtime/hotpatch) - Optional - Allows patches to be applied in specific modes. Default is 'online'.
- **flags** (string) - Optional - Used to specify various options, typically in pairs (e.g., logging/nologging).
- **merge** (yes/no) - Optional - Used to merge multiple patches into a single operation. Default is 'no'.
- **options** (string) - Optional - Used to specify various phase-specific options.

#### Cutover Phase Parameters
- **cm_wait** (integer) - Optional - Specifies the number of minutes to wait for concurrent processes to finish before shutting down the Internal Concurrent Manager.
- **mtrestart** (yes/no) - Optional - Specifies whether to restart application tier services after cutover. Default is 'yes'.

#### Cleanup Phase Parameters
- **cleanup_mode** (quick/full) - Optional - Controls the extent of cleanup operations. Default is 'standard' (drops obsolete code objects).

#### Global Parameters
- **phase** (prepare/apply/finalize/cutover/cleanup/fs_clone/abort/actualize_all) - Required - Specifies which phase adop is to run.
```

--------------------------------

### Handling already applied patches

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Shows the warning message displayed when attempting to reapply a patch without the forceapply option.

```text
 [WARNING] Skipping the application of patch
14125999_AR since it has been already applied
[WARNING]  Hint: Patches can be applied again by
specifying options=forceapply when invoking adop
```

--------------------------------

### Enable Database Operation Tracing

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T530133.htm

Use the trace flag to log internal database operations performed by the AD utility to trace files.

```shell
adadmin flags=trace
```

--------------------------------

### Configure Database Recycle Bin

Source: https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531065.htm

Set the recyclebin parameter to off.

```text
recyclebin=off
```