Oracle   Home  

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI

Oracle Applications EBS 11i, R12

 Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  Oracle AD Utilities arguments & flags

 

Oracle Applications 11i eBusiness Suite DBA

Oracle AD Utilities arguments & flags

 

 

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)

 

 

 

More information about  this subject ( Oracle AD Utilities arguments & flagsyou can get from  www.in-oracle.com.

 

 

Different Romanian Links/ Linkuri romanesti diferite

 

 

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI Oracle Applications EBS 11i, R12  Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  Oracle AD Utilities arguments & flags

 

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. Copyright (c) 2009-2011 Paul Catalin Tomoiu. All rights reserved.