Re: Oracle Application Architecture

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3f2a1de4$0$18493$ed9e5944_at_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
>
Thank you Niall, appreciate you taking the time to respond. As to testing - I assume I will have to do quite a bit as I am splitting the application from the database. Here is the strange question - if say, I had to do 100 hours of testing, what percentage of that would be attributed to the switch in OS? I keep hearing I can just move "tar" the database and move it over to HP and avoid any testing. What do you "quess" as to the % of testing just due to the OS switch when I split the applications from the DB. Again, really appreciate you taking the time to respond!! Received on Fri Aug 01 2003 - 15:16:36 CEST