4.3 Installing Application Express into Different PDBs
You can install different versions of Oracle Application Express into different PDBs.
Providing Application Express is not installed in the container database, you can
install a local Application Express within each PDB as required.
When Application Express is installed locally there are no
Application Express metadata linked objects and all packages,
views, and tables are created within the
APEX_200100
schema, within each PDB
where Application Express is installed.
- Uninstalling Application Express from a CDB
Learn how to uninstall Application Express from a CDB. - Installing Application Express Locally in a PDB
Learn how to install Application Express locally in a PDB. - Installing Application Express into a CDB
4.3.1 Uninstalling Application Express from a CDB
Learn how to uninstall Application Express from a CDB.
To uninstall Oracle Application Express from a CDB:
Note:
Installing or removing Application Express from a CDB requires a local connection to the database.
This section describes removing Application Express from a CDB. If you wish to remove
Oracle Application Express from the CDB that shipped with Oracle Database 12.1,
you should use apxremov_con.sql
from either
$ORACLE_HOME/apex
, or from a 4.2.6 APEX distribution.
Parent topic: Installing Application Express into Different PDBs
4.3.2 Installing Application Express Locally in a PDB
Learn how to install Application Express locally in a PDB.
Once you have removed Application Express from the container database by following the instructions in "Uninstalling Application Express from a CDB," you can install Application Express locally in a PDB.
To install Application Express locally in a PDB:
Note:
Oracle Database SQL Language Reference for more information about SQL*Plus
When Application Express installs, it creates the following database accounts:
-
APEX_200100
- This account owns the Application Express schema and metadata. -
FLOWS_FILES
- This account owns the Application Express uploaded files. -
APEX_PUBLIC_USER
- This minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server andmod_plsql
. -
APEX_INSTANCE_ADMIN_USER
- A minimally privileged account used for the REST Administration Interface.Tip:
To learn more about the REST Administration Interface, see "About the REST Administration Interface" in Oracle Application Express Administration Guide
If you configured RESTful Web services, then these additional accounts are created:
-
APEX_REST_PUBLIC_USER
- The account used when invoking RESTful Services definitions stored in Application Express. -
APEX_LISTENER
- The account used to query RESTful Services definitions stored in Application Express.
See Also:
Parent topic: Installing Application Express into Different PDBs
4.3.3 Installing Application Express into a CDB
To install Application Express into a CDB:
Note:
Installing or removing Application Express from a CDB requires a local connection to the database.
When Application Express installs, it creates the following database accounts:
-
APEX_200100
- This account owns the Application Express schema and metadata. -
FLOWS_FILES
- This account owns the Application Express uploaded files. -
APEX_PUBLIC_USER
- This minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server andmod_plsql
. -
APEX_INSTANCE_ADMIN_USER
- A minimally privileged account used for the REST Administration Interface.Tip:
To learn more about the REST Administration Interface, see "About the REST Administration Interface" in Oracle Application Express Administration Guide
If you configured RESTful Web services, then these additional accounts are created:
-
APEX_REST_PUBLIC_USER
- The account used when invoking RESTful Services definitions stored in Application Express. -
APEX_LISTENER
- The account used to query RESTful Services definitions stored in Application Express.
See Also:
- "Using SQL*Plus" in SQL*Plus User's Guide and Reference
-
"Installing Application Express and Configuring Oracle REST Data Services"
-
"Installing Application Express and Configuring Web Listener - Embedded PL/SQL Gateway (Deprecated)"
-
"Installing Application Express and Configuring Legacy Web Listener – Oracle HTTP Server (Deprecated)"
Parent topic: Installing Application Express into Different PDBs