dbTalk Databases Forums  

Upgrade 9.2.0.8 --> 11.2.0.2

comp.databases.oracle.server comp.databases.oracle.server


Discuss Upgrade 9.2.0.8 --> 11.2.0.2 in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mladen Gogala
 
Posts: n/a

Default Upgrade 9.2.0.8 --> 11.2.0.2 - 08-06-2011 , 03:53 PM






The first production database in my company is just being upgraded from
9.2.0.8 to 11.2.0.2. It's a RAC, running on RH AS 2.1 (32bit) and OCFS,
being moved to RH 4.8, with OCFS2, RAC. That's the 1st step. The second
step will be to create a standby on 2 64bit nodes running RH 5.6 or RH
6.0, with ASM and get rid of that pesky OCFS and 32 bit OS. All of that
will be accomplished with 5 hours of downtime altogether. We're changing
OS version, DB version, architecture and SAN in the same migration. This
type of projects is why I love being a DBA.



--
http://mgogala.byethost5.com

Reply With Quote
  #2  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-06-2011 , 07:07 PM






On Sat, 06 Aug 2011 20:53:14 +0000, Mladen Gogala wrote:

Quote:
The first production database in my company is just being upgraded from
9.2.0.8 to 11.2.0.2. It's a RAC, running on RH AS 2.1 (32bit) and OCFS,
being moved to RH 4.8, with OCFS2, RAC. That's the 1st step. The second
step will be to create a standby on 2 64bit nodes running RH 5.6 or RH
6.0, with ASM and get rid of that pesky OCFS and 32 bit OS. All of that
will be accomplished with 5 hours of downtime altogether. We're changing
OS version, DB version, architecture and SAN in the same migration. This
type of projects is why I love being a DBA.
First step complete. All is well so far.



--
http://mgogala.byethost5.com

Reply With Quote
  #3  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-06-2011 , 11:27 PM



On Sun, 07 Aug 2011 00:07:13 +0000, Mladen Gogala wrote:

Quote:
On Sat, 06 Aug 2011 20:53:14 +0000, Mladen Gogala wrote:

The first production database in my company is just being upgraded from
9.2.0.8 to 11.2.0.2. It's a RAC, running on RH AS 2.1 (32bit) and OCFS,
being moved to RH 4.8, with OCFS2, RAC. That's the 1st step. The second
step will be to create a standby on 2 64bit nodes running RH 5.6 or RH
6.0, with ASM and get rid of that pesky OCFS and 32 bit OS. All of that
will be accomplished with 5 hours of downtime altogether. We're
changing OS version, DB version, architecture and SAN in the same
migration. This type of projects is why I love being a DBA.

First step complete. All is well so far.
HTMLDB doesn't work if there is no SCAN listener. I don't want SCAN, I
will have to cheat. fortunately, there is Apex listener. Oracle is
procreating more and more requirements for RAC. This thing SCAN is
useless and annoying as hell.



--
http://mgogala.byethost5.com

Reply With Quote
  #4  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-08-2011 , 07:01 PM



On Sun, 07 Aug 2011 00:07:13 +0000, Mladen Gogala wrote:


Quote:
First step complete. All is well so far.

Also, NetBackup 6.5 doesn't support Oracle 11.2. We needed to upgrade
backup software, too.



--
http://mgogala.byethost5.com

Reply With Quote
  #5  
Old   
John Hurley
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-10-2011 , 06:58 AM



Mladen:

# The first production database in my company is just being upgraded
from 9.2.0.8 to 11.2.0.2.

....

Good luck and have fun!

We are working on a 11.2 migration also ... starting to work on
getting ducks lined up.

No RAC here at all ... I ditched all that a while back. Like Moans
says "you probably don't need RAC" ...

We are going to be using ASM though which requires a separate grid
home from the oracle home. Just completed first setup testing on a
test machine of getting it all configured.

Putting the GI PSU 11.2.0.2.3 ( patchset update ) onto both homes is
also interesting.

Just because there is a 40 page README ( maybe more pages did not
count ) for the GI PSU ... you would not expect them to actually
document how to approach a standalone server would you now?

Some things like crsctl do not apparently work in a non clustered
configuration even though the doc tells you to run them ... nice eh?
So you get to fudge your way around *** Aka crsctl stop crs gives
CRS-4013: This command is not supported in a single-node
configuration. Of course one could open an SR with Oracle support so
that they could tell you to follow the README for the GI PSU. Oops
that's a closed infinite loop eh?

Reply With Quote
  #6  
Old   
Robert Klemme
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-10-2011 , 11:15 AM



On 10.08.2011 13:58, John Hurley wrote:
Quote:
Mladen:

# The first production database in my company is just being upgraded
from 9.2.0.8 to 11.2.0.2.

...

Good luck and have fun!

We are working on a 11.2 migration also ... starting to work on
getting ducks lined up.

No RAC here at all ... I ditched all that a while back. Like Moans
says "you probably don't need RAC" ...

We are going to be using ASM though which requires a separate grid
home from the oracle home. Just completed first setup testing on a
test machine of getting it all configured.

Putting the GI PSU 11.2.0.2.3 ( patchset update ) onto both homes is
also interesting.

Just because there is a 40 page README ( maybe more pages did not
count ) for the GI PSU ... you would not expect them to actually
document how to approach a standalone server would you now?

Some things like crsctl do not apparently work in a non clustered
configuration even though the doc tells you to run them ... nice eh?
So you get to fudge your way around *** Aka crsctl stop crs gives
CRS-4013: This command is not supported in a single-node
configuration. Of course one could open an SR with Oracle support so
that they could tell you to follow the README for the GI PSU. Oops
that's a closed infinite loop eh?
That sounds scary. I wonder how Oracle's sales people justify the price
tags that they are holding up with stories like these in the wild - err
- public. Thanks for sharing!

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Reply With Quote
  #7  
Old   
joel garry
 
Posts: n/a

Default Re: Upgrade 9.2.0.8 --> 11.2.0.2 - 08-10-2011 , 03:37 PM



On Aug 10, 9:15*am, Robert Klemme <shortcut... (AT) googlemail (DOT) com> wrote:
Quote:
On 10.08.2011 13:58, John Hurley wrote:



Mladen:

# The first production database in my company is just being upgraded
from 9.2.0.8 to 11.2.0.2.

...

Good luck and have fun!

We are working on a 11.2 migration also ... starting to work on
getting ducks lined up.

No RAC here at all ... I ditched all that a while back. *Like Moans
says "you probably don't need RAC" ...

We are going to be using ASM though which requires a separate grid
home from the oracle home. *Just completed first setup testing on a
test machine of getting it all configured.

Putting the GI PSU 11.2.0.2.3 ( patchset update ) onto both homes is
also interesting.

Just because there is a 40 page README ( maybe more pages did not
count ) for the GI PSU ... you would not expect them to actually
document how to approach a standalone server would you now?

Some things like crsctl do not apparently work in a non clustered
configuration even though the doc tells you to run them ... nice eh?
So you get to fudge your way around *** Aka crsctl stop crs gives
CRS-4013: This command is not supported in a single-node
configuration. *Of course one could open an SR with Oracle support so
that they could tell you to follow the README for the GI PSU. *Oops
that's a closed infinite loop eh?

That sounds scary. *I wonder how Oracle's sales people justify the price
tags that they are holding up with stories like these in the wild - err
- public. *Thanks for sharing!
Direct attention away from question by selling consulting services, of
course.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...rena-gonzalez/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.