APEX 5 Installation Steps:

Open Command prompt and navigate to APEX software folder

Step 1: Enter “sqlplus / as sysdba” to login as SYS user
Step 2: Enter “@apexins sysaux sysaux temp /i/”
Step 3: Verify the SYS db connection and if it was exited relogin
with Step 1 info.
Step 4: Enter “@apxldimg
C:\app\chandra\product\12.1.0\dbhome_2” (D is the drive of
apex software)
Step 5: Enter “@apxconf”
In this step, PORT number will be prompted with 8080 and
press enter.
It will wait for ADMIN user name and if you press enter
ADMIN will be the user name considered.
It will ask for ADMIN email and go ahead with clicking on
enter.
Enter the password for ADMIN access.
Step 6: Open the URL http://localhost:8080/apex and it will
prompt for User credentials.
Step 7: Open command prompt and execute below commands
 alter user apex_public_user account unlock;
alter user anonymous account unlock;
Step 8: Perform Step6 again and you should be able to login.

Thank you for installing Oracle Application Express 5.0.3.00.03

Oracle Application Express is installed in the APEX_050000 schema.

The structure of the link to the Application Express administration services is

as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)

http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embed

ded PL/SQL gateway)

http://host:port/apex/apex_admin (Oracle REST Data Services)

The structure of the link to the Application Express development interface is as

follows:

http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)

http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL

gateway)

http://host:port/apex (Oracle REST Data Services)

Oracle Application Express (APEX) 5.0

Installation
This procedure should be followed for new installations and upgrades
affecting the first two numbers of the version (4.2 to 5.0) are done by
doing a full installation. If the first two numbers of the version are not
affected (5.0.0 to 5.0.1) you must download and apply a patch, rather
than do the full installation.

If you are using the multitenant architecture in Oracle 12c, you should
read this article before you continue.
 Setup
 Installation

 Embedded PL/SQL Gateway (EPG) Configuration

 OHS Configuration

 Network ACLS

Related articles.

 Oracle Application Express (APEX) 4.2 Installation

  Oracle Application Express (APEX) Patches

 Multitenant : Uninstall APEX from the CDB in Oracle Database 12c

Release 1 (12.1)

 Oracle REST Data Services (ORDS) 3.0 Installation on Tomcat 7

Setup
Download the APEX software.

 http://www.oracle.com/technetwork/developer-
tools/apex/downloads/index.html

Unzip the software either on your client PC, if you intend to install it
from there using the SQL*Plus client on your PC, or on the database
server if you intend to install it from there. The latter will be more
efficient as you will reduce the network traffic between the SQL*Plus
client and the database server.

Create a new tablespace to act as the default tablespace for APEX.

CREATE TABLESPACE apex DATAFILE SIZE 10M AUTOEXTEND ON NEXT 1M;

Installation
Change directory to the directory holding the unzipped APEX software.

$ cd /home/oracle/apex

Connect to SQL*Plus as the SYS user and run the "apexins.sql" script,
specifying the relevant tablespace names and image URL.

SQL> CONN sys@pdb1 AS SYSDBA

SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp
images
SQL>
SQL> @apexins.sql APEX APEX TEMP /i/
Once complete, change the admin password by running the
"apxchpwd.sql" scripts as the SYS user.

SQL> CONN sys@pdb1 AS SYSDBA

SQL> @apxchpwd.sql

Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the

"apex_rest_config.sql" script.

SQL> CONN sys@pdb1 AS SYSDBA

SQL> @apex_rest_config.sql

Embedded PL/SQL Gateway (EPG) Configuration

Run the "apex_epg_config.sql" script, passing in the base directory of
the installation software as a parameter.

SQL> CONN sys@pdb1 AS SYSDBA

SQL> @apex_epg_config.sql /home/oracle

Unlock the ANONYMOUS account.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

If this is an upgrade to an existing APEX installation, you will also have

to run the following script, to update the images.

SQL> @apxldimg.sql /home/oracle

Check the port setting for XML DB Protocol Server.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
0
1 row selected.

SQL>

If it is set to "0", you will need to set it to a non-zero value to enable it.

SQL> EXEC DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL>

APEX should now be available from a URL like

"http://machine:port/apex".

OHS Configuration
Change the password and unlock the APEX_PUBLIC_USER account. This will
be used for any Database Access Descriptors (DADs).

SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY myPassword ACCOUNT UNLOCK;

If you don't want the password to expire you will need to create a new
profile with password expiration disabled and assign it to the user.

Create a DAD in the OHS:

 Log into EM (http://server:port/em)

 From the tree select "Farm_DomainName > Web Tier > ohs1"

 On the resulting page select "Oracle HTTP Server > Administration >
Advanced Configuration"

 From the dropdown list slect "dads.conf" and click the "Go" button.
  Edit the "dads.conf" file, adding an entry like that shown below, then
click the "Apply" button.

 <Location /apex>
 Order deny,allow
 PlsqlDocumentPath docs
 AllowOverride None
 PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
 PlsqlDatabaseConnectString pdb1 TNSFormat
 PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
 PlsqlAuthenticationMode Basic
 SetHandler pls_handler
 PlsqlDocumentTablename wwv_flow_file_objects$
 PlsqlDatabaseUsername APEX_PUBLIC_USER
 PlsqlDefaultPage apex
 PlsqlDatabasePassword myPassword
 PlsqlRequestValidationFunction
wwv_flow_epg_include_modules.authorize
 PlsqlPathAlias r
 PlsqlPathAliasProcedure wwv_flow.resolve_friendly_url
 Allow from all

</Location>

 Select the "Oracle HTTP Server > Control > Restart" option.
 Click the resulting "Restart" button.

 Once restarted, click the "Close" button.

Alternatively, edit the "dads.conf" file directly. For the OHS that comes
with Forms and Reports Services, this is located here
"$FR_INST/config/OHS/ohs1/mod_plsql/dads.conf". Once amended,
remember to restart the HTTP server.
$ $FR_INST/bin/opmnctl restartproc process-type=OHS

Copy the APEX images to your Oracle HTTP Server.

$ cp -R /tmp/apex/images $FR_INST/config/OHS/ohs1/htdocs/apex_images

Make them available from the "/i/" alias by adding the following alias to
the virtual host defined in the "ssl.conf" or "httpd.conf" file in the
"$FR_INST/config/OHS/ohs1" directory.

Alias /i/
"/u01/app/oracle/middleware/FR_inst/config/OHS/ohs1/htdocs/apex_images/"

APEX should now be available from a URL like

"http://machine:port/apex".

Network ACLS
If your APEX installation needs to contact other servers on the
network, you will need to create the appropriate ACLs to allow account
to the network services. This is discussed here.

For more information see:

 Application Express Documentation Release 5.0

 Oracle Application Express Installation Guide Release 5.0

 Oracle Application Express (APEX) 4.2 Installation

 Oracle Application Express (APEX) Patches

 Fine-Grained Access to Network Services in Oracle Database 11g

Release 1

 Multitenant : Uninstall APEX from the CDB in Oracle Database 12c

Release 1 (12.1)

 Oracle REST Data Services (ORDS) 3.0 Installation on Tomcat 7

Hope this helps. Regards Tim...

11. Re: New to APEX - Installation APEX 5.0 failure
1015566 Apr 19, 2015 8:40 PM (in response to fxmatz)

You shoul unzip your files under $ORACLE_HOME/[dbhome_1]

e.g. /u01/app/oracle/product/11.2.0/dbhome_1
After than unzip into apex directory all files from package
/u01/app/oracle/product/11.2.0/dbhome_1/apex

After that you start as sysdba

@apexins.sql APEX_SPACE APEX_SPACE TEMP /i/;

@apxldimg.sql;
1:/u01/app/oracle/product/11.2.0/dbhome_1
Hier is small bug in script- you should give not path to apex - give path to
e.g. /u01/app/oracle/product/11.2.0/dbhome_1

@apxconf.sql;

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER APEX_050000 ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

http://rac1.localdomain:8080/apex

Apex Admin User Password : Dhanavtl;12#