Re: Oracle Application Architecture

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 1 Aug 2003 08:59:31 +0100
Message-ID: <3f2a1de4$0$18493$ed9e5944@reading.news.pipex.net>

"HockeyGuy" <heymorons_at_earthlink.net> wrote in message news:xkdWa.127351$Io.10812097_at_newsread2.prod.itd.earthlink.net...
> Lots of bright people in these newsgroups...
>
> I have oracle application (e-busiess) 11.5.3 and oracle DB 8.1.6 running
on
> one HP box and it is overloaded. I have a chance to use an AIX (IBM
UNIX)
> box to split the apps from the DB. To move the DB to AIX I need to
upgrade
> the 8.1.7.4.
>
> Question - what do folks think about splitting the Oracle Apps from the
> Database and putting the Apps on one server OS and the Database on
another.
> I know it will require testing - but how much more can it be just due to
the
> OS difference. Gezz, what is everyone/anyone opinion of splitting like
> this anyway - I am really stuck and only have an AIX box to work with.
> Suggestions????

Do it. You are of course correct that you will need to test thoroughly it is an upgrade after all, but yes the fact that the DB is now on a different OS shouldn't cause you issues (except maybe licensing issues if you are only licensed for HPUX).

you will need to migrate using exp/imp and should at least consider 9.2 since 8174 ends Error Correction Support at 31/12/2003.

The principle is correct though, dedicate a box to the db and a box to the app should give increased performance. Which box needs to be more powerful depends on how the workload is split.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Aug 01 2003 - 02:59:31 CDT