RE: ADCFGCLONE.PL at DB fail
- From: "NEELI-SC, Mamta" <Mamta.NEELI@xxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Wed, 6 May 2009 15:05:52 +0800
Hi Mostafa...
How did you resolve the below issue?
I'm interested to know that.
Thanks,
Mamta
________________________________
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Mostafa Eletriby
Sent: Friday, 16 January 2009 22:30
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: ADCFGCLONE.PL at DB fail
Hi James,
Thanks for ur quick response.
I want to clarify an issue.Actually this datafile is created since long
of time but it was created by mistake by an unspecialist ,
(GMFD0.DBF.ORA) which is wrong extension but when he tried to solve this
issue it was made offline but couldnt be removed by enterprise manager
after that. Then deleted too safely from DATA_TOP and no problems
happened and the database running normal till the moment.
But Enterprise Manager still showing that it is offline and needs
recovery , But it is removed physically from datafiles, causing no
errors in starting up and shutting down the database.
It had no blocks and no transactions are performed over it.
The precolone finished successfully at source as you see in the log
file.And No patches applied at all after after the preclone Also The
backup is taken full successfully.
Is there a solution to solve this issue at target as this problem shall
repeat again as no transactions or patches applied after precolone
phase.
Also Mr. James if I succeeded to remove this refer in Enterprise Manager
by performing some sql statements at source DB to solve this issue of
Datafile at Source in ordre to succeed at Target.
Thanks alot for your support
Regards,
--- On Fri, 1/16/09, James Morrow <morrow.james@xxxxxxxxx> wrote:
From: James Morrow <morrow.james@xxxxxxxxx>
Subject: Re: ADCFGCLONE.PL at DB fail
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Friday, January 16, 2009, 8:48 AM
I suspect that a datafile was added to the source database
in-between
steps of your clone.
Here's what generally happens:
1) When you run adpreclone.pl, it (essentially) does an "alter
database backup controlfile to trace" and stores the information
from
that in a file within ${ORACLE_HOME}/appsutil. This represents
all of
the datafiles in the database at that particular time.
2) You then take your database backup for the clone.
3) When you run adcfgclone.pl on the dbTier, it uses the
information
from #1 above to try to generate a new controlfile.
In your case, since you had to rerun adpreclone.pl on your
source, the
information gathered in #1 represents the state of the source at
that
time. Your backup (your target) represents an earlier time
(prior to
the addition of that datafile). So, the "create controlfile"
step
that adcfgclone is doing is going to fail.
Simplest suggestion? If you haven't applied ANY patches to the
source
database since you started the cloning process, just take
another
backup of the database and bring it over. If you HAVE applied
ANY
patches, you'll want to re-clone the whole thing.
-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA | TriOra Group,
LLC
morrow.james <at> gmail <dot> com
james.morrow <at> trioragroup <dot> com
On Fri, Jan 16, 2009 at 6:59 AM, Mostafa Eletriby
<m_etrib@xxxxxxxxx>
wrote:
> Hi DBAs,
> Hi Jammes , Hi Vikram , sorry for inconvenience.
>
> I had a a problem with adfcgclone.pl as it stoped again in
ctreating the
> control file.
> As the specific datafile has a problem.
> As you see in the previous log file and this print screen from
Enterprise
> Manager.
>
> this datafile is unavailable.
> Please advice me.
>
> thanks alot.
> Regards,
>
> --- On Fri, 1/16/09, Mostafa Eletriby <m_etrib@xxxxxxxxx>
wrote:
>
> From: Mostafa Eletriby <m_etrib@xxxxxxxxx>
> Subject: Re: ADCFGCLONE.PL at DB always fail
> To: ora-apps-dba@xxxxxxxxxxxxx
> Date: Friday, January 16, 2009, 7:31 AM
>
> Hi DBAs,
>
> Hi James and Morrow , special thanks to you both.
> I solved the problem of the instconf.drv at postclone of DB.
I followed
the
> previous steps.
>
> But Now I am in a critical situation. As ADCFGCLONE.PL stopped
again with
> error as it couldnt critical situation now as the script
failed with error
> in a specific datafile as you see in the attached log file
> (GMFD0.DBF.ORA) which cant open it , but it is not present by
this
extension
> in the DATA_TOP.
>
> Please advice me.
>
> Your response is very highly appreciated :)
>
> Regards,
> Mostafa
>
>
>
> --- On Thu, 1/15/09, Vikram <vikramsingh120@xxxxxxxxx> wrote:
>
> From: Vikram <vikramsingh120@xxxxxxxxx>
> Subject: Re: ADCFGCLONE.PL at DB always fail
> To: ora-apps-dba@xxxxxxxxxxxxx
> Date: Thursday, January 15, 2009, 3:22 PM
>
> Hello Mostafa,
>
> I agree with James.
> When you run admkappsutil.pl, the script shows the location of
the
> appsutil.zip file it is creating. It usually is
$APPL_TOP/admin/out
> directory. You will have to copy this across to the db-node's
$ORACLE_HOME
> dir. Then copy the XML file from the appsutil_old directory
into this new
> appsutil directory and run autoconfig. Then run adpreclone.
> Then follow rest of the steps.
>
> -Vikram
> On Thu, Jan 15, 2009 at 3:06 PM, Mostafa Eletriby
<m_etrib@xxxxxxxxx> wrote:
>>
>> Hi james,
>>
>> Thanks alot for your quick response.
>>
>> These notes are very usefull.As you see that these patches
are not
>> responsible for the problem I have in instconf,drv problem as
you see
in the
>> log file. So what do u think for the main reasons for that?
>>
>> Is it cleaning the source server from previous clone?? can
solve this
>> issue I have.
>> Also I never did this cleaning before ,If so plz tell me step
by step
how
>> to clean it , coz I have little conflicts at the note:
364565.1 which
>> explain it.
>>
>> I am following this steps as u see. & plz answer these
questions.
>> On the DB Tier:-
>>
>> Rename RDBMS $ORACLE_HOME/appsutil to
$ORACLE_HOME/appsutil_old (OK
no
>> problem)
>> On the Apps Tier, run "perl $AD_TOP/bin/admkappsutil.pl"
(Ok)
>> Copy the appsutil.zip to the RDBMS $ORACLE_HOME and unzip
>>
>> (where is this file & where to copy it ??)
>>
>> Copy the Context file from RDBMS $ORACLE_HOME/appsutil_old to
the new
>> $ORACLE_HOME/appsutil (OK)
>>
>>
>>
>> Run AutoConfig on the DB Tier (OK)
>> Do the "Prepare Source system" steps i.e "perl
adpreclone.pl dbTier" (OK)
>>
>> On the Apps Tier:-
>>
>> Rename $COMMON_TOP/clone to $COMMON_TOP/clone_old (OK)
>> Rename 8.0.6 $ORACLE_HOME/appsutil to
$ORACLE_HOME/appsutil_old (ok)
>> Rename iAS $ORACLE_HOME/appsutil to $ORACLE_HOME/appsutil_old
(ok)
>> Do the "Prepare Source system" steps i.e "perl
adpreclone.pl appsTier"
>> (ok)
>>
>>
>> Do you think that this cleaning will solve the problem I have
instead
of
>> Applying AD.I.2 and TX.K , coz I think that these patches for
keeping
me up
>> to date level but not specific to my problem.I will apply all
your
mentioned
>> patches later.
>>
>> Ok waiting ur reply.
>>
>> Thanks alot.
>> Regards,
>> Mostafa
>>
>> --- On Thu, 1/15/09, James Morrow <morrow.james@xxxxxxxxx>
wrote:
>>
>> From: James Morrow <morrow.james@xxxxxxxxx>
>> Subject: Re: ADCFGCLONE.PL at DB always fail-- LOG FILE
Attached
>> To: ora-apps-dba@xxxxxxxxxxxxx
>> Date: Thursday, January 15, 2009, 2:16 PM
>>
>> You'll find these notes useful:
>>
>> 230672.1 Cloning Oracle Applications Release 11i with Rapid
Clone
>> 216664.1 FAQ: Cloning Oracle Applications Release 11i
>>
>> These will also be helpful:
>>
>> 165195.1 Using AutoConfig to Manage System Configurations
with Oracle
>> Applications 11i
>>
>>
>> In order to re-build the appsutil directory, look at note
165195.1 and
>> follow the instructions under "Copy AutoConfig to the RDBMS
>> ORACLE_HOME". That step generally needs to be performed
after
you
>> apply AD, ATG, or TXK patchsets to your APPL_TOP.
>>
>> Since you're on 11.5.10.2, you should already be
AutoConfig-enabled
>> and, barring configuration issues, able to perform a
successful clone
>> without needing to apply any additional patches.
>>
>> Even though they shouldn't be required to solve this
particular
>> problem, I generally recommend that customers start applying
the
>> following as quickly as may be convienent:
>>
>> ATG_PF.H.RUP6
>> AD.I.6
>> TXK.S
>> CPUJan2009 (And all earlier E-Business CPU's [EBS ones
aren't
>> cumulative])
>> RDBMS 10.2.0.4 (I believe 9i has been de-supported).
>> Sun JRE (Instead of JInitiator)
>> Sun Java 1.6 (Server-side)
>>
>> -- James
>>
----------------------------------------------------------------------
>> James J. Morrow | Senior Oracle Applications DBA
>> morrow.james <at> gmail <dot> com
>>
>>
>>
>>
>> On Thu, Jan 15, 2009 at 12:29 PM, Mostafa Eletriby
<m_etrib@xxxxxxxxx>
>> wrote:
>> > Hi James,
>> >
>> > please tell me the detailed steps for using admkappsutil at
source node
>> & an
>> > oracle note too for this use.
>> >
>> > Also I would like to know if I should apply the patch of
TX.K
latest
>> > Autoconfig Rollup S
>> > P# 165195.1
>> > and
>> > the patch for updating AD Administration to AD.I.6
P#6502082 at
source
>> > instance in order to complete the post clone successfully
at
Target too?
>> >
>> > This is an important question for me :)
>> >
>> > I am currently running at AD.I.4 and TKX.M apps 11.5.10.2
Database
>> 9.2.0.8
>> >
>> > & remember the preclone always complete sucessfully.
>> >
>> > Thanks
>> > Regards,
>> >
>> >
>> > --- On Thu, 1/15/09, James Morrow <morrow.james@xxxxxxxxx>
wrote:
>> >
>> > From: James Morrow <morrow.james@xxxxxxxxx>
>> > Subject: Re: ADCFGCLONE.PL at DB always fail-- LOG FILE
Attached
>> > To: ora-apps-dba@xxxxxxxxxxxxx
>> > Date: Thursday, January 15, 2009, 12:32 PM
>> >
>> > Consider:
>> >
>> > 1) Rebuild the appsutil directory (using admkappsutil, per
the
>> > instructions in the cloning document)
>> > 2) Re-do your preclone steps in the source
>> > 3) Copy over the appsutil from the source
>> > 4) Try the post-clone again.
>> >
>> > -- James
>> >
----------------------------------------------------------------------
>> > James J. Morrow | Senior Oracle Applications DBA
>> > morrow.james <at> gmail <dot> com
>> >
>> >
>> >
>> >
>> > On Thu, Jan 15, 2009 at 11:29 AM, Mostafa Eletriby
>> <m_etrib@xxxxxxxxx>
>> > wrote:
>> >>
>> >> Hi Vikram,
>> >>
>> >> I copied all oracle Home sucessfully , There is no problem
in
copying.
>> >> Also this problem is always repeated from this source
instance.
>> >> The preclone of Database always complete sucessfully.
>> >>
>> >> The log file of Preclone of Database is attached.
>> >> The workaround I make to pass this problem is to remove
the
referred
>> error
>> >> lines from the driver.
>> >>
>> >>
>> >> Please advice me.
>> >> Thanks
>> >> Regards,
>> >>
>> >>
>> >> --- On Thu, 1/15/09, Vikram <vikramsingh120@xxxxxxxxx>
wrote:
>> >>
>> >> From: Vikram <vikramsingh120@xxxxxxxxx>
>> >> Subject: Re: ADCFGCLONE.PL at DB always fail
>> >> To: ora-apps-dba@xxxxxxxxxxxxx
>> >> Date: Thursday, January 15, 2009, 11:31 AM
>> >>
>> >> Hello Mostafa,
>> >>
>> >> I will go with the assumption that you are copying your
Oracle_Home
>> too
>> > from
>> >> source to target. Since you say adpreclone ran
successfully,
this is
>> > really
>> >> strange that it is reporting the files from the same
Oracle_Home
>> missing
>> >> where it has compiled the instconf.drv file from. Can you
upload the
>> >> adpreclone.pl log file from source too? Let's begin at
the
>> beginning!
>> >> Looks like this is a regular issue with your instance. Is
this error
>> >> occurring with any other clone of instance from the same
source? Or is
>> > this
>> >> error only with the clone of this instance? What
workaround
have you
>> been
>> >> using so far to overcome this?
>> >>
>> >> -Vikram
>> >>
>> >> On Thu, Jan 15, 2009 at 10:29 AM, Mostafa Eletriby
>> > <m_etrib@xxxxxxxxx>
>> >> wrote:
>> >>>
>> >>> Hi DBA,
>> >>>
>> >>> If Anyone can solve with me this issue about
ADCFGCLONE.PL that
>> > always
>> >>> fail.
>> >>>
>> >>> Regards,
>> >>> Mostafa
>> >>>
>> >>> --- On Wed, 1/14/09, Mostafa Eletriby
<m_etrib@xxxxxxxxx>
>> wrote:
>> >>>
>> >>> From: Mostafa Eletriby <m_etrib@xxxxxxxxx>
>> >>> Subject: RE: ADCFGCLONE.PL at DB always fail
>> >>> To: ora-apps-dba@xxxxxxxxxxxxx
>> >>> Date: Wednesday, January 14, 2009, 6:38 AM
>> >>>
>> >>> Hi DBAs,
>> >>>
>> >>> Hi Mamta, Thanks for this useful note that clarify the
cause of
>> > problem.
>> >>>
>> >>> Actually The preclone ran successfully.
>> >>>
>> >>> I would like to solve this problem of Post Clone
permanetly
>> instead of
>> >>> this workround to remove the lines of files reffrefed in
the
>> > inistconf.drv
>> >>> of DB which has errors in the log file. As This problem
always
>> > repeated at
>> >>> Post Clone of the same PROD instance.
>> >>>
>> >>> I would like to know if I should rename & move some
files
>> &
>> > folders at the
>> >>> source instance like (appsutil) to clean the source from
Previous
>> > clone Or I
>> >>> leave all these files as they are?
>> >>>
>> >>> This issue is highly recomeneded by oracle as shown in
the NoteID:
>> >>> 364565.1
>> >>> Section 2. Preparing Source System
>> >>>
>> >>> But I didnt ever do it before , I would like to know if
it is
>> > mandatory
>> >>> for cloning ? or at least to solve my issue permately ?
>> >>>
>> >>> I have little conflicts about this cleaning if it is the
reason
>> &
>> > how to
>> >>> do it.
>> >>>
>> >>> We are running apps 11.5.10.2 upgraded to Database
9.2.0.8
>> >>>
>> >>> Please advice me :)
>> >>>
>> >>> Regards,
>> >>> Mostafa
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> --- On Tue, 1/13/09, NEELI-SC, Mamta
>> > <Mamta.NEELI@xxxxxxxxxxxxxx> wrote:
>> >>>
>> >>> From: NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx>
>> >>> Subject: RE: ADCFGCLONE.PL at DB always fail
>> >>> To: ora-apps-dba@xxxxxxxxxxxxx
>> >>> Date: Tuesday, January 13, 2009, 4:34 AM
>> >>>
>> >>> Hi Mostafa,
>> >>>
>> >>>
>> >>> Please try to follow the document 307954.1 might be
helpful for
>> you.
>> >>>
>> >>> Regards
>> >>> Mamta
>> >>>
>> >>> ________________________________
>> >>> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
>> >>> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
Mostafa
>> > Eletriby
>> >>> Sent: Tuesday, 13 January 2009 16:05
>> >>> To: ora-apps-dba@xxxxxxxxxxxxx
>> >>> Subject: ADCFGCLONE.PL at DB always fail
>> >>>
>> >>> DBAs,
>> >>>
>> >>> I have a problem in running adcgfclone.pl of Database at
Target
>> > instance
>> >>> at Post clone phase.
>> >>>
>> >>> I always face this problem This problem always repeated
at the
>> same
>> >>> instance which shows errors in instconf.drv at Database.
>> >>>
>> >>> I attached the log file of the problem.
>> >>>
>> >>> Please advice me.
>> >>>
>> >>> Regards,
>> >>> Mostafa
>> >>>
>> >>>
>> >>
>> >>
>> >>
>> >
>> >
>> >
>>
>>
>
>
>
>
Other related posts: