top of page
  • Admin

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


48 views0 comments

Recent Posts

See All

Comments


bottom of page