Search notes:

Oracle Application Express

APEX is a declarative, rapid web application development tool for the Oracle database.

APEX is a no cost option.

Requirements

SGA and PGA at least 300 MB.
Oracle database release 11.2.0.4 or higher
JavaScript enabled browsers
Access to a web listener (preferably Oracle REST Data Services (ORDS) because both Embedded PL/SQL Gateway and Oracle HTTP Server and mod_plsql are deprecated.
Oracle XML DB must be installed for full development environment (not for runtime only installations)

The four primary user roles are

Instance adminstrators	the Superusers
Worskspace adminsitrators	perform task that are specific to a workspace
Developers	create applications
Users	consume the applications

Web server

APEX offers its functionality over a web server, for example over Oracle REST Data Services.

Oracle REST Data Services

The default context root for accessing Oracle Application Express through Oracle REST Data Services is /ords.

Installation

$ORACLE_HOME/apex, especially the scripts

User Accounts

The APEX related accounts are created when $ORACLE_HOME/apex/apexins.sql is executed. These accounts are:

`APEX_vvvxxx`
`FLOW_FILES`
`APEX_PUBLIC_USER`
`APEX_INSTANCE_ADMIN_USER`

C:/Oracle/19/apex/apex_rest_config.sql also configures RESTful web services and creates two additional user accounts:

`APEX_REST_PUBLIC_USER`	is used for the execution of resource templates or APEX sessions.
`APEX_LISTENER`	is used by Oracle REST Data Services to access the schema objects in the `APEX_XXXXXX` schema containing resource templates and OAuth data. This uses is not used for execution of resource templates or APEX sessions.

APEX_PUBLIC_USER

apexins.sql creates APEX_PUBLIC_USER user with a random password. So, this password needs to be changed.

alter user APEX_PUBLIC_USER identified by apexSecret;

Release numbers

Starting in 2018, APEX release numbers correspond to the year in which a version was released.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1745355425, '160.79.108.195', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/Application-Express/index(103): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78