Unix&Oracle8i

[Fadia Almarei]

Dear All

I want a documentation and comparision sheets of the oprating systems(Unix and linux)that can run oracle8i and whhich OS is the best to get higher performance and stability.

BR;
Fadia

[Steven E. Protter]

Shalom,

Trying to get this information is a fool's errand because performance data is tainted by the marketing agenda of the tester.

I will give expereince.

1) Oracle 8i is obsolete and out of support. Oracle won't help you if you have trouble.
2) I've run 8.1.7.4 the last release of 8i succesfully on Linux and HP-UX. Properly patched, it was very stable.
3) Performance varied with disk and i/o setup. It was pretty rough with linux and ide drives, it was pretty good with storage in which data, redo and index was configured raid 1.

SEP

[whiteknight]

hi Fadia,

http://www.oracle.com/corporate/press/2007_jun/tpc-h-30tb-hp.html


refer to this
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp


Anyway it is for 10g, you can use as comparison.

WK
please assign points

[paolo barila]

Hi,

From 10G version, Oracle is developed on Linux, (before it was on Solaris), that is: Oracle 10G works best on Linux.

Pablo

[Fadia Almarei]

thanks for all answers, but i want the information related to oracle8i .

[Fadia Almarei]

hi Steven

thanks for your notes , but am restricted in using oracle8i (application issue) the information or dcumentation i need to make a sheet with supported documents, so kindly your input

[Wim Rombauts]

Since Oracle 8i is since long out of support, I guess you are stuck with some old legacy application that needs Oracle 8i.
This 8i database software will not support the newest OS releases or OS functionality.
For making it run and maintaining the configuration, I think you are mostly on your own.

So, knowing that, I think you best look at the OS'es you have already in house and that you are familiar with, an OS where you have good support contacts that are willing to help you, and go for that. I would not try anything new or different that Ihave not yet done when I have to install such an old software.

My further experience is that a software that only runs with Oracle 8i, just means that it needs an Oracle 8i database *client* software, and that it easily runs with an Oracle 9i database. Did this multiple times myself. Maybe that is somehow a solution ?

[Steven E. Protter]

Shalom,

It might be possible to run the application with a newer, supported version of Oracle. Oracle 10g can provide tablespace compatible with applications written for Oracle 8.1.7.4 There may be a few app's like that at my office.

A more direct attempt to answer your question.
http://www.stayahead.com/eventschedule/outline.cfm?CourseCode=OPT

Honestly, because 8i is so old, there isn't much out there on it.

SEP