[APEX] Installation Oracle Application Express 4.2 using Embeded PLSQL Gateway

Download and Install Oracle Application Express

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

> unzip apex_4.2.zip> sqlplus "/as sysdba"SQL> @apexins.sql  SYSAUX SYSAUX TEMP /i/    (Full: @apexins.sql tablespace_apex tablespace_files tablespace_temp images)SQL> @apxrtins.sql SYSAUX SYSAUX TEMP /i/    (Runtime: @apxrtins.sql tablespace_apex tablespace_files tablespace_temp images)

Change the Password for the ADMIN Account

SQL> @apxchpwd.sql

Configure the Embeded PL/SQL Gateway

SQL> @apex_epg_config.sql c:\Oracle\app\oracle\product\11.2.0\server
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

Verifying the Oracle XML DB Protocol Server Port

SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
=> 8080

  

Enabling Oracle XML DB Protocol Server

SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);

  

Enable Network Services in Oracle Database 11g

DECLARE

  ACL_PATH  VARCHAR2(4000);

BEGIN

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

  -- the "connect" privilege if APEX_040200 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_040200', 'connect') IS NULL THEN

      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 'APEX_040200', 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_040200', TRUE, 'connect');

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

END;

/

COMMIT;

DECLARE

  ACL_PATH  VARCHAR2(4000);

BEGIN

  -- Look for the ACL currently assigned to 'localhost' and give APEX_040200

  -- the "connect" privilege if APEX_040200 does not have the privilege yet.

  SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS

   WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;

   

  IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200', 'connect') IS NULL THEN

      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 'APEX_040200', TRUE, 'connect');

  END IF;

EXCEPTION

  -- When no ACL has been assigned to 'localhost'.

  WHEN NO_DATA_FOUND THEN

  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml', 'ACL that lets users to connect to localhost', 'APEX_040200', TRUE, 'connect');

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');

END;

/

COMMIT;

  

Installing a Translated Version of Oracle Application Express

> set NLS_LANG=American_America.AL32UTF8
> sqlplus "/as sysdba"SQL> @load_trans.sql ko

or

> set NLS_LANG=American_America.AL32UTF8> sqlplus "/as sysdba"SQL> alter session set current_schema = APEX_040200;SQL> @builder/ko/load_ko.sql

Configuring the SHARED_SERVERS Parameter

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

  

Connect to APEX

http://localhost:8080/apexhttp://localhost:8080/apex/apex_admin

---

References

http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm