Oracle Apex 21.2 Installation Step By Step

[Jenni Israelsen]

Theinstallation section should be followed for new installations and upgrades. Since the release of APEX 18.x, each release requires a full installation, so there is no concept of patching between releases anymore. This simplifies the approach greatly.

In previous versions an upgrade was required when a release affected the first two numbers of the version (4.2 to 5.0 or 5.1 to 18.1), but if the first two numbers of the version were not affected (5.1.3 to 5.1.4) you had to download and apply a patch, rather than do the full installation. This is no longer the case.

Unzip the software either on your client PC if you intend to install it from there using the SQL*Plus client on your PC, or on the database server if you intend to install it from there. The latter will be more efficient as you will reduce the network traffic between the SQL*Plus client and the database server.

If you are upgrading, you've finished the DB upgrade at this point. You only need to run subsequent steps for new installations. You will need to redeploy the image files to your app server. If you are using ORDS, it's a good idea to run an ORDS validate to make sure the APEX hasn't affected your ORDS installation.

Alternatively, edit the "dads.conf" file directly. For the OHS that comes with Forms and Reports Services, this is located here "$FR_INST/config/OHS/ohs1/mod_plsql/dads.conf". Once amended, remember to restart the HTTP server.

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Here are the step by step instructions to install Oracle Apex 20.1 on Windows and Unix/Linux systems.

After downloading, you will get a zip file named something like - apex_20.1. Copy the file from the default download folder and paste it to the folder in which you want to install Oracle Apex 20.1, for example, I moved this file to F:\oracle\apex20, and after extracting the file, I got the "apex" directory here. Now the complete path of my Oracle Apex installation is F:\oracle\apex19\apex.

Now you need to run all the Oracle Apex 19.1 installation scripts from this (F:\oracle\apex19\apex) location. Start the SQL*PLUS with SYS user credentials to connect to the Oracle Database as shown in the following example:

In Multitenant architecture, Oracle has a great option to create different databases for specific applications such as sales database, hr database. So installing apex in different PDB is good to maintain and you can install apex in different PDB databases. For that we can see what PDBs exist in the instance and need to alter session for that PDB using following commands.

Great reinforcement of how Oracle is making it easier and easier to get stuff done. I especially appreciate the reminder at the end: doing things for test and "trying it out" is very different from setting up for production.

Hello Mr. Steven Feuerstein,

I am new to Oracle APEX. I want to know that is it possible to make a point of of sales application for a department store with Oracle APEX and it it good idea to do this.

Hello Unknown! Well I feel most uncomfortable answering an APEX question on Joel Kallman's blog post. But I will start and then I invite Joel to "get real."

Generally, sure, I don't see why you couldn't create a point of sales application in APEX. And I say without seeing any of your requirements, any sense of the volume of activity, number of users...none of that! :-)

Hello Unknown

Yes you can make a point of sales application with APEX. I have done it including barcode scanner and works great.

I have also a networked receipt printer (EPSON) and print the receipts from APEX (I use PL/PDF).

It will get a bit tricky if you want to control a cash drawer and printer directly. But this is not an issue of APEX, it is an issue of the security model of the browser. The printer is not a real problem anymore as both Firefox and Chrome has add-ons to print silently.

If you want to control a cash drawer so it opens on taking payment you will to resort to Java plugins or some other clever stuff send a signal to a cash drawer connected on the serial port. There are other options when you use a Mac.

Hi Raymond,

I was try to build the POS application long back(some apex4.0 lack?),it was issue in barcode scanner(after the scan to auto move next item) and cash drawer connectivity.can you referred to any sample test page?

Dear Sir,

is it possible to auto-authenticate without asking for username and password from one session logged in apex application to another apex server application?

for e.g. As end-user i am currently logged on apex application server A and one of the page from server a links to another server b apex application, when i have linked in this way using url - it asks for authentication username and password of server b application.

i dont want to make public on server b.

is there any way to pass cookies/username from server a to server b automatically?

Thanks Joel for this post. I was able to launch the url successfully and could access the apex pages.

I installed apex and ords on a windows server and for some reason, the server is refusing to connect when I closed the command prompt from where I ran the .war command to install ORDS. If I rerun java -jar ords.war, my apex installation is up and running again. Am I missing any configuration or the command should be left open always?

Please help!

Joel--thanks for this write up. HUGE relief to see this easy walkthrough. A coworker and I are attempting a basic proof of concept to get some APEX buy-in, but we're having a difficult time just getting APEX installed. This post is a God send.

I'm able to get everything working well until I get to the last step and configure and start ORDS. This fails miserably, as I usually never get prompted for anything and the following is generally the first error/indication in the massive stack:

WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//pmad-linora02:1530/pdblarch

Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

I can provide more info if need be. Any advice?

Hi Motohari,

This is really more of a question of "how do you run a program in the background on Windows" - it's not really specific to ORDS. On Linux it's easy, on Windows - not so trivial.

My opinion - you'd be best served to follow the instructions and deploy ORDS in Apache Tomcat. It's straightforward.

Joel

Hi Taylor,

Your problem is that ORDS cannot connect to your PDB. The service name you provided in your ORDS configuration is "pdblarch". From the command line where your database server and database listener are running, run the command "lsnrctl status". Ensure that there is a service name of "pdblarch".

Joel

Hi Joel,

I just found your article which is very helpful. I am installing Oracle Apex on my laptop. I started the below command and it is running since 35 minutes. How long does it take to finish the below command? I logged into pdborcl database and ran the below command.

SQL>@apexins sysaux sysaux temp /i/

Thank

Mohan

Hi Mohan,

It should take about 8 minutes to install. If you don't see the installation process happening (with lines from the execution script being echoed to your screen), then something is wrong - and you're not installing anything. You make it seem like it's stalled.

Joel

In this article, we'll guide you through the simple steps to install APEX and ORDS for Oracle Database 23c on Oracle Linux 8 in the Oracle Cloud Infrastructure (OCI). With these powerful tools, you'll be able to unlock the full potential of your database and explore the amazing world of APEX and SQL-Developer Web. So let's get started!

In order to successfully install ORDS (Oracle REST Data Services) and APEX (Oracle Application Express) for Oracle Database 23c on Oracle Linux 8 within the Oracle Cloud Infrastructure (OCI), it is essential to have a Compute instance running with a fully operational Oracle Database. If you haven't already configured this setup, we've got you covered with a comprehensive guide on how to accomplish this task. Just follow the link provided here to read the step-by-step process and get your Oracle Database up and running on a Compute instance within OCI.

First, log in to your compute instance using your preferred method, whether it be through a remote desktop connection or a terminal. Once you have successfully accessed your instance, download the latest Oracle APEX package by running the following command:

The Oracle REST Data Services (ORDS) can be found in both the Oracle Linux 7 (OL7) and Oracle Linux 8 (OL8) repositories. As we have already enabled the appropriate repository in our previous blog post, the installation process for ORDS becomes quite straightforward. You can effortlessly install ORDS by using either the yum or dnf package manager, depending on your system's preference.

First, log in to your compute instance using your preferred method, whether it be through a remote desktop connection or a terminal. Once you have successfully accessed your instance, you will need to switch to the root user.

ORDS is about to do its magic and take care of the installation tasks for us! Just a heads up, there's going to be quite a bit of scrolling on the screen. But don't worry, when it's all done, we'll have something that looks pretty close to this.

It is recommended to deploy ORDS directly into each PDB in most cases. This way, you can handle your database connection pools one by one. Plus, with PDB-level installs, you can run various ORDS versions in the same CDB or even have different configurations and options enabled. So, in a nutshell, PDB installs provide the most flexibility.

3a8082e126