Note: There are licensing costs associated with Oracle WebLogic Server and Oracle Glassfish Enterprise edition. Oracle REST Data Services is part of the reference architecture used to operate the Oracle Database Cloud Service. It is a free tool that is fully supported against Oracle WebLogic Server, Oracle Glassfish Server, and Apache Tomcat. Oracle REST Data Services (formerly APEX Listener) - The Oracle REST Data Services (ORDS) is Java based, can be installed into any J2EE compliant Web Server, and is the preferred option for use with Oracle Application Express. You have a choice of three Web Listener choices. The Web Listener functions as a communications broker between the Web browser and the Oracle Application Express objects in the Oracle database by mapping browser requests into database stored procedure calls.
No additional client software is required. Users require only a Web browser and the required URL. Once fully installed, the Uniform Resource Locator (URL) will be defined for both developers and end users to access Application Express.
There is no code generation or file based compilation. Oracle Application Express utilizes a simple architecture where pages are dynamically generated using metadata stored within the Oracle Database. You can also utilize Oracle database links and integrate your applications with Web Services.
Your initial installation step, as outlined in the Oracle Application Express Installation Guide, Downloading from Oracle Technology Network, would then APEX_TS_040200 APEX_TS_FILES TEMP /i/.Īs a best practice, install Oracle Application Express into the database(s) which have the database objects you wish to use in your applications. Oracle recommends you create tablespaces specifically for the Application Express engine and Application Express files to enable better management and monitoring For example, Tablespace APEX_TS_040200 would contain the Application Express engine and APEX_TS_FILES for the Application Express files, but the names are arbitrary.
The installation of Application Express creates a separate schema (APEX_040200 for APEX 4.2) to house the programs that make up the Application Express engine and related metadata tables. If you intend to install Application Express into a RAC environment then you should review the associated Application Express and RAC White Paper and also run the script file apxpart.sql, provided as part of the installation files under the utilities directory. Oracle Application Express can be installed into an Oracle Real Application Clusters (RAC) environment. Oracle Application Express cannot be installed into any other relational database.
Oracle strongly recommends that you upgrade to the latest version of Application Express available on the Oracle Technology Network (OTN). Starting with Oracle Database 11gR1, Application Express is installed as part of the standard Oracle Database. It can be installed into any edition of the Oracle Database 10.2.0.4 and above, which includes Enterprise Edition, Standard Edition, Standard Edition One, and Express Edition (XE).
Oracle Application Express is a no-cost option of the Oracle Database which is fully supported as part of your Oracle Database maintenance agreement. When installing Oracle Application Express there are a number of key architecture and management areas to understand.