Navdeep, Just to double check: have you tried to run the command in that format adpatch flags=hidepw defaultsfile=<file> logfile=$line.log patchtop=<dir> driver=u$line.drv interactive=no workers=15 options=prereq,nocompiledb,nodatabaseportion Do not use "restart=yes" option at the time you change anything in initial call. You suppose to use the exactly the same cmd string at the time you restart adpatch session. Please note that options format. You suppose to use comma without any spaces between parameters. Jurijs On 8/3/07, Navdeep Singh <navdeep.singh1@xxxxxxxxx> wrote: > Gurus, > > I have a followup question on adpatch. How do i run adpatch in > non-interactive mode and be able to specify options like nodatabaseportion > and nocompiledb. > Here is how my current adpatch command in non-interactive mode looks like > > adpatch flags=hidepw > defaultsfile=$APPL_TOP/admin/$TWO_TASK/defaults.txt > logfile=$line.log patchtop=$PATCH_TOP/$line driver=u$line.drv interactive=no > workers=15 options=prereq restart=yes > > This works fine, but when I add options=nocompiledb or nodatabaseportion, it > errors out with this message > > AutoPatch will not execute the following actions in your patch driver file > because you requested this using the keyword argument 'options='. > > > sql > exec > > Cannot find value for the token ACTION_TURNED_OFF > The program could not get default values from the defaults file > you have specified. Please check that you have specified the correct > defaults file. > > > Any ideas how can i pass these options in non-interactive mode? > > Thanks > > Navdeep > > > > > > > On 8/3/07, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote: > > > PS We are more then 200 now ;) > > 227 to be precise. > > > > J. > > > > On 8/3/07, Jurijs Velikanovs < j.velikanovs@xxxxxxxxx> wrote: > > > Veera, > > > > > > Thank you for an excelent input. > > > Atul: The best appriciation for received answers is your > > > participiation in the list and others Apps DBA involvment ;) > > > > > > PS We are more then 200 now ;) > > > > > > Thank you all, > > > Jurijs > > > > > > On 8/3/07, Veera Phaneendra Aila <veeraphaneendra@xxxxxxxx> wrote: > > > > This feature matrix is used to check any mismatch between the AD code > file > > > > system and AD database objects. > > > > When both versions not matched (appltop files and db objects versions) > then > > > > the particular feature get disabled, by default the features will be > in > > > > enable mode. These features were depends on AD minipacks (details at > meta > > > > link : Note:210326.1) > > > > > > > > Flags ledger > > > > -------------- > > > > 1 Flag : Feature enabled at APPL_TOP > > > > 2 Flag : Require enabling on file system > > > > 3 Flag : Enabling file exists > > > > 4 Flag : Depends on any db objects > > > > 5 Flag : Value of the sixth flag is revelent > > > > 6 Flag : Enabled in DB. > > > > > > > > > > > > -V > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Kishore Adikar" > > > > To: ora-apps-dba@xxxxxxxxxxxxx > > > > Subject: adpatch > > > > Date: Thu, 2 Aug 2007 14:34:01 +0530 > > > > > > > > > > > > > > > > When we run adpatch we get the below information, what are that Flags? > What > > > > are these features > > > > > > > > CHECKFILE, CONCURRENT_SESSIONS, PATCH_TIMING, SCHEMA_SWAP > > > > > > > > > > > > > > > > The status of various features in this run of AutoPatch is: > > > > > > > > > > > > > > > > <-Feature > > > > version in-> > > > > > > > > Feature Active? APPLTOP > Data > > > > model Flags > > > > > > > > ------------------------------ ------- -------- > > > > ----------- ----------- > > > > > > > > CHECKFILE Yes 1 > 1 > > > > Y N N Y N Y > > > > > > > > PREREQ Yes 6 > 6 > > > > Y N N Y N Y > > > > > > > > CONCURRENT_SESSIONS No 2 > 2 > > > > Y Y N Y Y N > > > > > > > > PATCH_TIMING Yes 2 > 2 > > > > Y N N Y N Y > > > > > > > > PATCH_HIST_IN_DB Yes 6 > 6 > > > > Y N N Y N Y > > > > > > > > SCHEMA_SWAP Yes 1 > 1 > > > > Y N N Y Y Y > > > > > > > > > > > > > > > > Regards, > > > > > > > > Kishore > > > > > > > > > > > > -- > > > > Enter the Bourne Ultimatum Sweepstakes > > > > View Trailer, Win Free Prizes. In Theaters 08.03.07 > > > > > > > > > -- > > > Yury > > > +371 29268222 (+2 GMT) > > > ============================================ > > > http://otn.oracle.com/ocm/jvelikanovs.html > > > > > > > > > -- > > Yury > > +371 29268222 (+2 GMT) > > ============================================ > > http://otn.oracle.com/ocm/jvelikanovs.html > > > > > > -- Yury +371 29268222 (+2 GMT) ============================================ http://otn.oracle.com/ocm/jvelikanovs.html