RE: ADCFGCLONE.PL at DB fail

Thanks Mostafa..

 

So each time you have to do import and export of the tablespace :-(

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Mostafa Eletriby
Sent: Thursday, 7 May 2009 02:17
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: ADCFGCLONE.PL at DB fail

 

Hi Mamta ,

 

How are you?

 

You are welcome

 

Yes this problem was since 4 months and solved.

 

When I was trying to perform post clone phase it always see the entry of
this corrupted datafile and It is not prersent although I run the
utility of makappsutil.pl which creates the stage area again and clone
folder , and the conf.drv  and performing preclone again but it still
see that missed corrupted datafile that was unpresent.. so I had to
export and import the tablespace through exporting the used datafiles
and dropping all the old tablespace including that datafile then
creating again the same tablespace by the same name and creating the
apporpriate datafiles then importing the tablespace with privilege from
the dump file I had.

 

So the entries are clean and I performed the postclone phase with no
problems in the entry of that bad datafile that was created by fault.

 

that problem always happen in R 9i because I couldnt drop any datafile
separetly from certain tablespace So I had to drop the whole TS.

But in 10G I can drop any datafile separetly from any tablespace.

 

If you have any concerns tell me.

 

Regards,

 

--- On Wed, 5/6/09, NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx> wrote:

        
        From: NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx>
        Subject: RE: ADCFGCLONE.PL at DB fail
        To: ora-apps-dba@xxxxxxxxxxxxx
        Date: Wednesday, May 6, 2009, 3:05 AM

        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: