apex installation on linux

APEX installation on Linux - Step by Step

Here the step by stepforAPEXinstallation on Linux.

You can download the latestApexversion from: http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

1. Copy the apex_4.2.2_en.zip to /home/oracle

cp apex_4.2.2_en.zip /home/oracle

2. Extract apex_4.2.2_en.zip : cd /home/oracle; unzip apex_4.2.2_en.zip;cd /home/oracle/apex

3. Create a new tablespace for Apex objects:

Sqlplus /nologs

create TABLESPACE APEX

DATAFILE '/full_path_for_data_directory/apex01.dbf' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE 8000M;

4. Start APEX installation: sqlplus sys as sysdba

@apexins.sql APEX APEX TEMP /i/

5. Change ADMIN account password:

sqlplus sys as sysdba

@apxchpwd.sql

*** The password mst contait least one punctuation character: (!”#$%&()“*+,-/:;?_).

6. Run the Embedded @apex_epg_config.sql /home/oracle(full path)

Update the APEX images with those from the new release:

sqlplus sys as svadba

@apxldimg.sql /home/oracle (full path)

8. Make sure that the following accounts are unlocked and not expired:

If EXPIRED - Change password for following users : ANONYMOUS,XDB,APEX_PUBLIC_USER,FLOWS_FILES,APEX_040200. IF LOCKED - Unlock: ALTER USER ANONYMOUS ACCOUNT UNLOCK; ALTER USER XDB ACCOUNT UNLOCK; ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER FLOWS_FILES ACCOUNT UNLOCK; ALTER USER APEX_040200 ACCOUNT UNLOCK;

9. Enable network services (ACL) and XML DB HTTP server:

sqlplus sys as sysdba

exec dbms_xdb.sethttpport(8080);

Verify the port:

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

10. Enable remote HTTP connections: sqlplus sys as sysdba

exec dbms_xdb.setlistenerlocalaccess(l_access => false);

11. Grant connect privileges to any host for the APEX_040200 database user:

sqlplus sys as sysdba

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;

run also the following command:

Alter system set shared_servers=20;

*add shared_servers=20 scope=boths;

12. Check that Apex was installed:

SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX'; COMP_NAME VERSION STATUS ------------------------------ ------------------------------ ----------- Oracle Application Express 4.2.2.00.11 VALID

13. Login first time.

You will be asked to change ADMIN password:

http://localhost:8080/apex/apex_admin

14. Workspace login page: http://localhost:8080/apex

Workspace: INTERNAL

Username: ADMIN