Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
I tried to explain the apex installation step by step. Ensure that the Oracle Text component is also installed before you begin the installation. APEX needs this component.
First, tablespaces are created:
1 2 3 4 5 6 7 8 | CREATE TABLESPACE APEX DATAFILE '+DATA/orcl/DATAFILE/apex01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE APEX_FILES DATAFILE '+DATA/orcl/DATAFILE/apex_files01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; |
Then, creating the APEX_IMAGES virtual directory.
If the database is RAC, the physical directory is being created on all servers.
1 2 3 4 5 6 7 | bash-3.00$ mkdir /oracle/apex bash-3.00$ cd /oracle/apex bash-3.00$ mkdir apex_images SQL > CREATE OR REPLACE DIRECTORY APEX_IMAGES AS '/oracle/apex/apex_images'; |
We give privileges to the virtual directory.
1 | SQL>GRANT READ, WRITE ON DIRECTORY APEX_IMAGES TO SYSTEM WITH GRANT OPTION; |
Installation:
1 | SQL> @apexins APEX APEX_FILES TEMP /APEX_IMAGES/; |
You can log in with admin login information from the following addresses to manage after installation.
http: // sunucu_ip: 7777 / pls / apex
http: // sunucu_ip: 7777 / pls / apex / apex_adm the
You should check the HTTP Port.
1 2 3 4 5 | SQL> select DBMS_XDB.GETHTTPPORT() from dual; DBMS_XDB.GETHTTPPORT() ---------------------- 0 |
Oracle XML DB HTTP Server is not enabled if the query returns 0 (zero). In this case, we are assigning ports with the following query.
1 | SQL> EXEC DBMS_XDB.SETHTTPPORT(8080); |
Then, when we query APEX from dba_registry, the status must be VALID.
1 2 3 4 5 | SQL> select status from dba_registry where comp_id = 'APEX'; STATUS ----------- VALID |
You must add alias in Apache configuration files.
1 | /oracle/product/10.2.0/companion/Apache/Apache/conf/httpd.conf |
In the above file, alias should be added in the following section.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | ServerSignature On # # Aliases: Add here as many aliases as you need (with no limit). The format is # Alias fakename realname # <IfModule mod_alias.c> # # Note that if you include a trailing / on fakename then the server will # require it to be present in the URL. So "/icons" isn't aliased in this # example, only "/icons/".. # Alias /APEX_IMAGES/ "/oracle/apex/apex_images/" . |
“/oracle/product/10.2.0/companion/Apache/modplsql/conf/dads.conf” file must have an output similar to the following.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | # ============================================================================ # mod_plsql DAD Configuration File # ============================================================================ # 1. Please refer to dads.README for a description of this file # ============================================================================ # Note: This file should typically be included in your plsql.conf file with # the "include" directive. # Hint: You can look at some sample DADs in the dads.README file # ============================================================================ Alias /APEX_IMAGES/ "/oracle/apex/apex_images/" AddType text/xml xbl AddType text/x-component htc <Location /pls/apex> Order deny,allow PlsqlDocumentPath docs AllowOverride None PlsqlDocumentProcedure wwv_flow_file_mgr.process_download PlsqlDatabaseConnectString orcl1:1521:ORCL ServiceNameFormat PlsqlNLSLanguage AMERICAN_AMERICA.WE8ISO8859P9 PlsqlAuthenticationMode Basic SetHandler pls_handler PlsqlDocumentTablename wwv_flow_file_objects$ PlsqlDatabaseUsername APEX_PUBLIC_USER PlsqlDefaultPage apex PlsqlDatabasePassword oracle123 Allow from all </Location> |
