We help IT Professionals succeed at work.

Plan to move Oracle db from Sun SParc to Linux

COMPSUPP
COMPSUPP asked
on
504 Views
Last Modified: 2013-12-19
I have a 9.2.0.5 live db on a Sunfire v440. Ultimately I need to get this to 10g but I view this as something that will take quite some time planning and testing. In the meantime I would like to put this db onto a Linux machine. BUT
I find that the minimum version of Oracle on a x86x64 Linux server is 9.2.0.7.
I have access to a Linux x86 server.
Should I install 9.2.0.4 Oracle onto the x86 , patch to 9.2.0.5 , put the db onto this, then patch to 9.2.0.7. Then I can move it to the x86x64 machine.
or is there a better less complicated route that  I might be able to follow?
Any advice gladly accepted.


Comment
Watch Question

David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
IMHO it depends upon your resouces and timetable.  You are, after all, working with deprecated versions.  If you have a business case to migrate from Sun to LINUX at the 9i level, then the 10g question seems immaterial.  If your interest in LINUX is more of a experimental thing, it may wait and possibly go over at 10g or higher.

What does the 440 certification matrix look like?  Could it make more sense to install 10g as a 2nd OH on the 440?  Do you have non-prod environments for dev and qa testing?

You also yet another option to install 11gRx, and set the database compatibility to a lower version (to turn off the advanced features until you're ready for them).  HTH

Author

Commented:
Thanks for your reply. We have a need to move to Linux fairly quickly which is why I am trying to take it over at the 9i level.  I have a test environment.
I just find that the route is tortuous. Our fault for still being at 9i I know, but I don't think I can go directly to the x86x84 server as the minimum level for that is 9.2.0.7. It's just a matter of picking the easiest route. Maybe I should patch the test Sun to 9.2.0.7 and then I could go directly to the x86x64. I have to bear in mind whatever I do must be replicable for when I do it for real. Mamangement require as little downime as possible - but I suppose that's the case for us all.
Sr Software Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Many thanks - reassuring to get your feedback

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.