EberApp Bloghttp://blog.eberapp.com/ords/f?p=BLOG:HOMEEberApp Blog most recent articlesenOracle XE 18c APEX Server (Part 1)Jeff EberhardAPEXhttp://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201811170914201251&cs=1C0F31DA3EB57A21D90B49B2A3D937B56Oracle XE 18c APEX Server<p>With the recent release of the latest Oracle XE version, 18c (18.4),&nbsp;I wanted to get a sandbox server up and running similar to what I had done in my previous post: <a href="https://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201801221725141101" target="_blank">Create APEX instance in the cloud with OXAR</a></p> <p>Those instructions used OraOpenSource OXAR to quickly build a fully functional instance of Oracle XE and APEX.&nbsp; But it was written for the old version of XE and plans to update it were not likely (<a href="https://github.com/OraOpenSource/OXAR/issues/258" target="_blank">Issue 258</a>).&nbsp; I haven&#x27;t worked with Docker enough to quickly build up a server using Docker containers so I went though the current OXAR configuration and updated it to work with the following versions:</p> <p>Oracle XE: 18.4.0.0.0<br /> APEX: 18.2<br /> ORDS: 18.3.0</p> <h2>Provisioning the Server</h2> <p>DigitalOcean offers affordable pricing for online virtual machines. &nbsp;You can sign up for DigitalOcean and receive a credit&nbsp;using this referral link:&nbsp;https:&#x2F;&#x2F;m.do.co&#x2F;c&#x2F;065d9de8f0ba</p> <p>After you have signed up for DigitalOcean click the Create button and choose Droplets (droplets are basically what DigitalOcean calls it virtual machines).</p> <p style="text-align:center"><img alt="" height="232" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_create_droplet_button.png" width="106" /></p> <p>Next select the image distribution: CentOS&nbsp;7.5 x64</p> <p style="text-align:center"><img alt="" height="171" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_create_droplet_distribution.png" width="474" /></p> <p>Select the server size you want to build.&nbsp;For this example I chose&nbsp;the 2GB size (the database wouldn&#x27;t install with the 1GB option)..</p> <p style="text-align:center"><img alt="" height="104" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_create_droplet_size.png" width="471" /></p> <p>Scroll down and select a datacenter region. I chose San Francisco since it is the nearest location to me.</p> <p style="text-align:center"><img alt="" height="145" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_create_droplet_datacenter.png" width="493" /></p> <p>You can manage the server by using passwords or by utilizing SSH key pairs. If you want to just use passwords skip this&nbsp;SSH Keys step.</p> <p style="margin-left:80px"><strong>SSH Keys</strong></p> <p style="margin-left:80px">SSH Keys</p> <p style="margin-left:80px">Based on <a href="https://www.digitalocean.com/docs/droplets/how-to/add-ssh-keys/create-with-putty/" target="_blank">this </a>article&nbsp;I created and added an SSH Key.</p> <p style="margin-left:80px">Run the PuTTY Key Generator application.</p> <p style="text-align:center"><img alt="" height="31" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_app.png" width="89" /></p> <p style="margin-left:80px">Click the Generate button</p> <p style="text-align:center"><img alt="" height="291" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_gen_btn.png" width="300" /></p> <p style="margin-left:80px">If desired add and confirm a key passphrase. &nbsp;Highlight the generated key and copy it to the clipboard. &nbsp;Click the Save public key button and save the file as a .txt file.</p> <p style="text-align:center"><img alt="" height="290" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_savepublicbtn.png" width="300" /></p> <p style="text-align:center"><img alt="" height="47" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_savepublictxt.png" width="350" /></p> <p style="margin-left:80px">Click the Save private key button and save it as a .ppk file.</p> <p style="text-align:center"><img alt="" height="56" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_saveprivateppk.png" width="425" /></p> <p style="margin-left:80px">You can close the PuTTY Key Generator application at this point.</p> <p style="margin-left:80px">Return to the DigitalOcean create droplet page and click the New SSH Key button.</p> <p style="text-align:center"><img alt="" height="77" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_NewSSHKeyBtn.png" width="200" /></p> <p style="margin-left:80px">In the SSH key content field past the key that you previously copied into the clipboard. &nbsp;Enter a name into the name field and click the Add SSH Key button.</p> <p style="text-align:center"><img alt="" height="333" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_AddSSHKeyBtn.png" width="400" /></p> <p style="margin-left:80px">&nbsp;The named key is added.</p> <p style="text-align:center"><img alt="" height="80" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_SSHKeys.png" width="270" /></p> <p style="margin-left:80px">&nbsp;</p> <p>Finally, enter a name for your server and click the Create button.</p> <p style="text-align:center"><img alt="" height="245" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_create_droplet_create.png" width="689" /></p> <p>The droplet will be created. &nbsp;If you did not add an SSH key an&nbsp;email will be sent to you with the root password.</p> <p style="text-align:center"><img alt="" height="68" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_list_droplets.png" width="287" /></p> <p>Note the IP address of the droplet or hover over the IP address and a copy link will display that can be clicked to copy the IP address to the clipboard.</p> <p style="text-align:center"><img alt="" height="47" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/DO_IP_Address.png" width="157" /></p> <h3>Connecting to the server</h3> <p>DigitalOcean has an Access console option to connect to your server or use your favorite terminal program to ssh into your server using the IP address of the server.</p> <p>I&#x27;m on windows and like the puTTY application. The following steps show how to configure and save a session which can be used&nbsp;for connecting to the server.</p> <p>Enter the noted&#x2F;copied IP address into the Host Name field</p> <p style="text-align:center"><img alt="" height="128" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/PuTTY_connection_settings.png" width="295" /></p> <p>&nbsp;</p> <p>Expand the Connection Category then select the Data item. &nbsp;Enter root into the Auto-login username field.</p> <p style="text-align:center"><img alt="" height="385" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_Autologin.png" width="400" /></p> <p>Expand the SSH option and then select the Auth option. &nbsp;For the private key file for authentication field click the Browse button and locate and select the .ppk file that you saved of the SSH key.</p> <p style="text-align:center"><img alt="" height="382" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_SSHfile.png" width="400" /></p> <p>Enter a name into the Saved Sessions field and click the Save button (to save the session settings).</p> <p style="text-align:center"><img alt="" height="387" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/PuTTY_Configuration_Save.png" width="402" /></p> <p>Click the Open button to open the session. &nbsp;The first time you will get a warning about server&#x27;s host key not being cached in the registry. &nbsp;Click Yes to continue.</p> <p style="text-align:center"><img alt="" height="255" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_serverkey.png" width="375" /></p> <p>You will be connected as the root user</p> <p style="text-align:center"><img alt="" height="267" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/PuTTY_connected.png" width="422" /></p> <p>&nbsp;</p> <p>See <a href="http://blog.eberapp.com/ords/f?p=BLOG:READ:0::::ARTICLE:201811180202461301&amp;cs=131FDAD138893A973870E1DEFE775EA3B">Part 2</a> to utilize OXAR to install the Oracle Database XE, ORDS, and APEX.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> Sat, 17 Nov 2018 14:31:00 GMT2018111709142012512458440143100Oracle XE 18c APEX Server (Part 2)Jeff EberhardAPEXhttp://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201811180202461301&cs=131FDAD138893A973870E1DEFE775EA3BOracle XE 18c APEX Server<p>This is Part 2 of how to create a server consisting of the&nbsp;Oracle XE 18c&nbsp; database and an&nbsp;APEX instance using&nbsp;OXAR. &nbsp;<a href="http://blog.eberapp.com/ords/f?p=BLOG:READ:0::::ARTICLE:201811170914201251&amp;cs=1C0F31DA3EB57A21D90B49B2A3D937B56">Part 1</a>&nbsp;shared steps for creating and connecting to the online virtual machine.</p> <h2>Using OXAR to configure the server</h2> <p>I&#x27;ve taken the oraOpenSource OXAR distribution and updated it to work with Oracle XE 18c database.&nbsp; You can refer to <a href="https://github.com/eberhje/OXAR" target="_blank">my&nbsp;OXAR github page</a> and also refer to the <a href="https://github.com/OraOpenSource/OXAR" target="_blank">OraOpenSource OXAR github</a> page to get information on configuring and using OXAR.</p> <h3>Copy Oracle files to server</h3> <p>Follow the OXAR instructions on where to download the Oracle installation files from and how to copy them to your server. &nbsp;In my case, I just created a directory name orafiles and then moved the files from my windows machine using pscp (I copied my .ppk file to the same directory for ease of use).</p> <p style="text-align:center"><img alt="" height="314" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/mkdir_orafiles.png" width="530" /></p> <p style="text-align:center"><img alt="" height="211" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/copy_files.png" width="554" /></p> <h3>Disable SELinux</h3> <p>The OXAR installation has a problem installing ORDS when SELinux is enabled. &nbsp;Before we begin the OXAR installation we configure the server to disable&nbsp;SELinux so everything will work.</p> <p>Edit the &#x2F;etc&#x2F;sysconfig&#x2F;selinux file and change the SELINUX line from enforcing to disabled.</p> <p style="text-align:center"><img alt="" height="362" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/vi_selinux.png" width="607" /></p> <p>&nbsp;</p> <p style="text-align:center"><img alt="" height="189" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/selinux_config.png" width="600" /></p> <p>Save the file and then reboot the machine.</p> <p style="text-align:center"><img alt="" height="362" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/reboot.png" width="606" /></p> <h3>OXAR download and configuration</h3> <p>After the reboot, log into the machine again and then copy and paste the following lines of code (OXAR Native Build instructions):</p> <p>&#x23;Ensure user is currently root<br /> if [ &quot;$(whoami)&quot; != &quot;root&quot; ]; then<br /> &nbsp; sudo -i<br /> fi</p> <p>cd &#x2F;tmp</p> <p>&#x23;Install Git<br /> if [ -n &quot;$(command -v yum)&quot; ]; then<br /> &nbsp; &#x23;RHEL type OS<br /> &nbsp; yum install git -y<br /> else<br /> &nbsp; &#x23;Debian type OS<br /> &nbsp; apt-get install git-core<br /> fi</p> <p>git clone https:&#x2F;&#x2F;github.com&#x2F;eberhje&#x2F;oxar.git<br /> cd oxar</p> <p>&nbsp;</p> <p>This will install the needed git packages and then clone the OXAR files.</p> <p style="text-align:center"><img alt="" height="328" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/git_OXAR_1.png" width="603" /></p> <p>&nbsp;</p> <p style="text-align:center"><img alt="" height="408" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/git_OXAR_3.png" width="609" /></p> <p>&nbsp;</p> <p>Next we need to edit the config.properties file and replace the CHANGEME tokens with the actual file location and names.</p> <p style="text-align:center"><img alt="" height="445" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/edit_config_properties.png" width="685" /></p> <h3>OXAR installation</h3> <p>Run OXAR installation by executing:<br /> .&#x2F;build.sh</p> <p style="text-align:center"><img alt="" height="446" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/build_sh_2.png" width="687" /></p> <p>&nbsp;</p> <p style="text-align:center"><img alt="" height="419" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/build_sh_3.png" width="645" /></p> <p>&nbsp;Once finished OXAR will give a countdown and reboot the server</p> <p style="text-align:center"><img alt="" height="436" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/build_sh_final.png" width="673" /></p> <p>&nbsp;</p> <p>Open a browser and enter the ip address of the server into the address and the APEX login page should be shown.</p> <p style="text-align:center"><img alt="" height="389" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OraXE18c/apex_login.png" width="607" /></p> <p>&nbsp;</p> <p>Refer to the OXAR github page for the default passwords used and other configuration considerations.</p> <p>Enjoy!!!</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> Sat, 17 Nov 2018 14:30:00 GMT2018111802024613012458440143000Create APEX instance in the cloud with OXAR (Part 1)Jeff EberhardAPEXhttp://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201801221725141101&cs=10FE51837D3B994FAF565EF6E61352EC6How to create and APEX server in the cloud (with digital ocean) using OXAR<h3 style="color:Red;">UPDATE ARTICLE (using Oracle XE 18c) is <a href="http://blog.eberapp.com/ords/f?p=BLOG:READ:0::::ARTICLE:201811170914201251&amp;cs=1C0F31DA3EB57A21D90B49B2A3D937B56">here</a></h3> <p>A few days ago I saw&nbsp;this tweet from Adrian Png:</p> <p style="text-align:center"><img alt="" height="204" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Adrian_DO_OXAR_tweet.png" width="200" /></p> <p><br /> Around the same time I had an acquaintance ask how quickly I could set up a demo of APEX. &nbsp;Normally I would probably just request a new workspace from apex.oracle.com but this time Adrian&#x27;s tweet piqued my interest of setting up a whole APEX server environment online. &nbsp;I had used OXAR a few times to create local VMs so I was a little familiar with it and gave it a go. &nbsp;</p> <p>DigitalOcean offers affordable pricing for online virtual machines. &nbsp;You can sign up for DigitalOcean and receive a $10 credit&nbsp;using this referral link:&nbsp;<a href="https://m.do.co/c/065d9de8f0ba" target="_blank">https:&#x2F;&#x2F;m.do.co&#x2F;c&#x2F;065d9de8f0ba</a></p> <h2>Provisioning the server</h2> <p>After you have signed up for DigitalOcean click the Create button and choose Droplets (droplets are what DigitalOcean calls it virtual machines).</p> <p style="text-align:center"><img alt="" height="297" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_Create_Droplet_button.png" width="155" /></p> <p>Next select the image distribution: CentOS 7.4 x64</p> <p style="text-align:center"><img alt="" height="190" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_image_distribution.png" width="450" /></p> <p>Select the&nbsp;server size you want to build. &nbsp;For this example I chose the smallest&#x2F;cheapest size, 1GB - $5&#x2F;mo.</p> <p style="text-align:center"><img alt="" height="279" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_droplet_size.png" width="300" /></p> <p>Select the datacenter region. &nbsp;I chose San Francisco since it is the nearest location to me.</p> <p style="text-align:center"><img alt="" height="144" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_datacenter_region.png" width="400" /></p> <p>You can manage the server by using passwords or by utilizing SSH key pairs. If you want to just use passwords skip this&nbsp;SSH Keys step.</p> <h3 style="margin-left:40px">SSH Keys</h3> <p style="margin-left:40px">Based on this <a href="https://www.digitalocean.com/community/tutorials/how-to-use-ssh-keys-with-putty-on-digitalocean-droplets-windows-users" target="_blank">article</a>&nbsp;I created and added an SSH Key.</p> <p style="margin-left:40px">Run the PuTTY Key Generator application.</p> <p style="text-align:center"><img alt="" height="31" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_app.png" width="89" /></p> <p style="margin-left:40px">Click the Generate button</p> <p style="text-align:center"><img alt="" height="291" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_gen_btn.png" width="300" /></p> <p style="margin-left:40px">If desired add and confirm a key passphrase. &nbsp;Highlight the generated key and copy it to the clipboard. &nbsp;Click the Save public key button and save the file as a .txt file.</p> <p style="text-align:center"><img alt="" height="290" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_savepublicbtn.png" width="300" /></p> <p style="text-align:center"><img alt="" height="47" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_savepublictxt.png" width="350" /></p> <p style="margin-left:40px">Click the Save private key button and save it as a .ppk file.</p> <p style="text-align:center"><img alt="" height="56" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/PuttyKG_saveprivateppk.png" width="425" /></p> <p style="margin-left:40px">You can close the PuTTY Key Generator application at this point.</p> <p style="margin-left:40px">Return to the DigitalOcean create droplet page and click the New SSH Key button.</p> <p style="text-align:center"><img alt="" height="77" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_NewSSHKeyBtn.png" width="200" /></p> <p style="margin-left:40px">In the SSH key content field past the key that you previously copied into the clipboard. &nbsp;Enter a name into the name field and click the Add SSH Key button.</p> <p style="text-align:center"><img alt="" height="333" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_AddSSHKeyBtn.png" width="400" /></p> <p>&nbsp;The named key is added.</p> <p style="text-align:center"><img alt="" height="80" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_SSHKeys.png" width="270" /></p> <p>Enter a name for your server and click the Create button.</p> <p style="text-align:center"><img alt="" height="134" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_NameCreate.png" width="425" /></p> <p>The droplet will be created. &nbsp;If you did not add an SSH key and email will be sent to you with the root password.</p> <p style="text-align:center"><img alt="" height="160" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_Droplets.png" width="450" /></p> <p>Note the ip address of the droplet or hover over the ip address and a copy link will display that can be clicked to copy the ip address to the clipboard.</p> <p style="text-align:center"><img alt="" height="75" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/DO_ip_copy_link.png" width="120" /></p> <h3 style="margin-left:40px">Connecting to the server</h3> <p style="margin-left:40px">DigitalOcean has an Access console option to connect to your server or use your favorite terminal program to ssh into your server using the ip address of the server.</p> <p style="margin-left:40px">I&#x27;m on windows and like the puTTY application. The following steps show how to configure and save a session which can be used&nbsp;for connecting to the server.</p> <p style="margin-left:40px">Enter the noted&#x2F;copied IP address into the Host Name field</p> <p style="margin-left:40px"><img alt="" height="128" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_HostName.png" width="296" /></p> <p style="margin-left:40px">Expand the Connection Category then select the Data item. &nbsp;Enter root into the Auto-login username field.</p> <p style="text-align:center"><img alt="" height="385" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_Autologin.png" width="400" /></p> <p style="margin-left:40px">Expand the SSH option and then select the Auth option. &nbsp;For the private key file for authentication field click the Browse button and locate and select the .ppk file that you saved of the SSH key.</p> <p style="text-align:center"><img alt="" height="382" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_SSHfile.png" width="400" /></p> <p style="margin-left:40px">Enter a name into the Saved SEssions field and click the Save button (to save the session settings).</p> <p style="text-align:center"><img alt="" height="384" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_savedsession.png" width="400" /></p> <p style="margin-left:40px">Click the Open button to open the session. &nbsp;The first time you will get a warning about server&#x27;s host key not being cached in the registry. &nbsp;Click Yes to continue.</p> <p style="text-align:center"><img alt="" height="255" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_serverkey.png" width="375" /></p> <p style="margin-left:40px">You will be connected as the root user</p> <p style="text-align:center"><img alt="" height="252" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/Putty_connected.png" width="400" /></p> <p>See <a href="https://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201801222028021151">Part 2</a> to utilize OXAR to install the Oracle Database XE, ORDS, and APEX.</p> <h2>&nbsp;</h2> Mon, 22 Jan 2018 22:17:00 GMT2018012217251411012458141221700Create APEX instance in the cloud with OXAR (Part 2)Jeff EberhardAPEXhttp://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201801222028021151&cs=1514C4F1CECF426C9C83C052400D5FB83Create APEX instance in the cloud with OXAR (Part 2)<p>This is Part 2 of how to create an APEX instance in the cloud with OXAR. &nbsp;<a href="https://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201801221725141101">Part 1</a> shared steps for creating and connecting to the online virtual machine.</p> <h2>Using OXAR to configure the server</h2> <p>Refer to the<a href="https://github.com/OraOpenSource/oxar" target="_blank"> OXAR github page</a> to get the latest information on configuring and using OXAR.</p> <h3>Copy Oracle files to server</h3> <p>Follow the OXAR instructions on where to download the Oracle installation files from and how to copy them to your server. &nbsp;In my case, I just created a directory name orafiles and then moved the files from my windows machine using pscp (I copied my .ppk file to the same directory for ease of use).</p> <p style="text-align:center"><img alt="" height="259" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/pscp_examples.png" width="600" /></p> <h3>Disable SELinux</h3> <p>The OXAR installation has a problem installing ORDS when SELinux is enabled. &nbsp;Before we begin the OXAR installation SELinux is disabled so everything will work.</p> <p>Edit the &#x2F;etc&#x2F;sysconfig&#x2F;selinux file and change the SELINUX line from enforcing to disabled.</p> <p style="text-align:center"><img alt="" height="378" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/selinux_vi.png" width="600" /></p> <p style="text-align:center"><img alt="" height="189" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/selinux_config.png" width="600" /></p> <p>Save the file and then reboot the machine.</p> <p style="text-align:center"><img alt="" height="375" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/selinux_reboot.png" width="600" /></p> <p>After the reboot log into the machine again and then copy and paste the following lines of code (OXAR Native Build instructions):</p> <p>&nbsp;</p> <p><code>&#x23;Ensure user is currently root<br /> if [ &quot;$(whoami)&quot; != &quot;root&quot; ]; then<br /> &nbsp; sudo -i<br /> fi</code></p> <p><code>cd &#x2F;tmp</code></p> <p><code>&#x23;Install Git<br /> if [ -n &quot;$(command -v yum)&quot; ]; then<br /> &nbsp; &#x23;RHEL type OS<br /> &nbsp; yum install git -y<br /> else<br /> &nbsp; &#x23;Debian type OS<br /> &nbsp; apt-get install git-core<br /> fi</code></p> <p><code>git clone https:&#x2F;&#x2F;github.com&#x2F;OraOpenSource&#x2F;oxar.git<br /> cd oxar</code></p> <p>&nbsp;</p> <p>This will install needed git packages and then clone the OXAR files.</p> <p style="text-align:center"><img alt="" height="224" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/oxar_git.png" width="600" /></p> <p>Next we need to edit the config.properties file and replace the CHANGEME tokens with the actual file location and names.</p> <p style="text-align:center"><img alt="" height="460" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/oxar_config_file.png" width="600" /></p> <p>Run OXAR installation by executing:<br /> . build.sh</p> <p style="text-align:center"><img alt="" height="359" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OXAR_build_start.png" width="600" /></p> <p>Once finished OXAR will give a countdown and reboot the server</p> <p style="text-align:center"><img alt="" height="358" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OXAR_reboot.png" width="600" /></p> <p>Open a browser and enter the ip address of the server into the address and the APEX login page should be shown.</p> <p style="text-align:center"><img alt="" height="399" src="https://eberapp.nyc3.digitaloceanspaces.com/blog_images/OXAR_APEX_page.png" width="600" /></p> <p>&nbsp;</p> <p>Refer to the<a href="https://github.com/OraOpenSource/oxar" target="_blank"> OXAR github page</a> for the default passwords used and other configuration considerations.</p> <p>Enjoy!!!</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> Mon, 22 Jan 2018 22:16:00 GMT2018012220280211512458141221600Enable HTTPS for your APEX websiteJeff EberhardAPEXhttp://blog.eberapp.com/ords/f?p=BLOG:READ:::::ARTICLE:201701110058270551&cs=138CB135D464F0903326ED08DD2F670EAletsencrypt.org provides a free and easy way to get digital certificates for your website<p>For years I&#x27;ve known about the security risks of building and serving APEX application over just plain HTTP. &nbsp;My reasons for not doing so? <strong>Cost</strong> and <strong>Complexity</strong>.</p> <p>Last year those reasons became obsolete by the service provided by <a href="https://letsencrypt.org" target="_blank">Let&#x27;s Encrypt</a>. Dimitri introduced the <a href="http://dgielis.blogspot.com/2016/05/please-use-https-for-your-apex-apps.html" target="_blank">use of HTTPS for your APEX apps</a> last spring and I finally got around to updating my website(s) to use HTTPS.</p> <p>The following are basically my notes for enabling HTTPS in my environment. &nbsp;I have a droplet on DigitalOcean that is running centOS 6.7. &nbsp;&nbsp;This comes with shell access so according to the Let&#x27;s Encrypt site I can use the Certbot ACME client. &nbsp;I visited the <a href="https://certbot.eff.org/" target="_blank">Certbot site</a>&nbsp;and selected the software (Apache) and system (CentOS 6) for my system.</p> <p style="text-align:center"><img alt="" height="226" src="f?p=3834120:DOWNLOAD:0:CertbotSelect.png" width="425" /></p> <p>This gave me the commands I needed to install certbot. I logged into my server (as root) and ran the following commands as directed:</p> <pre class="brush:plain" style="background-color:#EEEEEE; padding:2px"> wget https:&#x2F;&#x2F;dl.eff.org&#x2F;certbot-auto chmod a+x certbot-auto </pre> <p>I then executed certbot-auto which presents various dialog screens to step you through the process of obtaining and activating the certificates.</p> <pre class="brush:plain" style="background-color:#EEEEEE; padding:2px"> $ .&#x2F;certbot-auto</pre> <p>Certbot was downloaded to a directory that was not included in my path, so I moved it.</p> <pre class="brush:plain" style="background-color:#EEEEEE; padding:2px"> $ mv certbot-auto &#x2F;usr&#x2F;local&#x2F;sbin&#x2F;certbot-auto</pre> <p>Also certbot didn&#x27;t see all the sites I had configured (I forget why) I had to specify the site name(s) when I ran certbot wizard.&nbsp;</p> <pre class="brush:plain" style="background-color:#EEEEEE; padding:2px"> $ certbot-auto --apache -d eberapp.com -d www.eberapp.com</pre> <p>Certbot took care of creating the virtual hosts configuration files to redirect HTTP traffic to HTTPS and all the certificate settings.</p> <p>&nbsp;</p> Tue, 24 Jan 2017 05:43:00 GMT2017011100582705512457778054300