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