This has to be supposed to be fixed in AD.H, apply latest AD minipack. or Resolved by adding the following to defaults.txt file: ## Start of Defaults Record %%START_OF_TOKEN%% ACTION_TURNED_OFF %%END_OF_TOKEN%% %%START_OF_VALUE%% Yes %%END_OF_VALUE%% ## End of Defaults Record --Atul & Jurijs and all others I appriciate your participation in this group. Thanks. -V ----- Original Message ----- From: "Navdeep Singh" To: ora-apps-dba@xxxxxxxxxxxxx Subject: Re: adpatch Date: Fri, 3 Aug 2007 09:48:19 -0400 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 -- We've Got Your Name at http://www.mail.com! Get a FREE E-mail Account Today - Choose From 100+ Domains