Monday, June 8, 2015

Installing Oracle XE, ORDS and Apex on CentOS

I am writing a series of blog posts about how to install Oracle 11g Express Edition (XE) with Oracle Application Express (Apex) on a CentOS Linux server, with Apex served by Oracle REST Data Services (ORDS) running on top of Tomcat and Apache.

This is perhaps better explained with an illustration of the setup:

Best of all, this setup consists only of free (license-free) software, and as you will see in this series of blog posts, you will be able to run it all on a cloud server for as little as USD 10 per month, serving hundreds of concurrent users. Gotta love Apex! :-)

The articles will be divided up as follows:

These blog posts will assume that you are familiar with Oracle and Apex, but that (like me) you are a relative newcomer when it comes to Linux. Keep in mind that with Linux, there are typically many alternative ways to accomplish things, and I have chosen the approaches that seem most straightforward to me. Your mileage may vary.

Stay tuned for part one!

10 comments:

Martin D'Souza said...

Hi Morten,

We have already developed an open source build script to do all of this here: https://github.com/OraOpenSource/oraclexe-apex

Martin

Morten Braten said...

@Martin: Yes, I've seen it (and studied parts of it). I'm taking a slightly different approach and my blog posts are showing how to build the server "from scratch", step by step, in order to learn some Linux basics along the way (and also being a reference for myself as to "how did I do this").

- Morten

KlausI said...

Thanks for the great tutorial - excellent description!

Nikola said...

Thank you for great tutorial.
I had problem with installing ORDS 3, but after finding your tutorial everything works great. :-)

I have only one question:
Why did you use Apache and Tomcat together and not only Tomcat?

Thanks

Morten Braten said...

@Nikola: Apache is better at serving static files, and has lots of configuration options via an extensive selection of modules. That said, if you don't need or want Apache, you can certainly run APEX on just Tomcat.

- Morten

Pedro Lopez said...

Very useful tutorial. Thank you very much.

aracila said...

Amazing post! Thanks a lot!
Do you think it will be possible to write the updated post describing full installation process for CentOS 7 + Apex 5.1 + ORDS 3 + Tomcat 8 + Apache

Morten Braten said...

@aracila: An article based on CentOS 7 might come in the future (there are a couple of big differences beween 6 and 7, see this doc for details, it is written for Red Hat but CentOS is basically the same: https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/Migration_Planning_Guide/chap-Red_Hat_Enterprise_Linux-Migration_Planning_Guide-Major_Changes_and_Migration_Considerations.html)

But if you stay on CentOS 6, you can install APEX 5.1, ORDS 3, Tomcat 8 and Apache pretty much as described in the original article, only changing the relevant file/folder names to account for the new versions.

- Morten

RahmanAjani said...

Hello can i use the above steps on solaris sparc?

Bifin said...

We use the Apache + TOMСAT (ORDS19) web server configuration on Windows. DB Oracle12 with APEX19 on Solaris.
Tell me how to make transparent SSO authentication (NTLM or Kerberos) easier? What are the features if the server is on Windows?