APEX installation on Linux - apex_4.2.5.zip

APEX installation on Linux - Step by Step



1. Download the Apex latest version(apex_4.2.5.zip).


2. Copy apex_4.2*.zip to Linux server (/u01/APEX)


3. Unzip apex_4.2*.zip :

Create the Tablespace for APEX :


CREATE TABLESPACE apex DATAFILE '/u01/apex/oradata/apexdev/apex01.dbf' SIZE 400M AUTOEXTEND ON NEXT 1M;

4. Start APEX installation:

sqlplus "/as sysdba"

SQL > @apexins.sql APEX APEX TEMP /i/



5. Change ADMIN account password:

sqlplus "/as sysdba"

SQL > @apxchpwd.sql

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

6. Run the Embedded PL/SQL Gateway configuration (EPG):

sqlplus "/as sysdba"

SQL > @apex_epg_config.sql /u01/APEX (Where Apex unziped - cd /u01/APEX/apex/..)

7. Update the APEX images with those from the new release:

sqlplus "/as sysdba"

SQL > @apxldimg.sql /u01/APEX (Where Apex unziped - cd /u01/APEX/apex/..)



8. Verify the below account's 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. Run below syntax.

sqlplus "/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;

10. Download webtier.

ofm_webtier_linux_11.1.1.7.0_64_disk1_1of1.zip

11. Install the webtier.

12. Copy the images folder from apex to webtier.(/u01/APEX/apex/images to webtire oracle home)


13. Copy below parameters to dads.conf file and edit password.



  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride                 None -d
  PlsqlDatabaseUsername         APEX_PUBLIC_USER-d
  PlsqlDatabasePassword         apexpwd -d
  PlsqlDatabaseConnectString    system.xxxxxx.com:1521:orcl  -d
  PlsqlAuthenticationMode       Basic  -d
  PlsqlDefaultPage              apex -- d
  PlsqlDocumentTablename        wwv_flow_file_objects$  d
  PlsqlDocumentPath             docs -d
  PlsqlDocumentProcedure        wwv_flow_file_mgr.process_download -d
  PlsqlNLSLanguage              AMERICAN_AMERICA.AL32UTF8 -d

14. Restart the opmnctl


Accessible URLs
Oracle HTTP Server URL : http://system.xxxxxxx.com:7780
Oracle HTTP Server SSL URL : https://system.xxxxxxxx.com:4443