Oracle Server - Moving from Oracle 8i on Windows to 10G on RH Linux

Author

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

ronnie_yours@yahoo.com

2005-08-22, 11:23 am

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

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

Also do you guys recommend a production database on linux.

Please suggest

Thanks
Ron

DA Morgan

2005-08-22, 11:23 am

ronnie_yours@yahoo.com wrote:
> 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
>
> Is it advisable to do both at the same time and what are the caveats we
> should be aware of.
>
> Also do you guys recommend a production database on linux.
>
> Please suggest
>
> Thanks
> Ron

Do it together as a single step.

No caveats other than make sure you develop skills with the new o/s and
the new version before you make the move. 10g is a very different animal
from 8i and Linux is very different, and far superior, to Windows.

That said why Linux? The support contract which is required, unless you
like flying without instrumentation, can be very expensive. This is why
so many are now looking at Apple's faster and cheaper offering.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

ronnie_yours@yahoo.com

2005-08-22, 11:23 am

Thanks Daniel,

The reason we are thinking of Linux is because we are having issues
with oracle on windows. We are hitting the 1.7G thread limit with
windows and my understanding is that it wont be an issue with linux.

We have to reboot the server once a week or else it crashes by itself
when it 1.7G on the oracle.exe thread.

Also with who do we have to sign the contarct. With RHL I assume.

Thanks
Ron

Robert Klemme

2005-08-22, 11:23 am

HansF

2005-08-22, 11:23 am

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 ***

Sybrand Bakker

2005-08-22, 1:23 pm

On 22 Aug 2005 08:28:23 -0700, ronnie_yours@yahoo.com wrote:

>The reason we are thinking of Linux is because we are having issues
>with oracle on windows. We are hitting the 1.7G thread limit with
>windows and my understanding is that it wont be an issue with linux.

You need to tune your application. Replacing the platform is not going
to solve your problem, because you will hit other limits, while you
didn't tune your application.

--
Sybrand Bakker, Senior Oracle DBA

hpuxrac

2005-08-22, 8:23 pm

ronnie_yours@yahoo.com wrote:
> 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
>
> Is it advisable to do both at the same time and what are the caveats we
> should be aware of.
>
> Also do you guys recommend a production database on linux.
>
> Please suggest
>
> Thanks
> Ron

Ron as other people have suggested the problem you are running into is
probably an application related problem that you force oracle into.

Now there's nothing wrong with migrating away from windows, or
upgrading the database in itself.

But fixing your problem before you migrate would be the best solution,
otherwise you are just buying time (maybe) until someone really takes
the time to figure out what is going on.

ronnie_yours@yahoo.com

2005-08-22, 8:23 pm

We have tried a lot of this including oratsack to fix this without any
success. We also implemented the /3 GB switch but that didnt work also

We even tuned the sql as mush as we could.

-Ron

Matthias Hoys

2005-08-22, 8:23 pm

<ronnie_yours@yahoo.com> wrote in message
news:1124740961.467662.205810@g44g2000cwa.googlegroups.com...
> We have tried a lot of this including oratsack to fix this without any
> success. We also implemented the /3 GB switch but that didnt work also
>
> We even tuned the sql as mush as we could.
>
> -Ron
>

It's not a memory leak, is it ? Did you install the latest Oracle patch set
for 8i ?

DA Morgan

2005-08-22, 8:23 pm

ronnie_yours@yahoo.com wrote:
> Thanks Daniel,
>
> The reason we are thinking of Linux is because we are having issues
> with oracle on windows. We are hitting the 1.7G thread limit with
> windows and my understanding is that it wont be an issue with linux.
>
> We have to reboot the server once a week or else it crashes by itself
> when it 1.7G on the oracle.exe thread.
>
> Also with who do we have to sign the contarct. With RHL I assume.
>
> Thanks
> Ron

I'd go with getting off of Windows and 8i as fast as possible even if
only for reasons of performance and security. But others seem to be
correct that you have a tuning issue. Is your inability to tune it a
question of having EXPERT skills internally and they've failed or having
a more average skill set internally and not knowing how to really do it?

But if leaving Windows do consider all possible alternatives. Don't just
say "Linux" as though it is your only option: It is not.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Kanwar Singh Plaha

2005-08-23, 3:23 am

Hi Daniel,
I read with interest your opinions of going with Apple as opposed to
Linux. Although I will try to steer away from any seemingly zealot
comments here, I would definitely want to ask you to back up your claim
of Apple being cheaper than Linux, support and all included.

My previous company moved from a Solaris platform to Red Hat Linux with
Oracle 10g and have saved heaps (and is saving each time they want to
add a new server). Linux servers (from DELL) are now as cheap as
$10,000 (AU) and come pre-installed with Red Hat Linux AS. I really
want to know the cost of hardware and software of each Apple computer
so we can give a fair assessment to whoever is looking to make a
change.

Don't get me wrong, your comments seem to be driven by "contempt" for
the Open-Source alternative.

Most important: Why lock users into another vendor while veering them
away from one? Apple is as proprietory as Windows. I say this not
because I want all software to be open-source or free (Oracle is not!)
but look at the trend that Oracle has taken: They are moving to open
standards all around. Shouldn't that be a guideline for their users
too?

Your thoughts?

Noons

2005-08-23, 3:23 am

Kanwar Singh Plaha wrote:

> My previous company moved from a Solaris platform to Red Hat Linux with
> Oracle 10g and have saved heaps (and is saving each time they want to
> add a new server). Linux servers (from DELL) are now as cheap as
> $10,000 (AU) and come pre-installed with Red Hat Linux AS. I really
> want to know the cost of hardware and software of each Apple computer
> so we can give a fair assessment to whoever is looking to make a
> change.

You haven't hit many problems/bugs with Oracle+RH, have you?
Some have...

> Most important: Why lock users into another vendor while veering them
> away from one?

It's not locking anymore.

> Apple is as proprietory as Windows.

Not with OSx. It's Unix, for all intents and purposes. And since
the vast majority of users out there wouldn't give a toss about
having access to the actual source code - all they want is a cheap
open standards based solution - things even out.

> but look at the trend that Oracle has taken: They are moving to open
> standards all around. Shouldn't that be a guideline for their users
> too?

Yup. That's why Apple is nowadays such a good fit.
"open" is not a synonym for "linux", although of course Linux
is open.

DA Morgan

2005-08-23, 1:23 pm

Kanwar Singh Plaha wrote:
> Hi Daniel,
> I read with interest your opinions of going with Apple as opposed to
> Linux. Although I will try to steer away from any seemingly zealot
> comments here, I would definitely want to ask you to back up your claim
> of Apple being cheaper than Linux, support and all included.
>
> My previous company moved from a Solaris platform to Red Hat Linux with
> Oracle 10g and have saved heaps (and is saving each time they want to
> add a new server). Linux servers (from DELL) are now as cheap as
> $10,000 (AU) and come pre-installed with Red Hat Linux AS. I really
> want to know the cost of hardware and software of each Apple computer
> so we can give a fair assessment to whoever is looking to make a
> change.
>
> Don't get me wrong, your comments seem to be driven by "contempt" for
> the Open-Source alternative.
>
> Most important: Why lock users into another vendor while veering them
> away from one? Apple is as proprietory as Windows. I say this not
> because I want all software to be open-source or free (Oracle is not!)
> but look at the trend that Oracle has taken: They are moving to open
> standards all around. Shouldn't that be a guideline for their users
> too?
>
> Your thoughts?

The financial argument is this simple.

A 2 CPU Mac G5 with operating system and 3 years of AppleCare support
can be had for well under $5000. The equivalent support agreement
for 3 years from RedHat will cost more thanthat and doesn't include
the hardware ... just the o/s and its support.

Now you may prefer to fly without a support contract and that is
certainly your right. But if you do then you are no longer comparing
apples with apples. ;-)
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

DA Morgan

2005-08-23, 1:23 pm

Kanwar Singh Plaha wrote:

> Don't get me wrong, your comments seem to be driven by "contempt" for
> the Open-Source alternative.

Sorry I didn't see this comment until too late in my previous response.
Surely you are smoking something very potent.

I am writing this on a RedHat Linux machine in a room in which I teach
on which every single machine has Linux installed. Contempt has nothing
to do with it. It is about value. It is about money. Apple is just
offering better performance at a lower cost.

Contempt? Hardly. But then perhaps you are some kind of religious
zealot that thinks OpenSource=GOOD, Commercial=EVIL. See I can jump to
unsupported conclusions too. ;-)
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Sponsored Links