Re: Migrating to 11g

Giganews Newsgroups
Subject: Re: Migrating to 11g
Posted by:  bdbafh (bdba…@gmail.com)
Date: Thu, 15 Nov 2007

On Nov 15, 8:51 am, mark_smith <bhuta.dars.…@gmail.com> wrote:
> Hey guys, We are on Oracle 9i and not sure if we will migrate to
> Oracle 11g.  I am wondering, if any of you folks have upgraded to
> Oracle 11G and if so why, or if you are still in the previous version,
> why so.  Also, wondering, if I am on Oracle 9i - how much incremental
> budget will i need to get approval for, if we migrate to Oracle 11g -
> assuming all other things being equal.

not 11g specific, but probably worth a read:

http://www.dbspecialists.com/presentations.html#case_study_10g

"An Oracle 10g Upgrade Case Study: Looking at System Performance
Before and After the Upgrade," by Roger Schrag (February 2005).

    * White paper (HTML)
    * Slide show (Microsoft PowerPoint)

Obligatory reference to the Oracle 11g R1 Database Server Upgrade
Guide:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28300.pdf

Depending upon what killer features in 11g you want to leverage vs.
level of risk that you're willing to assume, you might just decide to
upgrade to 10g R2 and hold off on migrating to 11g R1 until after
you've tested, submitted your bugfixes and awaited the availability of
the fixes in a patchset or one-off patch.

10.1.0.2 (base release) wasn't ready for me until after the 10.1.0.4
patchset (10 g R1 patchset2) was applied.

10.2.0.3 (10g R2 patchset 2) with the October Critical Patch Update is
working pretty well for me.

Maybe you'll get lucky with the 11.1.0.6 base release.
Quite a few bugs that are fixed in the upcoming 10.2.0.4 patchset are
also fixed in 11.1.0.6.

Check the known issues doc up on Metalink.
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=454507.1
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=454506.1

hth.

-bdbafh

Replies

None

In response to

Migrating to 11g posted by mark_smith on Thu, 15 Nov 2007