Oracle apex установка linux
Learn about downloading and installing Oracle Application Express.
How you install Oracle Application Express depends upon by the type of database you into which you are installing. This section describes how to download and install Oracle Application Express.
- Installing Application Express
Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page. - Creating or Updating Your Instance Administration Account
Learn how to create or update Instance Administrator account. - Restarting Processes
Restart the processes that you stopped before you began the installation. - Configuring the APEX_PUBLIC_USER Account
It is important to correctly configure the APEX_PUBLIC_USER account to enable proper operation of Oracle Application Express. - Configuring RESTful Services
In a new installation of Oracle Application Express, you must run the configuration script apex_rest_config.sql to configure RESTful Services.
5.2.1 Installing Application Express
Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.
To install Oracle Application Express:
- For installations where the development will be in English only, download the file apex_20.2_en.zip from the Oracle Application Express download page. If the development will include languages other than English, download apex_20.2.zip from the Oracle Application Express download page. See:
https://www.oracle.com/tools/downloads/apex-downloads.html Note that the actual file name may differ if a more recent release has shipped since this document was published.
- If English only, unzip apex_20.2_en.zip as follows, preserving directory names:
- UNIX and Linux: $ unzip apex_20.2_en.zip
- Windows: Double click the file apex_20.2_en.zip in Windows Explorer
- If multiple languages, unzip apex_20.2.zip as follows, preserving directory names:
- UNIX and Linux: $ unzip apex_20.2.zip
- Windows: Double click the file apex_20.2.zip in Windows Explorer
You should keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to C:\TEMP .
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
$ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password- Full development environment . Run apexins.sql passing the following four arguments in the order shown:
@apexins.sql tablespace_apex tablespace_files tablespace_temp images
- tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
- tablespace_files is the name of the tablespace for the Oracle Application Express files user.
- tablespace_temp is the name of the temporary tablespace or tablespace group.
- images is the virtual directory for Oracle Application Express images. For installations using EPG, /i/ is the required value for the images argument. To support future Oracle Application Express upgrades, define the virtual image directory as /i/ .
@apexins.sql SYSAUX SYSAUX TEMP /i/
If you receive the following error, exit SQL*Plus and change your working directory to where you unzipped the installation file, for example C:\TEMP in Windows, before starting SQL*Plus:
SP2-0310: unable to open file «apexins.sql «
@apxrtins.sql tablespace_apex tablespace_files tablespace_temp images
- tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
- tablespace_files is the name of the tablespace for the Oracle Application Express files user.
- tablespace_temp is the name of the temporary tablespace or tablespace group.
- images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/ .
@apxrtins.sql SYSAUX SYSAUX TEMP /i/
When Application Express installs, it creates the following database accounts:
- APEX_200200 — 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 and mod_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 will be created:
- APEX_REST_PUBLIC_USER — The account used when invoking RESTful Services definitions stored in Oracle Application Express.
- APEX_LISTENER — The account used to query RESTful Services definitions stored in Oracle Application Express.
If you are upgrading from a previous release, then FLOWS_FILES already exists and APEX_PUBLIC_USER is created if it does not already exist.
- «Configuring Password Protection» in Oracle Database Security Guide
- «About the Oracle Application Express Runtime Environment»
- » SQL*Plus User’s Guide and Reference » for more information about SQL*Plus
- Oracle Application Express must be installed from a writable directory on the file system. See «Reviewing a Log of an Installation Session»
Oracle apex установка linux
Learn about downloading and installing Oracle APEX .
How you install Oracle APEX depends upon by the type of database into which you are installing. This chapter describes how to download and install Oracle APEX in self-managed databases, such as your laptop or your data center, or co-managed Cloud databases such as Database Cloud Service (DBaaS) and Exadata Cloud Service.
In fully managed Cloud databases, such as an Autonomous Database or Oracle APEX Application Development ( APEX Service ), APEX is pre-installed and pre-configured, so you may skip the steps listed in this chapter. To learn more, refer to the documentation for your service.
- Installing APEX
Install Oracle APEX by downloading a ZIP file from the APEX download page. - Creating or Updating Your Instance Administration Account
Learn how to create or update Instance Administrator account. - Restarting Processes
Restart the processes that you stopped before you began the installation. - Configuring the APEX_PUBLIC_USER Account
It is important to correctly configure the APEX_PUBLIC_USER account to enable proper operation of Oracle APEX . - Configuring RESTful Services
In a new installation of Oracle APEX , you must run the configuration script apex_rest_config.sql to configure RESTful Services.
- Welcome to Oracle APEX Application Development Service in Getting Started with Oracle APEX Application Development
- Creating Applications with Oracle Application Express on Autonomous Database in Using Oracle Autonomous Database on Shared Exadata Infrastructure
- Utilizing the Multitenant Architecture in Oracle Database 12c or Later
6.3.1 Installing APEX
Install Oracle APEX by downloading a ZIP file from the APEX download page.
APEX must be installed from a writable directory on the file system. See Reviewing a Log of an Installation Session.
- For installations where the development will be in English only, download the file apex_ 22.2 _en.zip from the APEX download page. If the development will include languages other than English, download apex_ 22.2 .zip from the APEX download page. See:
https://www.oracle.com/tools/downloads/apex-downloads.html Note that the actual file name may differ if a more recent release has shipped since this document was published.
- If English only, unzip apex_ 22.2 _en.zip as follows, preserving directory names:
- UNIX and Linux: $ unzip apex_ 22.2 _en.zip
- Windows: Double click the file apex_ 22.2 _en.zip in Windows Explorer
- If multiple languages, unzip apex_ 22.2 .zip as follows, preserving directory names:
- UNIX and Linux: $ unzip apex_ 22.2 .zip
- Windows: Double click the file apex_ 22.2 .zip in Windows Explorer
You should keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to C:\TEMP .
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password$ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password- Full development environment . Run apexins.sql passing the following four arguments in the order shown:
@apexins.sql tablespace_apex tablespace_files tablespace_temp images- tablespace_apex is the name of the tablespace for the APEX application user.
- tablespace_files is the name of the tablespace for the APEX files user.
- tablespace_temp is the name of the temporary tablespace or tablespace group.
- images is the virtual directory for APEX images. For installations using EPG, /i/ is the required value for the images argument. To support future APEX upgrades, define the virtual image directory as /i/ .
@apexins.sql SYSAUX SYSAUX TEMP /i/If you receive the following error, exit SQL*Plus and change your working directory to where you unzipped the installation file, for example C:\TEMP in Windows, before starting SQL*Plus:
SP2-0310: unable to open file «apexins.sql»
@apxrtins.sql tablespace_apex tablespace_files tablespace_temp images- tablespace_apex is the name of the tablespace for the APEX application user.
- tablespace_files is the name of the tablespace for the APEX files user.
- tablespace_temp is the name of the temporary tablespace or tablespace group.
- images is the virtual directory for APEX images. To support future APEX upgrades, define the virtual image directory as /i/ .
@apxrtins.sql SYSAUX SYSAUX TEMP /i/When APEX installs, it creates the following database accounts:
- APEX_220200 — This account owns the APEX schema and metadata.
- FLOWS_FILES — This account owns the APEX uploaded files.
- APEX_PUBLIC_USER — This minimally privileged account is used for APEX configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql .
If you configured RESTful Web services, then these additional accounts will be created:
- APEX_REST_PUBLIC_USER — The account used when invoking RESTful Services definitions stored in APEX .
- APEX_LISTENER — The account used to query RESTful Services definitions stored in APEX .
If you are upgrading from a previous release, then FLOWS_FILES already exists and APEX_PUBLIC_USER is created if it does not already exist.