Home » Other » General » Upgrade from 9i single instance to 11g RAC (Linux, Oracle 9i to 11g )
Upgrade from 9i single instance to 11g RAC [message #671548] Wed, 05 September 2018 10:27 Go to next message
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 ?
Re: Upgrade from 9i single instance to 11g RAC [message #671549 is a reply to message #671548] Wed, 05 September 2018 10:53 Go to previous messageGo to next message
John Watson
Messages: 8922
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.

Re: Upgrade from 9i single instance to 11g RAC [message #671550 is a reply to message #671549] Wed, 05 September 2018 11:59 Go to previous messageGo to next message
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


Re: Upgrade from 9i single instance to 11g RAC [message #671551 is a reply to message #671550] Wed, 05 September 2018 12:28 Go to previous messageGo to next message
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 Go to previous message
John Watson
Messages: 8922
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
Previous Topic: Jpublisher giving error for publish table
Next Topic: Basic question
Goto Forum:
  


Current Time: Thu Mar 28 13:54:53 CDT 2024