The Oracle APEX Guide Oracle Apex Guide RSS Feed
*
Accessibility

Background

How to Install or Update Oracle XE APEX

If you have installed Oracle XE (msi file: OracleXE.exe) then you can upgrade to the latest Oracle Apex version using the steps below.

 

Step 1 Unzip Apex

You should have a directory structure similar to this:

c:\oraclexe\apex (this is the unzipped Apex kit)
c:\oraclexe\app (this is created by the Oracle XE installation)

Open DOS CMD window and change default to the directory of the unzipped Apex kit.

cd c:\oraclexe\apex

Step 2 - Install or Upgrade Apex

sqlplus system/password as sysdba
@apexins SYSAUX SYSAUX TEMP /i/

Step 3 - Set images directory

sqlplus system/password as sysdba
@apxldimg.sql c:\oraclexe

Step 4 - Configure Apex

Set passwords

@apxchpwd.sql

@apex_rest_config.sql

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
alter user APEX_PUBLIC_USER identified by My_Public_Password;

@apex_epg_config.sql c:\oraclexe

Step 5 - Enable remote http connections (or use ORDS Listener)

exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);
exec dbms_xdb.sethttpport('8080');
select dbms_xdb.gethttpport from dual;

Step 6 - Grant ACLs

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;

Step 7 - Set up Workspaces, Schemas and Developer Accounts

URL: http://127.0.0.1:8080/apex
Workspace: Internal
Username: Admin
Password: password

Step 8 - Create database Links (optional)

To connect to remote databases or set up materialized views

SQL> grant create database link to schema_name;

Step 9 - Increase XE process and session limits (optional)

SQL>
show parameter sessions;
alter system set processes=300 scope=spfile;
show parameter processes;
alter system set sessions=300 scope=spfile;

© RuleWorks - All Rights Reserved - Policy - - Sitemap