In Oracle : Oracle AD Utilities arguments & flags

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle AD Utilities arguments & flags

 

Oracle AD Utilities arguments & flags

 

1. What is the usage of the AD utilities arguments & flags ?

2. AD Utilities: Common arguments

3. AD Utilities: Flags

4. AD Administration specific arguments

5. AutoPatch specific arguments

6. AD Controller specific arguments

 

 

1. What is the usage of the AD utilities arguments & flags ?

 

 

AD utilities accept arguments and flags to change the execution behaviour of the AD utility. 

 

NOTE: The arguments must be typed in lowercase without whitespace characters between them.

 

Example:   $adpatch options=nocopyportion,negenerateportion

 

 

2. AD Utilities: Common arguments

 

argument Description Values Default value
help Describe the syntax of the command. Using help argument doesn't starts the AD utility.   y or n n    (adadmin help=y)
logfile Specifies the location of the log file. Useful in non-interactive mode, but could be used in interactive mode as well.  n/a n/a  (AD utility will prompt you for the log file if the argument is not specified)
printdebug  The execution of the AD utility will show more debug information.  y or n n
flags Passes to AD utility one or more flags <all the flags available> n/a

 

 

3. AD Utilities: Flags 

 

flag Description
hidepw

(by default)

(Starting 11.5.9; before this version the password was inserted by default => a security risk)

The password IS NOT showed in the log files. 

nohidepw (Starting 11.5.9)

The password IS showed in the log files. 

logging

 

(by default in AutoConfig)

 

Uses LOGGING option when indexes are created. 

NOTE: LOGGING mode slow down the performance of the database, but makes the indexes recoverable after a database media recovery and also needed if a standbay database is configured. 

nologging

(by default in AutoUpgrade)

Uses NOLOGGING option when indexes are created. 
trace Creates a trace file each time the AD utility connects to the database. In this trace there are no information related to the SQL statements run by the workers.   
notrace

(by default)

 

 

 

 

4. AD Administration specific arguments

 

argument Description Values Default value
abandon (Only in interactive mode)

Used to abandon a session. When the session will restart it will restart from the beginning and not from the failure point.

y or n n
defaultsfile Specifies the location of the "defaults" file which contains the responses. This file is used in non-interactive mode. 

Note: the value of this argument must be a fully-qualified filename and the defaults file must be under $APPL_TOP/admin/<SID> directory.

n/a n/a
interactive Specifies if the AD utility is run in interactive mode or not. y or n y
localworkers Specifies how many workers will run on the primary node in an Distributed AD environment (On a Shared APPL_TOP environment one node is the primary node).  1..n 

n = min (max supported by the database, 999)

The all workers run by default on the primary node. 
menu_option When run in an interactive mode, the defaults file could have more menu options. This argument specifies which menu options to be used.  n/a n/a
parallel_index_treshhold Fix a number of blocks as treshhold. 

If a table has less blocks than parallel_index_treshhold =>   indexes will be created with parallel workers and serial DML. 

If a table has more blocks than parallel_index_treshhold =>   indexes will be created with 1 worker and parallel DML. 

n/a

if 0 then the indexes will be created with parallel workers and serial DML. 

20.000
restart (when non-interactive mode is used)

To restart or not an existing session.

y or n n   (a completely new session is expected to be run)
wait_on_failed_job The utility will wait for the user input in a non-interactive session when a job fails. y or n n
workers Establishes the number of workers which will be used for that session. The optimal number is 2 or 3 x number of CPUs.   1 .. 999 n/a

 

 

5. AutoPatch specific arguments

 

argument Description Values Default value
abandon (Only in interactive mode)

Used to abandon a session. When the session will restart it will restart from the beginning and not from the failure point.

y or n n
defaultsfile Specifies the location of the "defaults" file which contains the responses. This file is used in non-interactive mode. 

Note: the value of this argument must be a fully-qualified filename and the defaults file must be under $APPL_TOP/admin/<SID> directory.

n/a n/a
interactive Specifies if the AD utility is run in interactive mode or not. y or n y
localworkers Specifies how many workers will run on the primary node in an Distributed AD environment (On a Shared APPL_TOP environment one node is the primary node).  1..n 

n = min (max supported by the database, 999)

The all workers run by default on the primary node. 
parallel_index_treshhold Fix a number of blocks as treshhold. 

If a table has less blocks than parallel_index_treshhold =>   indexes will be created with parallel workers and serial DML. 

If a table has more blocks than parallel_index_treshhold =>   indexes will be created with 1 worker and parallel DML. 

n/a

if 0 then the indexes will be created with parallel workers and serial DML. 

20.000
restart (when non-interactive mode is used)

To restart or not an existing session.

 

y or n n   (a completely new session is expected to be run)
wait_on_failed_job The utility will wait for the user input in a non-interactive session when a job fails. y or n n
workers Establishes the number of workers which will be used for that session. The optimal number is 2 or 3 x number of CPUs. 1 .. 999 n/a

 

 

6. AD Controller specific arguments 

 

argument Description Values Default value
menu_option When run in an interactive mode, the defaults file could have more menu options. This argument specifies which menu options to be used.  n/a n/a

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Oracle AD Utilities arguments & flags

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.