Re: Moving from Oracle 8i on Windows to 10G on RH Linux

On Mon, 22 Aug 2005 07:44:23 -0700, ronnie_yours interested us by writing:

> Hi,
>
> Currently we have Oracle 8i running on a windows 2000 advanced server
> and are planning to change our platform to Red Hat Linux EE 3.0 and
> also are planning to migrate the database to 10G

Good for you. Hope you have the Linux (or Unix) skill set in your camp. If you do, this will be quite nice, especially if you go 'headless' (meaning redirect X-11 display to a separate box, and using another Linux machine, or Windows with Hummingbird Xceed or it's free competitor cygwin.org's X server.)

>
> Is it advisable to do both at the same time and what are the caveats we
> should be aware of.

Depends on two things:

1. What admin skill level is your team at for both Oracle and the appropriate Linux? (Be honest!)
2. Are you willing to use any of Oracle 10g features as well? In which case some time investigating those features is highly recomended.

I would not use 8i on Linux - I'd go to 9i at the very least, so a jump to 10g is quite reasonable. But plan on investigating the extra 10g stuff quickly as it does pay itself off if you can use the capabilities. (See the New Features manual in the docs.)

Personally I'm a SuSE fan so I'd buy SLES9 before RedHat, but that's more religious than technical. Either way, I'd buy the OS support from the vendor, and buy the database from Oracle with a support contract. Then I'd do all Linux and Oracle support through Oracle.

I'd certainly be looking at buying the lowest required Linux (RH ES not AS, or SLES small server) and Oracle Standard Edition, if my requirements permitted that.

> Also do you guys recommend a production database on linux.
>

Not sure I understand this question. (I find a minor ambiguity in the way the question is phrased.)

Assuming you are asking whether it's wise to put a production Oracle database on Linux, the answer is 'yes, without qualification'.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***