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-2012 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.