OraFAQ Forum: General » Upgrade from 9i single instance to 11g RAC

Home » Other » General » Upgrade from 9i single instance to 11g RAC (Linux, Oracle 9i to 11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrade from 9i single instance to 11g RAC [message #671548]

Wed, 05 September 2018 10:27

ygpp
Messages: 2
Registered: September 2018

Junior Member

I want to upgrade from Oracle 9i single instance(simple with no cluster environment) to 11g RAC.
Which is the best way to upgrade ?
Is it possible to upgrade directly from 9i one instance to 11g RAC ?
Or should I follow the path
Upgrade 9i single instance to 11g single instance. Then migrate 11g single instance to 11g RAC as they are on the same version.
or any other best solution ?

Also, can I run Fusion Middleware 12c pointing to database 11g ?

Report message to a moderator

Re: Upgrade from 9i single instance to 11g RAC [message #671549 is a reply to message #671548]

Wed, 05 September 2018 10:53

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

This is a huge topic, and there must be more to it. For example, I would think that you will be changing hardware and operating system too.
It may be beyond the scope of a forum to ask for advice on this (you may need to hire a consultant) but if you can describe the project in full, including description of the source and target environments, perhaps it will be possible to assist.

Report message to a moderator

Re: Upgrade from 9i single instance to 11g RAC [message #671550 is a reply to message #671549]

Wed, 05 September 2018 11:59

ygpp
Messages: 2
Registered: September 2018

Junior Member

Thanks for the response.
There are 2 upgrades in our customers site both needed upgrade 9i single instance to 11g RAC.
There is replication between 2 environments using goldengate
First one:
Source - OS : HP-UX , Forms 6i
Target - OS:Linux(RHEL), Fusion Middleware

Second one :
Source - OS : Windows 2000, Forms 6i
Target - OS : Linux(RHEL), Fusion Middleware

Report message to a moderator

Re: Upgrade from 9i single instance to 11g RAC [message #671551 is a reply to message #671550]

Wed, 05 September 2018 12:28

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Fusion Middleware 12c will require a minimum database version requirement of 11.2.0.4 for the repository, but Forms 12c can connect to any version 11g database.

[Updated on: Wed, 05 September 2018 12:29]

Report message to a moderator

Re: Upgrade from 9i single instance to 11g RAC [message #671552 is a reply to message #671550]

Wed, 05 September 2018 12:58

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

ygpp wrote on Wed, 05 September 2018 17:59

Thanks for the response.
There are 2 upgrades in our customers site both needed upgrade 9i single instance to 11g RAC.
There is replication between 2 environments using goldengate
First one:
Source - OS : HP-UX , Forms 6i
Target - OS:Linux(RHEL), Fusion Middleware

Second one :
Source - OS : Windows 2000, Forms 6i
Target - OS : Linux(RHEL), Fusion Middleware

Holy smoke. That is a big job. I really don't think that I can give any meaningful advice other than "hire a consultant who knows what he is doing". If the company I work for were doing this, we might put several people on it: a Shit-hot DBA (aka me) plus an ace developer type to sort out the application upgrades (6i to 12.x may be a big leap) plus an SA to deal with the OS and hardware hassles (you will have them) plus a PM to run the project and bring in extra resources (which will be needed). Are you sure that you are up to this?

ps - my boss would be happy to give you a quote Smile

Report message to a moderator

Previous Topic:	Jpublisher giving error for publish table
Next Topic:	Basic question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 21:42:46 CST 2024