Re: adpatch

  • From: "Navdeep Singh" <navdeep.singh1@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • 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
>
>

Other related posts: