Oracle E-Business Suite Maintenance Guide

https://docs.oracle.com/cd/E26401_01/doc.122/e22954/
Admin
The Oracle E-Business Suite Maintenance Guide provides comprehensive instructions, procedures, and...
Tokens:65,816
Snippets:1,036
Trust Score:9.1
Update:2 months ago
Show doc for...
Tokens:
Raw
### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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.
```

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

### 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
```

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

### 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
```

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

### 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>
```

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

### 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>
```

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

### 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
```

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

### 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
```

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

### 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
```

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

### 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.
#
```

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

### 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>
```

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

### 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
```
Tokens:
Raw