<\/p>\n
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.<\/p>\n
First, tablespaces are created:<\/p>\n
CREATE TABLESPACE APEX DATAFILE '+DATA\/orcl\/DATAFILE\/apex01.dbf'\r\nSIZE 500M\r\nEXTENT MANAGEMENT LOCAL\r\nSEGMENT SPACE MANAGEMENT AUTO;\r\nCREATE TABLESPACE APEX_FILES DATAFILE '+DATA\/orcl\/DATAFILE\/apex_files01.dbf'\r\nSIZE 100M\r\nEXTENT MANAGEMENT LOCAL\r\nSEGMENT SPACE MANAGEMENT AUTO;<\/pre>\n<\/p>\n
Then, creating the APEX_IMAGES virtual directory.<\/p>\n
If the database is RAC, the physical directory is being created on all servers.<\/p>\n
bash-3.00$ mkdir \/oracle\/apex\r\nbash-3.00$ cd \/oracle\/apex\r\nbash-3.00$ mkdir apex_images\r\n\r\nSQL > CREATE OR REPLACE DIRECTORY\r\nAPEX_IMAGES\u00a0 AS\r\n'\/oracle\/apex\/apex_images';<\/pre>\n<\/p>\n
We give privileges to the virtual directory.<\/p>\n
SQL>GRANT READ, WRITE ON DIRECTORY\u00a0 APEX_IMAGES TO SYSTEM WITH GRANT OPTION;<\/pre>\n<\/p>\n
Installation:<\/strong><\/p>\n
SQL> @apexins APEX APEX_FILES TEMP \/APEX_IMAGES\/;<\/pre>\n<\/p>\n
You can log in with admin login information from the following addresses to manage after installation.<\/p>\n
http: \/\/ sunucu_ip: 7777 \/ pls \/ apex
\nhttp: \/\/ sunucu_ip: 7777 \/ pls \/ apex \/ apex_adm the<\/p>\nYou should check the HTTP Port.<\/p>\n
SQL> select DBMS_XDB.GETHTTPPORT() from dual;\r\n\r\nDBMS_XDB.GETHTTPPORT()\r\n----------------------\r\n0<\/pre>\n<\/p>\n
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.<\/p>\n
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);<\/pre>\n<\/p>\n
Then, when we query APEX from dba_registry, the status must be VALID.<\/p>\n
SQL> select status from dba_registry where comp_id = 'APEX';\r\n\r\nSTATUS\r\n-----------\r\nVALID<\/pre>\n<\/p>\n
You must add alias in Apache configuration files.<\/p>\n
\/oracle\/product\/10.2.0\/companion\/Apache\/Apache\/conf\/httpd.conf<\/pre>\n<\/p>\n
In the above file, alias should be added in the following section.<\/p>\n
ServerSignature On\r\n\r\n#\r\n# Aliases: Add here as many aliases as you need (with no limit). The format is\r\n# Alias fakename realname\r\n#\r\n<IfModule mod_alias.c>\r\n\r\n#\r\n# Note that if you include a trailing \/ on fakename then the server will\r\n# require it to be present in the URL.\u00a0 So \"\/icons\" isn't aliased in this\r\n# example, only \"\/icons\/\"..\r\n#\r\nAlias \/APEX_IMAGES\/ \"\/oracle\/apex\/apex_images\/\"\r\n.<\/pre>\n<\/p>\n
“\/oracle\/product\/10.2.0\/companion\/Apache\/modplsql\/conf\/dads.conf” file must have an output similar to the following.<\/p>\n
# ============================================================================\r\n#\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0mod_plsql DAD Configuration File\r\n# ============================================================================\r\n# 1. Please refer to dads.README for a description of this file\r\n# ============================================================================\r\n\r\n# Note: This file should typically be included in your plsql.conf file with\r\n# the \"include\" directive.\r\n\r\n# Hint: You can look at some sample DADs in the dads.README file\r\n\r\n# ============================================================================\r\n\r\nAlias \/APEX_IMAGES\/ \"\/oracle\/apex\/apex_images\/\"\r\nAddType text\/xml xbl\r\nAddType text\/x-component htc\r\n\r\n<Location \/pls\/apex>\r\nOrder deny,allow\r\nPlsqlDocumentPath docs\r\nAllowOverride None\r\nPlsqlDocumentProcedure wwv_flow_file_mgr.process_download\r\nPlsqlDatabaseConnectString orcl1:1521:ORCL ServiceNameFormat\r\nPlsqlNLSLanguage AMERICAN_AMERICA.WE8ISO8859P9\r\nPlsqlAuthenticationMode Basic\r\nSetHandler pls_handler\r\nPlsqlDocumentTablename wwv_flow_file_objects$\r\nPlsqlDatabaseUsername APEX_PUBLIC_USER\r\nPlsqlDefaultPage apex\r\nPlsqlDatabasePassword oracle123\r\nAllow from all\r\n<\/Location><\/pre>\n\n<\/div>\n