1- After download the apex_20.1.zip file extract the contents to c:\apex201\apex folder.
2- Open cmd and go inside this path C:\apex201\apex
3- Connect as sys user: sqlplus / as sysdba
4- After connecting to sqlplus run the installation script: @apexins.sql SYSAUX SYSAUX TEMP /i/
At the end of the script you will receive as below output:
Oracle Application Express is installed in the APEX_200100 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 embedded 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)
timing for: Phase 3 (Switch)
Elapsed: 00:01:35.41
timing for: Complete Installation
Elapsed: 00:23:58.38
PL/SQL procedure successfully completed.
1 row selected.
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
C:\apex201\apex>
5- Connect again as sys user: sqlplus / as sysdba
6- After connecting to sqlplus run the installation script: @apxchpwd.sql, provide instance admin password:
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.
7- Connect again as sys user: sqlplus / as sysdba and run script
@apex_epg_config.sql C:\apex201
8- Unlock users users by run below scripts:
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Tahaluf_123;
9- Configure Apex RESTful Services, run and provide passwords:
@apex_rest_config.sql
10- Set the http port:
EXEC DBMS_XDB.SETHTTPPORT(9191);
11- Run below script to configure ACL Prior to Oracle Database 12c database:
/* Then run the below script */
Declare
acl_path Varchar2(4000);
Begin
-- Look for the ACL currently assigned to '*' and give APEX_200100
-- the "connect" privilege if APEX_200100 does not have the privilege yet.
Select
acl
Into acl_path
From
dba_network_acls
Where
host = '*'
And lower_port Is Null
And upper_port Is Null;
If dbms_network_acl_admin.check_privilege(acl_path, 'APEX_200100', 'connect') Is Null Then
dbms_network_acl_admin.add_privilege(acl_path, 'APEX_200100', true, 'connect');
End If;
Exception
-- When no ACL has been assigned to '*'.
When no_data_found Then
dbms_network_acl_admin.create_acl('power_users.xml', 'ACL that lets power users to connect to everywhere', 'APEX_200100',
true, 'connect');
dbms_network_acl_admin.assign_acl('power_users.xml', '*');
End;
/
Commit;
for Oracle Database 12c or later run the following script:
/* Then execute the below script */
Begin
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_200100',
principal_type => xs_acl.ptype_db));
End;
/
11- Access using the url http://localhost:8181/apex/apex_admin
12 - Execute the following as sys user:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER ANONYMOUS IDENTIFIED BY Tahaluf_123;
