Installing and Configuring APEX in Oracle Database

Unpack the archive with Apex 5.0 to a folder on the disk, for example /u01/distr/apex

cd /u01/distr/apex

sqlplus / as sysdba

--when OMF is on

sql> create tablespace apex;

p.s.: After executing each command, it is recommended to disconnect from the database and connect again

--Set port to 0

sql>EXEC DBMS_XDB.SETHTTPPORT(0);

--Install Apex itself

sql>@apexins APEX APEX TEMP /i/

--Set a password for the administrator account

sql>@apxchpwd

--Configuring

sql>@apex_epg_config /u01/distr

--Unblock user anonymous

sql>ALTER USER ANONYMOUS ACCOUNT UNLOCK;

--Loading pictures

sql>@apxldimg.sql /u01/distr

--Set the desired port

sql>EXEC DBMS_XDB.SETHTTPPORT(8080);

We allow the network service to work

DECLARE

ACL_PATH VARCHAR2(4000);

BEGIN

-- Look for the ACL currently assigned to '*' and give APEX_050000

-- the "connect" privilege if APEX_050000

--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_050000',

'connect') IS NULL THEN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,

'APEX_050000', 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_050000', TRUE, 'connect');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');

END;

/

COMMIT;

--Configuring database parameters

sql>ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20 SCOPE = BOTH;

sql>ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;

--Checking what happened

http://hostname:port/apex/apex_admin

--Current port number

SELECT dbms_xdb.gethttpport FROM dual