Dear All,

This post maybe a little bit, but please continue to read it and kindly give
me some advise.

I am going to upgrade the Oracle eBusiness Suite from 11.5.4 to 11.5.9 on
IBM AIX.
I would like to ask for advise from you guys.

I heard from a DBA that he used to do the following
1. have a fresh installation of 11.5.9 on the target instance
2. copy the database (with prerequisite tasks completed) from the source
instance to the target instance,
3. start to apply the 11.5.9 maintenance pack on this database
4. complete the post-install tasks

This method has the following advantages
1. less download
2. less error
3. when anything goes wrong, you can switch back to the source instance
immediately

Now, I am going to follow his method to upgrade the Oracle Apps from 11.5.4
to 11.5.9.
And my plan is

1. I will follow the doc "Oracle Applications Release 11.5.9 Maintenance
Pack Installation Instructions" Section 1: Pre-Install Tasks to do the
prerequisite tasks on the source instance.

2. Since the source instance is already running 8.1.7.4, I will do nothing
to the database tier.

3. Since Oracle 9i is not certified on 11.5.4, I am going to do this on the
target instance to make both instances' database 8.1.7.4. On the target
instance, I will have a fresh installation of 11.5.9 with fresh database
(9.2.0.3). After the fresh installation completed, I will remove the 9.2.0.3
oracle software at /d1/oracle/proddb/9.2.0 and the datafiles at
/d1/oracle/proddata. Then I will manually install the 8.1.7.4 oracle
software at /d1/oracle/proddb/8.1.7.

4. I clone the source database to the target instance at
/d1/oracle/proddata, and start it with the 8.1.7.4 oracle software.

5. Then I will apply the 11.5.9 maintenance pack to this database.

6. Finally I will do the Post-Install Tasks.

7. Optionally, I will upgrade the database to 9.2.0.4.

Is this plan workable?
Can anyone give me some advise on the plan? or suggest me a better approach?
Thanks in advance for any input.

Best Regards,
Joe Yung

1. less download <-- should be "downtime"


"Joe" <yung103@netvigator.com> ¦b¶l¥ó
news:c7g12o$chm1@imsp212.netvigator.com ¤¤¼¶¼g...
> Dear All,
>
> This post maybe a little bit, but please continue to read it and kindly
give
> me some advise.
>
> I am going to upgrade the Oracle eBusiness Suite from 11.5.4 to 11.5.9 on
> IBM AIX.
> I would like to ask for advise from you guys.
>
> I heard from a DBA that he used to do the following
> 1. have a fresh installation of 11.5.9 on the target instance
> 2. copy the database (with prerequisite tasks completed) from the source
> instance to the target instance,
> 3. start to apply the 11.5.9 maintenance pack on this database
> 4. complete the post-install tasks
>
> This method has the following advantages
> 1. less download
> 2. less error
> 3. when anything goes wrong, you can switch back to the source instance
> immediately
>
> Now, I am going to follow his method to upgrade the Oracle Apps from
11.5.4
> to 11.5.9.
> And my plan is
>
> 1. I will follow the doc "Oracle Applications Release 11.5.9 Maintenance
> Pack Installation Instructions" Section 1: Pre-Install Tasks to do the
> prerequisite tasks on the source instance.
>
> 2. Since the source instance is already running 8.1.7.4, I will do nothing
> to the database tier.
>
> 3. Since Oracle 9i is not certified on 11.5.4, I am going to do this on
the
> target instance to make both instances' database 8.1.7.4. On the target
> instance, I will have a fresh installation of 11.5.9 with fresh database
> (9.2.0.3). After the fresh installation completed, I will remove the
9.2.0.3
> oracle software at /d1/oracle/proddb/9.2.0 and the datafiles at
> /d1/oracle/proddata. Then I will manually install the 8.1.7.4 oracle
> software at /d1/oracle/proddb/8.1.7.
>
> 4. I clone the source database to the target instance at
> /d1/oracle/proddata, and start it with the 8.1.7.4 oracle software.
>
> 5. Then I will apply the 11.5.9 maintenance pack to this database.
>
> 6. Finally I will do the Post-Install Tasks.
>
> 7. Optionally, I will upgrade the database to 9.2.0.4.
>
> Is this plan workable?
> Can anyone give me some advise on the plan? or suggest me a better
approach?
> Thanks in advance for any input.
>
> Best Regards,
> Joe Yung
>
>
>

When downtime is a critical issue, then yes, you should consider which tasks
you could move to before and after the downtime window, taking down the
system only for the crucial upgrade tasks.

Note that 11.5.9 consolidated update 2 is out since last december, so I
recommend you to apply this one as well - that way you can avoid lots of
bugs (and Oracle supports continous suggestions to upgrade to latest patch
levels in case of problems).

Due the complexity of Apps and the upgrade process, there is really lots
that you can do to shorten the downtime, I wont start listing them here, but
you can get a doc I wrote a year ago on the topic from
http://integrid.info/11idowntime.doc (it's 30 pages and covers the upgrade
process starting from planning issues up to database tweaking to get
additional performance).

Good luck!
Tanel.


"Joe" <yung103@netvigator.com> wrote in message
news:c7g12o$chm1@imsp212.netvigator.com...
> Dear All,
>
> This post maybe a little bit, but please continue to read it and kindly
give
> me some advise.
>
> I am going to upgrade the Oracle eBusiness Suite from 11.5.4 to 11.5.9 on
> IBM AIX.
> I would like to ask for advise from you guys.