Upgrade from Oracle 10.7 char to 11.5.8 HP-UX11.00

Rob,

Here we don't want to use SP mode. We are planning to migrate database and upgrade 10.7 application to 11.5.8 in one go. What is in my mind after having couple of responses that

1)create test environment on a separate machine with 10.7 application and 7.3.4.5 database. Just purge un needed data and correct storage param or increase sizes of tablespaces as per requirement.

2) Install 8.1.7.4 software and migrate database from 7.3.4.5 to 8.1.7.4(No I/O patches applied)

3)Install 11.5.8 application

4)Upgrade 10.7 application to 11.5.8

5)Apply any other mini/other patches.

6)Pass on to user for testing after checking env param etc.

I would like comments on this approach or experiences if anyone used that approach.

I am still waiting response/comments from Chad Nester and Khurush...

Regards
Rafiq

Reply-To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com> To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com> Date: Tue, 01 Apr 2003 20:18:57 -0500

Getting from 7.x to 8.1.7 for Apps 10.7 is a fairly well documented and safe process. The most difficult part might be finding to software versions you need to be in 10.7 SP mode if you choose to upgrade the RDBMS as a separate project before you migrate the Apps to 11i. The 8i migration utilities do most of the dirty work and do it well. We used ODMA for 10.7SC/SP and did it a few times before the production upgrade over a year ago.

Rob Quiles

M Rafiq wrote:
>
> Pat
>
> Thanks..
>
> 4) Export from Oracle7 import into Oracle8i
>
> We cannot export because of size of database but to copy and migrate to
> 8.1.7? Have you tried this path or have any experience good or bad?
>
> Regards
> Rafiq
>
> From: "Turner, Patricia" <TurnerPE_at_cdm.com>
> Reply-To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com>
> To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com>
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
> Date: Tue, 1 Apr 2003 17:16:23 -0500
>
> In a very compressed nutshell I did this:
>
> 1) Created a test 10.7 environment
> 2) Perform pre upgrade step (prepares Oracle 7 database)
> 3) Install new 11i software and create new Oracle8i instance
> 4) Export from Oracle7 import into Oracle8i
> 5) Upgrade using adaimgr
> 6) Install patches
>
> Be sure to keep track of every error and every step and every patch and
> every configuration and every profile, otherwise you will not get
> reproducible results. Documentation, project management and testing is
> critical to success. Read and reread all 11i upgrade documentation,
> installation guides, release notes and so BEFORE you begin.
>
> -----Original Message-----
> From: M Rafiq [mailto:rafiq9857_at_hotmail.com]
> Sent: Tuesday, April 01, 2003 4:56 PM
> To: OAUGNetDBA Listserv
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
>
> Pat,
>
> Thanks for reponse.
>
> "You also have the option of lumping both phases into one big step,
thereby
> skipping the IO patches all together. This was the strategy we used."
>
> Can you please explain your strategy for this? If you have any work paper
,
> I shall appreciate to share with(if possible)...
>
> Regards
> Rafiq
>
> From: "Turner, Patricia" <TurnerPE_at_cdm.com>
> Reply-To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com>
> To: "OAUGNetDBA Listserv" <OAUGNetDBA_at_oaug.com>
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
> Date: Tue, 1 Apr 2003 16:21:57 -0500
>
> Upgrading the database from Oracle7 to Oracle8i is optional if you want
to
> break up the project into two big chunks:
>
> Phase 1) Upgrade database and install IO patches
> Phase 2) Upgrade apps to 11i
>
> You also have the option of lumping both phases into one big step,
thereby
> skipping the IO patches all together. This was the strategy we used.
>
> -----Original Message-----
> From: Lynne Ly [mailto:linhlynne_at_yahoo.com]
> Sent: Tuesday, April 01, 2003 1:53 PM
> To: OAUGNetDBA Listserv
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
>
> We are on our third pilot testing from 10.7 character
> to 11.5.8.
>
> We had to upgrade to 8.1.6 a year ago so that we can
> upgrade to 11i. I don't think you can upgrade straight
> from 7.3.4 database without upgrading to 8i first.
> (you may want to check mettalink)
>
> When we upgradd to 8.1.6 we had to apply a lot of
> interopterability patches. We then upgraded to
> 8.1.7.3 a few months ago.
>
> Once we were on 8.1.7.3 and 8k blocksize we followed
> the release notes and upgrade manual. 11.5.8 is not
> too bad, a lot problems that we encountered in 11.5.7
> was fixed in 11.5.8. We started our first upgrade n
> 11.5.7.
>
> We are going live in a couple of months.
>
> Hope this helps.
>
> --- M Rafiq <rafiq9857_at_hotmail.com> wrote:
> >
> > Hello Gurus
> >
> > We are in process of planning to upgrade our
> > existing Oracle Financials 10.7
> > Character Applications to 11i( ver 11.5.8)
> >
> > Existing env
> >
> > HP-UX 11.00 32bits
> > Oracle Financials 10.7 Char
> > with Manufacturing & Bill of Material
> > Some customization (of Forms & Reports)
> > No middle tier
> > Database 7.3.4.5
> > Existing Database size is 70G(We don't expect
> > migration as export)
> >
> > Planning for
> > HP-UX 11.0 32 bits (same platform)
> > Oracle Financials 11i(11.5.8)
> > with Manufacturing & Bill of Material
> > Customization upgrade to Forms6i and Report 6i
> > Database 8.1.7.4
> >
> > What shall be the best path for this upgrade. I
> > would like some personal
> > experiences / guidance or pointer to some white
> > papers (besides Metalink).
> > At this stage we are putting some high level plan
> > for management information
> > and their approval.
> >
> > Regards
> > Rafiq
> >
> >
> >
> >
> >
> >
> _________________________________________________________________
> > The new MSN 8: advanced junk mail protection and 2
> > months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> >
> >
> #############################################################
> > This message is sent to you because you are
> > subscribed to the mailing list
> > <OAUGNetDBA_at_oaug.com>.
> > To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> > To switch to the FEED mode, send any message to
> > <OAUGNetDBA-feed_at_oaug.com>
> > To switch to the DIGEST mode, E-mail to
> > <OAUGNetDBA-digest_at_oaug.com>
> > To switch to the INDEX mode, E-mail to
> > <OAUGNetDBA-index_at_oaug.com>
> > Send administrative queries to
> > <OAUGNetDBA-request_at_oaug.com>
> >
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://platinum.yahoo.com
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list
> <OAUGNetDBA_at_oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed_at_oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
> Send administrative queries to <OAUGNetDBA-request_at_oaug.com>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list
> <OAUGNetDBA_at_oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed_at_oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
> Send administrative queries to <OAUGNetDBA-request_at_oaug.com>
>
> _________________________________________________________________
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list
> <OAUGNetDBA_at_oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed_at_oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
> Send administrative queries to <OAUGNetDBA-request_at_oaug.com>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list
> <OAUGNetDBA_at_oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed_at_oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
> Send administrative queries to <OAUGNetDBA-request_at_oaug.com>
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing
list <OAUGNetDBA_at_oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
> To switch to the FEED mode, send any message to
<OAUGNetDBA-feed_at_oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
> Send administrative queries to <OAUGNetDBA-request_at_oaug.com>

--
Rob Quiles                                              919-573-3704
Oracle DBA                                          roquiles_at_gpi.com
Financial Systems
General Parts, Inc.

#############################################################
This message is sent to you because you are subscribed to the mailing list 
<OAUGNetDBA_at_oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off_at_oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed_at_oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest_at_oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index_at_oaug.com>
Send administrative queries to  <OAUGNetDBA-request_at_oaug.c

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).