{"id":113,"date":"2022-07-01T11:39:53","date_gmt":"2022-07-01T11:39:53","guid":{"rendered":"http:\/\/wp.chaoyu.nl\/?p=113"},"modified":"2022-09-09T12:28:07","modified_gmt":"2022-09-09T12:28:07","slug":"oracle-21-xe-apex-ords-nginx-as-load-balancer-plsql-ws-proxy-installation-notes","status":"publish","type":"post","link":"https:\/\/chaoyu.nl\/?p=113","title":{"rendered":"Oracle 21 XE, APEX, ORDs, Nginx as Load Balancer, PLSQL  WS Proxy Installation Notes"},"content":{"rendered":"\n<ul class=\"is-style-default has-white-background-color has-background wp-block-list\"><li>High level design <\/li><li>Database &amp; APEX installation<\/li><li>Linux ORDs Installation<\/li><li>Nginx load balancer configuration<\/li><li>Nginx PLSQL Webservice Proxy server configuration<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>High level design<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/Screenshot-2022-06-22-at-08.54.06.png\" alt=\"\" class=\"wp-image-116\" width=\"1054\" height=\"588\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Database &amp; APEX installation<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Oracle 21XE installation <\/li><li>Oracle APEX installation<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Database Installation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For Oracle 21XE installation, i would suggest to follow this<a rel=\"noreferrer noopener\" href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/xeinl\/installing-oracle-database-xe.html#GUID-46EA860A-AAC4-453F-8EEE-42CC55A4FAD5\" target=\"_blank\"> oracle official guide<\/a>, it is pretty straight forward.<strong> (I assume that you use Oracle Linux 8.5 as your host operating system<\/strong>)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Common Issues with DB installation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you ever face the issue that during post installation, sqlplus command cannot be found. Here is your possible fix. <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">nano ~\/.bash_profile<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">add these lines to the end<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">export PATH=\/usr\/local\/sbin:\/usr\/local\/bin:\/usr\/sbin:\/usr\/bin:\/root\/bin:\/opt\/oracle\/product\/21c\/dbhomeXE\/bin\nexport ORACLE_HOME=\/opt\/oracle\/product\/21c\/dbhomeXE\nexport ORACLE_SID=XE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-f571t\">Notice that I am running db version 21c here, you need to change it to your db version accordingly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-874s3\">Next, if you on ssh, exit current session and reconnect, sqlplus should now work<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Next, we need to open port 1521 for remote connections.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">firewall-cmd --list-all #check opened ports\nfirewall-cmd --add-port=1521\/tcp --permanent.   # add 1521 \nfirewall-cmd --reload.  # reload firewall<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Oracle APEX installation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-2ca67\">I have a mixed bag of feelings about APEX installations, there are lot of guide of how to do this, and all of them does it slightly different from each other. I will leave some links, you decide which one to follow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-9bjur\">It all involves<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Download APEX.zip<\/td><\/tr><tr><td>Unzip file into a folder <\/td><\/tr><tr><td>CD into that folder<\/td><\/tr><tr><td>Connect to DB with sqlplus, switch to Pluggable database (normally XEPDB1)<\/td><\/tr><tr><td>run sql scripts from that folder<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-8sun6\"><a href=\"https:\/\/dsavenko.me\/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-part-two\/\" target=\"_blank\" rel=\"noreferrer noopener\"><u>link 1<\/u><\/a>, <a href=\"https:\/\/books.clusterapps.com\/books\/deploy-and-configure\/page\/oracle-xe-and-apex-on-centos-7\" target=\"_blank\" rel=\"noreferrer noopener\"><u>lnk 2<\/u><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-7cqou\">Note that we don&#8217;t need to do anything with the APEX IMAGES folder, since we use ORDS on dedicated machines, we need to do it a little differently, therefore, we need the IMAGES folder when we config ORDs servers. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Linux <strong>ORDs<\/strong> Installation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For ORDs, we use dedicated linux server for it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(I assume you are using Oracle Linux 8.5 as your host operating system) Installation ORDs on linux is very easy, for that we need to download the latest version of ORDs. Google <mark style=\"background-color:#abb8c3\" class=\"has-inline-color\"><kbd>Oracle ORD<\/kbd>s<\/mark><code> <\/code>and find the download link then use wget to download it directly onto your server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">create a new folder<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">mkdir -p \/opt\/oracle\/ords\n# unzip into \nunzip ords-*.zip -d \/opt\/oracle\/ords\n# install ORDs\njava -jar ords.war install\nords install\n#both should work<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Before you can use ords as command, remember to add <code><mark style=\"background-color:#7bdcb5\" class=\"has-inline-color\">\/opt\/oracle\/ords\/bin <\/mark><\/code> to your bash profile.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">cat ~\/.bash_profile \nnano ~\/.bash_profile <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">During ORDs installation, we are prompted to answer some questions related your existing DB we installed earlier, these information are used to for ORDs to establish connection to it. these questions are <\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Private IP of the DB<\/td><\/tr><tr><td>port of the DB ( normally 1521 )<\/td><\/tr><tr><td>sys user \/sys pwd (this pwd were set during installation)<\/td><\/tr><tr><td>pluggable SID name ( normally XEPDB1 )<\/td><\/tr><tr><td>set static location for APEX images (\/var\/www\/apex\/images)<\/td><\/tr><tr><td>port for ords to listen (8080)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>APEX static files &#8216;IMAGES&#8217; folder<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Use wget to download apex.zip onto this server and unzip it to a folder. Copy all content within images into \/var\/www\/apex\/images<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">mkdir -p \/var\/www\/apex\/images\ncp -a \/opt\/oracle\/apex\/images\/. \/var\/www\/apex\/images<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">And don&#8217;t forget to open port 8080 <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">firewall-cmd --list-all #check opened ports\nfirewall-cmd --add-port=8080\/tcp --permanent.   # add 1521 \nfirewall-cmd --reload.  # reload firewall<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create systemd service to auto start ORDs on Linux system startup<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">nano \/etc\/systemd\/system\/ordsonboot.service<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the following content: <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">[Unit]\n Description=Service description\n[Service]\n User=root\n ExecStart=\/bin\/bash -c 'PATH=\/opt\/oracle\/ords\/bin:$PATH exec \/root\/start_up_script.sh'\n[Install]\n WantedBy=default.target<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">create start_up_script.sh<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">nano start_up_script.sh<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">enter the following content:<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">cd \/root &amp;&amp; ords serve \n#cd to root and execute \"ords serve\" see more from ords installation guide from oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">add execute permission<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">chmod +x start_up_script.sh<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-27a20\">Explanation :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-64nfg\">You can also run cd \/opt\/oracle\/ords\/ &amp;&amp; ords serve instead. In any folder when you run &#8220;ords serve&#8221;, two folders will be created, they are <strong>databases<\/strong> and <strong>global<\/strong>. Within them, you can find some xml files with settings. They can be changed according to you needs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">prepare service and enable it and run it<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">systemctl daemon-reload\nsystemctl start ordsonboot.service\nsystemctl status ordsonboot.service #check status\nsystemctl enable ordsonboot.service #to enable startup run\nsystemctl stop ordsonboot.service #to stop service<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is the last step for ORDs installations, we now can clone this VM and spin it into a new vm. In fact, you can clone this VM as many time as you would like and add it into your load balancer backends. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Nginx load balancer configuration<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li><u>DNS records<\/u><\/li><li><u>SSL wild cards<\/u><\/li><li><u>Nginx Load Balancer<\/u><\/li><li>Nginx SSL<\/li><li>Nginx force WWW<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">For this load balancer configuration, I will use my own domain and add a wildcard ssl. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>DNS Records settings<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1237\" height=\"412\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/Screenshot-2022-07-01-at-14.57.04.png\" alt=\"\" class=\"wp-image-140\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-b05vm\">I use Digital Ocean as my DNS management tool. One of the reasons that I choose Digital Ocean is that it can easily create wildcards SSL for you domain and subdomains.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-59bbm\">In the DNS records, I created 3 A records, they all point to my IP address.I use <a rel=\"noreferrer noopener\" href=\"http:\/\/apex.chaoyu.nl\" data-type=\"URL\" data-id=\"apex.chaoyu.nl\" target=\"_blank\">apex.chaoyu.nl<\/a> as the url to my loadbalancer. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Request wildcard SSL<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Here is a wonderful <a rel=\"noreferrer noopener\" href=\"https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-create-let-s-encrypt-wildcard-certificates-with-certbot\" target=\"_blank\">link<\/a> I have used to create the ssl for my domain. Notice that the domain section I typed<code><strong><mark style=\"background-color:#7bdcb5\" class=\"has-inline-color\"> -d '*.chaoyu.nl' -d 'chaoyu.nl'<\/mark><\/strong><\/code> , this way both <a href=\"http:\/\/chaoyu.nl\" data-type=\"URL\" data-id=\"chaoyu.nl\" target=\"_blank\" rel=\"noreferrer noopener\">chaoyu.nl<\/a> and <a href=\"http:\/\/apex.chaoyu.nl\" data-type=\"URL\" data-id=\"apex.chaoyu.nl\" target=\"_blank\" rel=\"noreferrer noopener\">apex.chaoyu.nl <\/a>will be SSL enabled. <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">sudo certbot certonly \\\n  --dns-digitalocean \\\n  --dns-digitalocean-credentials ~\/certbot-creds.ini \\\n  -d '*.chaoyu.nl' -d 'chaoyu.nl'<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After you have followed the link, you should see some files in <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">cd \/etc\/letsencrypt\/live\/chaoyu.nl\/ <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"91\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/e56ed0_db2c498f1bf5466b964959462acc0d05_mv2.png\" alt=\"\" class=\"wp-image-142\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Renew SSL Certificates<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To renew your SSL certificates , simply run the following commands. <\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">certbot renew<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This is the output from &#8220;cerbot renew&#8221;, you would need to restart your webserver or reboot your server to see effects.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">Saving debug log to \/var\/log\/letsencrypt\/letsencrypt.log\n\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\nProcessing \/etc\/letsencrypt\/renewal\/chaoyu.nl.conf\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\nRenewing an existing certificate for *.chaoyu.nl and chaoyu.nl\nWaiting 10 seconds for DNS changes to propagate\n\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\nCongratulations, all renewals succeeded: \n  \/etc\/letsencrypt\/live\/chaoyu.nl\/fullchain.pem (success)\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Nginx Load Balancer Configurations<\/strong> &amp; SSL &amp; Force WWW<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-f0g8o\">All these 3 topics are packed in one configuration file as following<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"nginx\" class=\"language-nginx line-numbers\">user root; # it can be user Nginx\nworker_processes auto;\nerror_log \/var\/log\/nginx\/error.log;  # here is your error log file location, you can also have access log as well. we will discuss it in the forward proxy config file\nevents {\n    worker_connections 1024;\n}\nhttp {\n   upstream backend {\n      server 192.168.178.46:8080;\n      server 192.168.178.45:8080;\n      server 192.168.178.50:8080;\n   } # this is my backend set, 3 ORDS servers, they are running in standalone mode.\n   #www.chaoyu.nl\n   server {\n      listen 80;\n      server_name chaoyu.nl www.chaoyu.nl;\n      return 301 https:\/\/www.chaoyu.nl$request_uri;\n   } # redirect 80 traffic to 443 and force WWW\n   server {\n      listen 443 ssl;\n      server_name chaoyu.nl;\n      ssl_certificate \"\/etc\/letsencrypt\/live\/chaoyu.nl\/fullchain.pem\"; # pointing at your file\n      ssl_certificate_key \"\/etc\/letsencrypt\/live\/chaoyu.nl\/privkey.pem\"; # pointing at your file\n      return 301 https:\/\/www.chaoyu.nl$request_uri;\n   }\t# redirect none WWW traffic to 443 and force WWW\n    server {\n\tlisten       443 ssl;\n        server_name  www.chaoyu.nl;\n        root         \/usr\/share\/nginx\/html2;\n        ssl_certificate \"\/etc\/letsencrypt\/live\/chaoyu.nl\/fullchain.pem\";\n        ssl_certificate_key \"\/etc\/letsencrypt\/live\/chaoyu.nl\/privkey.pem\";\n        ssl_session_cache shared:SSL:1m;\n        ssl_session_timeout  10m;\n        ssl_ciphers PROFILE=SYSTEM;\n        ssl_prefer_server_ciphers on;\n        location \/ {\n            index index.html index.htm;\n        }\n    }# redirect 443 traffic handler\n   # apex.chaoyu.nl\n   server {\n\t listen 80;\n         server_name apex.chaoyu.nl;\n\t return 301 https:\/\/$server_name$request_uri;\n   }# redirect 80 traffic to 443\n   # Settings for a TLS enabled server.\n    server {\n        listen       443 ssl;\n        server_name  apex.chaoyu.nl;\n       # root         \/usr\/share\/nginx\/html;\n        ssl_certificate \"\/etc\/letsencrypt\/live\/chaoyu.nl\/fullchain.pem\";\n        ssl_certificate_key \"\/etc\/letsencrypt\/live\/chaoyu.nl\/privkey.pem\";\n        ssl_session_cache shared:SSL:1m;\n        ssl_session_timeout  10m;\n        ssl_ciphers PROFILE=SYSTEM;\n        ssl_prefer_server_ciphers on;\n        # Load configuration files for the default server block.\n        # include \/etc\/nginx\/default.d\/*.conf;\n        location \/ {\n            proxy_pass http:\/\/backend;  # load balancer \n            proxy_set_header Origin \"\" ; # needed for apex \n            proxy_set_header X-Forwarded-Host $host:$server_port; # needed for apex \n            proxy_set_header X-Real-IP $remote_addr; # needed for apex \n            proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; # needed for apex \n            proxy_set_header X-Forwarded-Proto $scheme; # needed for apex        \n\t}\n    }# SSL for apex.chaoyu.nl subdomain\n}<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Load Balancer Common Issues<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"854\" height=\"361\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/e56ed0_474daba33f764c7182513de3aa42d4c6_mv2.png\" alt=\"\" class=\"wp-image-145\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-al4e5\">You can read more <a rel=\"noreferrer noopener\" href=\"https:\/\/stackoverflow.com\/questions\/23948527\/13-permission-denied-while-connecting-to-upstreamnginx\" target=\"_blank\"><u>here<\/u><\/a>,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"viewer-2l8jn\">Basically, you need to run this command. ( Don&#8217;t ask me why )<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">sudo setsebool -P httpd_can_network_connect 1<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>PLSQL Rest Call with Proxy, no wallet needed<\/strong><\/h2>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create a Nginx Forward Proxy<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">install vm, install nginx<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">cd \/etc\/nginx\nmv nginx.conf nginx.conf.old # to save default file in case you need. \nnano nginx.conf <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">and here is my configuration file<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"nginx\" class=\"language-nginx line-numbers\">user nginx;\nworker_processes auto;\nerror_log \/var\/log\/nginx\/error.log;\nevents {\n    worker_connections 1024;\n}\nhttp {\n    log_format compression '$remote_addr - $remote_user [$time_local] '\n                           '\"$host\" $host '\n                           '\"$request\" $status $body_bytes_sent '\n                           '\"$http_referer\" \"$http_user_agent\" \"$gzip_ratio\"';\n  server {\n      listen 80;\n      access_log \/var\/log\/nginx\/nginx-access.log compression;\t\n      # i promised access_log and  here is how\n      resolver 8.8.8.8;\n      location \/api.linkedin.com\/v2\/me {\n         set $passUrl https:\/\/api.linkedin.com\/v2\/me;\n         proxy_pass $passUrl;\n      }\n      location \/onesignal.com\/api\/v1\/notifications {\n         set $passUrl https:\/\/onesignal.com\/api\/v1\/notifications;\n         proxy_pass $passUrl;\n      }\n    # each time i need to a new access point, i come here to add a new location node, can it be better , ja if will be nice if this can be dynamic , where it takes location automatically . \n  }\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Remember to open port 80 using firewall-cmd.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Login to Oracle DB server and edit Host file on the server<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Host file is the local DNS resolver, here we create a new host record. it can be something like this .<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\"> cat \/etc\/hosts<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code lang=\"bash\" class=\"language-bash line-numbers\">127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\n192.168.178.51 proxy.local.  # add this line.  ( your ip should be different )<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"398\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" class=\"wp-image-151\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"927\" height=\"570\" src=\"http:\/\/wp.chaoyu.nl\/wp-content\/uploads\/2022\/07\/image-1.png\" alt=\"\" class=\"wp-image-153\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Done. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>High level design Database &amp; APEX installation Linux ORDs Installation Nginx load balancer configuration Nginx PLSQL Webservice Proxy server configuration High level design Database &amp; APEX installation Oracle 21XE installation Oracle APEX installation Database Installation For Oracle 21XE installation, i would suggest to follow this oracle official guide, it is pretty straight forward. (I assume&#8230;<\/p>\n","protected":false},"author":1,"featured_media":116,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,17,12],"tags":[19,20,21,22,23,24],"class_list":["post-113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","category-linux","category-oralce-db","tag-apex","tag-load-balancer","tag-load-balancing","tag-ords","tag-ords-load-balancer","tag-plsql-webservice-call-proxy"],"_links":{"self":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":35,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":748,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions\/748"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/media\/116"}],"wp:attachment":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}