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 AMI suspect that a datafile was added to 
the source database in-betweensteps of your clone.  Here's what generally 
happens:  1)  When you run adpreclone.pl, it (essentially) does an 
"alterdatabase backup controlfile to trace" and stores the information fromthat 
in a file within ${ORACLE_HOME}/appsutil.  This represents all ofthe 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 informationfrom #1 above to try to generate a new controlfile.  In your 
case, since you had to rerun adpreclone.pl on your source, theinformation 
gathered in #1 represents the state of the source at thattime.  Your backup 
(your target) represents an earlier time (prior tothe addition of that 
datafile).  So, the "create controlfile" stepthat adcfgclone is doing is going 
to fail.  Simplest suggestion?  If you haven't
 applied ANY patches to the sourcedatabase since you started the cloning 
process, just take anotherbackup of the database and bring it over.  If you 
HAVE applied ANYpatches, you'll want to re-clone the whole thing.  -- 
James----------------------------------------------------------------------James
 J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLCmorrow.james 
<at> gmail <dot> comjames.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 followedthe> 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 thisextension> 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 seein 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 stephow>> 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   (OKno>> 
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 "perladpreclone.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 "perladpreclone.pl appsTier">> (ok)>>  >>  >> Do you 
think that this cleaning will solve the problem I have insteadof>> Applying 
AD.I.2 and TX.K , coz I think that these patches for keepingme up>> to date 
level but not specific to my problem.I will apply all yourmentioned>> 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 afteryou>> 
apply AD, ATG, or TXK patchsets to your APPL_TOP.>>  >> Since you're on 
11.5.10.2, you should already
 beAutoConfig-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 atsource 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 atsource>> > instance in order to complete 
the post clone successfully atTarget 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 incopying.>> >> Also 
this problem is always repeated from this sourceinstance.>> >> 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 thereferred>> 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 yourOracle_Home>> too>> > from>> >> source to target. Since you say 
adpreclone ran successfully,this is>> > really>> >> strange that it is 
reporting the files from the sameOracle_Home>> missing>> >> where it has 
compiled the instconf.drv file from. Can youupload the>> >> adpreclone.pl log 
file from source too? Let's begin atthe>> beginning!>> >> Looks like this is a 
regular issue with your instance. Isthis error>> >> occurring with any other 
clone of instance from the samesource? Or is>> > this>> >> error only with the 
clone of this instance? What workaroundhave 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 aboutADCFGCLONE.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 thecause of>> > problem.>> >>>>> >>> Actually The 
preclone ran successfully.>> >>>>> >>> I would like to solve this problem of 
Post Clonepermanetly>> instead of>> >>> this workround to remove the lines of 
files reffrefed inthe>> > inistconf.drv>> >>> of DB which has errors in the log 
file. As This problemalways>> > repeated at>> >>> Post Clone of the same PROD 
instance.>> >>>>> >>> I would
 like to know if I should rename & move somefiles>> &>> > folders at the>> >>> 
source instance like (appsutil) to clean the source fromPrevious>> > clone Or 
I>> >>> leave all these files as they are?>> >>>>> >>> This issue is highly 
recomeneded by oracle as shown inthe NoteID:>> >>> 364565.1>> >>> Section 2. 
Preparing Source System>> >>>>> >>> But I didnt ever do it before , I would 
like to know ifit is>> > mandatory>> >>> for cloning ? or at least to solve my 
issue permately ?>> >>>>> >>> I have little conflicts  about this cleaning if 
it is thereason>> &>> > how to>> >>> do it.>> >>>>> >>> We are running apps 
11.5.10.2  upgraded to Database9.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 behelpful for>> you.>> >>>>> >>> Regards>> >>> Mamta>> >>>>> >>> 
________________________________>> >>> From: 
ora-apps-dba-bounce@xxxxxxxxxxxxx>> >>> 
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf OfMostafa>> > 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 atTarget>> > instance>> >>> 
at Post clone phase.>> >>>>> >>> I always face this problem This problem always 
repeatedat 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: