RE: adpatch

  • From: "Vasu Balla" <appsdba@xxxxxxxxx>
  • To: <ora-apps-dba@xxxxxxxxxxxxx>
  • Date: Fri, 3 Aug 2007 22:20:21 +0530

 

Your defaults file is missing some entries which are required for
nodatabaseportion option. What you need to do to get it fixed it is, run
your command with interactive=yes one time. This will  prompt for any
missing entries in defaults file and the same will get updated to defaults
file. In the next run you can use  interactive=no with out any further
issues

 

vasu

 

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Navdeep Singh
Sent: Friday, August 03, 2007 7:18 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: adpatch

 

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: