Monday, December 23, 2019

Free Oracle Cloud: 17. Configure domain to redirect to APEX app

This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In a previous blog post, we configured the webserver on our Compute VM Instance. We added a website and configured the domain to point to this instance.

I got many requests on how to point the domain name to a specific Oracle APEX app. This is what I will cover in this blog post.

Lets start with connecting to our VM:

From a Terminal connect to your Oracle Cloud VM:

ssh -i ssh_key opc@public_ip

The first thing we do, is changing to the root user, as we want to configure the web server. Alternatively in front of every command you can add sudo.

We logged in as the OPC user, to become the ROOT user we do:

sudo su

# open the configuration file we created in the previous blog post
vi /etc/nginx/conf.d/

# add following
  location / {
    rewrite ^/$ /ords/f?p=101:LOGIN_DESKTOP:0 permanent;

# save and quit (:wq)

My config file looks now like this:

# to test Nginx configuration
nginx -t 

# to restart Nginx
nginx -s reload

That's it.


Bertil Tandayamo said...

Hi, Dimitri.
I know is nothing about with this blog, but anyways
could you help me with something,
What kind of business/companies have oracle apex as software architecture?.
Does also big tech companies like Facebook, Google use in some transactions?
How come this?, Because I've seen a lot of job alerts coming just from India, or Egypt. countries who are in the process of development and nothing from Europe or the US.

Thank you in advance for your answer.

Bertil Tandayamo

Dimitri Gielis said...

Hi Bertil,

There are many big companies using Oracle APEX. Some in automotive are Volkswagen and BMW, some in Pharma are Davita and Merck, you have companies like Siemens in industry and Harvard University in Education. In technology, you have Oracle themselves. I'm unsure about Google and Facebook, I guess they use their own systems and not Oracle APEX.
But hopefully, you can see that Oracle APEX is used across many domains with many different (big) companies.

When you look at you find jobs in US and Europe too. In fact, Germany is one of the biggest markets for Oracle APEX.

Hope that helps,