| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Applications Development Database Refresh
Thanks, April, John Kanagaraj & John Weatherman, I will look thru' all the
papers before I migrate my Oracle Apps 11I from E450 to Sun Fire 6800.
Thanks so much for your help.
Regds,
Catherine
-----Original Message----- From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com] Sent: Wednesday, July 10, 2002 1:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development DatabaseRefresh
Hi all,
Looks like we have a fair bunch of Oracle Apps DBAs on this list! The issues
of cloning for 10.7 (various flavors), 11 and 11i are quiet different from
each other. This is mostly because the underlying technical architecture has
changed between each of these versions. Have a look at the following link
for a collection of the most comprehensive papers on this subject.
http://www.dbatoolbox.com/Content/cloning_wp.htm
11i cloning can be done 'officially' using the adclone utility, but this is
cumbersome. Unofficially, there are a variety of methods that are addressed
in these links.
Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients **Mailing Lists
> -----Original Message-----
> From: April Wells [mailto:awells_at_csedge.com]
> Sent: Tuesday, July 09, 2002 6:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Applications Development Database
Refresh
>
>
> Be careful who you get when you open the tar... there is
one
> chick in Denver
> who INSISTS on repeatedly reading you the whitepaper over
the
> phone, and
> INSISTS that bad things CAN'T happen in a clone (they
can...
> I have had two
> failed clones... one I believed them and manually fixed
every
> file and it
> took a month to get it repaired... the other I did not
believe them,
> restored and fixed it in two days). There is a white
paper
> on Metalink that
> will walk you through it.. but make sure you have a good
> backup before you
> start. It is very straight forward and very step by step,
> but it can still
> fail. You do not have to do a fresh install before each
> clone, don't let
> anyone tell you different. You have to do ONE install on
the
> target system.
> The procedure for 11i is (from what I understand) much
easier
> than for 10.7.
>
> April Wells
> Oracle DBA (Oracle OCP 8, 8i)
> Corporate Systems
> Amarillo Texas
>
> -----Original Message-----
> Sent: Tuesday, July 09, 2002 7:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> You will want to open a TAR on this. There is a lengthly
> procedure document
> that Oracle will provide for doing an Apps Clone on 11i.
> There are issues
> with just duplicating the executables and database. I got
> out of Apps on
> 10.7, but remember that a doc was being written by Oracle
as
> of the 2001
> Open World for 11i.
>
> HtH,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -----Original Message-----
> Sent: Monday, July 08, 2002 11:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If anyone has refreshed the Dev database from the
Production
> database Oracle
> HRMS 11/11I successful, please tell me how to do it ?
Thanks.
>
> Regds,
> New Bee
> -----Original Message-----
> From: Scott.Shafer_at_dcpds.cpms.osd.mil
> [mailto:Scott.Shafer_at_dcpds.cpms.osd.mil]
> Sent: Tuesday, July 09, 2002 6:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Applications
> Development Database
> Refresh
>
> My apps person tells me that they just
restore
> the db and
> the applmgr stuff
> works fine with 10.7. Its sloppier than
restoring the
> appl_top as well, but
> works. 11/11i being an entirely different
animal.
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com
> [SMTP:Jared.Still_at_radisys.com]
> > Sent: Monday, July 08, 2002 5:06 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Oracle Applications
> Development Database
> Refresh
> >
> > Thanks Scott, but the applmgr stuff is
where
> the details
> are.
> >
> >
> >
> >
> >
> >
> > Scott.Shafer_at_dcpds.cpms.osd.mil
> > Sent by: root_at_fatcity.com
> > 07/08/2002 11:23 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of
list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: Oracle
Applications
> Development Database
> > Refresh
> >
> >
> > Jared, we do that here, but just:
> > take a cold backup of the production db,
> > lay it down over the old dev db (via scp
or tape),
> > and open it renaming with a backup
> cpontrolfile script.
> >
> > Works like a charm, though I'm not sure
what
> applmgr steps
> are required.
> >
> > Scott Shafer
> > San Antonio, TX
> > 210-581-6217
> >
> >
> > > -----Original Message-----
> > > From: Jared.Still_at_radisys.com
> [SMTP:Jared.Still_at_radisys.com]
> > > Sent: Friday, July 05, 2002
5:43 PM
> > > To: Multiple recipients of
list ORACLE-L
> > > Subject: Oracle
Applications
> Development
> Database Refresh
> > >
> > > Fellow listers,
> > >
> > > In addition to the usual SAP system that
> runs most of
> our company, we
> > have
> > > Oracle Apps 10.7 HR. For some reason
the HR folks
> didn't like the SAP
> > HR
> > > module, so I have SAP and Oracle Apps.
> > >
> > > The problem is a request I have to
refresh the Dev
> database from the
> > > Production database.
> > >
> > > If you can point me to the correct
documentation for
> this, I'll take a
> > > look at it.
> > >
> > > There's a lot of stuff to wade through
in
> the docs and
> MetaLink, and I'd
> >
> >
> > > rather just
> > > read documentation that's actually
relevant.
> > >
> > > Thanks,
> > >
> > > Jared
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.com
> > >
> > > Fat City Network Services -- (858)
538-5051 FAX:
> (858) 538-5051
> > > San Diego, California -- Public
> Internet access /
> Mailing Lists
> > >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing
list, send an
> E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT
spelling of
> 'ListGuru') and in
> > > the message BODY, include a line
containing: UNSUB
> ORACLE-L
> > > (or the name of mailing list you want to
be removed
> from). You may
> > > also send the HELP command for other
> information (like
> subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> > INET: Scott.Shafer_at_dcpds.cpms.osd.mil
> >
> > Fat City Network Services -- (858)
> 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public
> Internet access /
> Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list,
> send an E-Mail
> message
> > to: ListGuru_at_fatcity.com (note EXACT
spelling of
> 'ListGuru') and in
> > the message BODY, include a line
containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to
be
> removed from).
> You may
> > also send the HELP command for other
information (like
> subscribing).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- (858)
> 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public
> Internet access /
> Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list,
> send an E-Mail
> message
> > to: ListGuru_at_fatcity.com (note EXACT
spelling of
> 'ListGuru') and in
> > the message BODY, include a line
containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to
be
> removed from).
> You may
> > also send the HELP command for other
information (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Scott.Shafer_at_dcpds.cpms.osd.mil
>
> Fat City Network Services -- (858)
538-5051
> FAX: (858)
> 538-5051
> San Diego, California -- Public
Internet access /
> Mailing Lists
>
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list,
send
> an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT
spelling
> of 'ListGuru')
> and in
> the message BODY, include a line containing:
> UNSUB ORACLE-L
> (or the name of mailing list you want to be
> removed from).
> You may
> also send the HELP command for other
information (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /
Mailing Lists > --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ORACLE-L
> (or the name of mailing list you want to be removed from).
You may
> also send the HELP command for other information (like
subscribing).
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: John Weatherman
> INET: john.weatherman_at_replacements.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /
Mailing Lists > --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ORACLE-L
> (or the name of mailing list you want to be removed from).
You may
> also send the HELP command for other information (like
subscribing).
>
>
> begin 666 InterScan_Disclaimer.txt
> M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S > M=')I8W1L>2!C;VYF:61E;G1I86P_at_86YD(&9O<B!T:&4@:6YT96YD960@=7-E > M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL > M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@ > M:7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L;W-U<F4L('5S92!O<B!C > M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA > M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960_at_86YD(&UA
> M>2!B92!I;&QE9V%L+B
@268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S > M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I > M871E;'D_at_8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) > M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ > M96YS=7)E('1H870_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S > M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL > M:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S > M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R > M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE
> %;G0N#0H
> end
>
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: April Wells
> INET: awells_at_csedge.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> San Diego, California -- Public Internet access /
Mailing Lists > --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ORACLE-L
> (or the name of mailing list you want to be removed from).
You may
> also send the HELP command for other information (like
subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access /
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (likesubscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jul 09 2002 - 21:18:20 CDT
 |
 |