Friday, June 23, 2017

Install and Configure Oracle Application Express Apex 5.1.1,5.x with Embedded PL/SQL Gateway

Hi, for this first post i have compiled different tricks for install apex 5.1.1

Video en Español



First you can follow the original steps for Oracle... Install Apex from Oracle Page

But it will be summarized...

1: Download apex 5.1.1 from Oracle
2: Copy and compress the content in a directory easy access, for example D:\InstallApex
3: Open CMD and go for this directory and write SQLPLUS



4: Loged with  "sys as sysdba", enter your password and continue...
5: Run apexins.sql
@apexins.sql APEX APEX TEMP /i/
 or     @apexins.sql SYSAUX SYSAUX TEMP /i/

6: Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.
@apxchpwd.sql
7: Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
@apex_rest_config.sql

8: Run the Embedded PL/SQL Gateway configuration (EPG)
 @apex_epg_config.sql D:\InstallApex
   Note: You can try add "\" or erase it , The command automatically recognize the APEX main folder


9: Update APEX directory images with those from the new release, it could take a lot of minutes:
 @apxldimg.sql D:\InstallApex
10: Unlock the ANONYMOUS account.
          ALTER USER ANONYMOUS ACCOUNT UNLOCK;
      Note: Make sure that the following accounts are unlocked
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;

11:  Aditional Config:
           11.1 Open XML DB Protocol Server.
 EXEC DBMS_XDB.sethttpport(8080); 
           11.2 Update quantity of process

            SHOW PARAMETER job_queue_processes
     ALTER system SET job_queue_processes=20 scope=both;

     SHOW PARAMETER shared_servers
     ALTER system SET shared_servers=5 scope=both;


             11.3 Enable remote HTTP connections (optional):

     EXEC dbms_xdb.setListenerLocalAccess(l_access => FALSE);



12:   APEX should now be available from a URL like http://127.0.0.1:8080/apex

13:   Granting Connect Privileges:

13.1   
     DECLARE

    ACL_PATH VARCHAR2(4000);

    BEGIN

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

    -- the "connect" privilege if APEX_050100

    -- 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_050100',

    'connect') IS NULL THEN

    DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,

    'APEX_050100', 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_050100', TRUE, 'connect');

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

    END;

    /

    COMMIT;

13.2
DECLARE
ACL_PATH  VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to 'localhost' and give APEX_050100
-- the "connect" privilege if APEX_050100 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_050100',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_050100', 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_050100', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
END;
/
COMMIT;
14: For the first installation you need create a new schema and workspace. for this you can log in as ADMIN.

Workspace: INTERNALUsername: ADMINPassword: ***** 
   


Now you can enjoy of APEX









Share:

1 comment:

  1. would like to thank the author for sharing this such of wonderful and most impotently the helping information with us about oracle apex training in hyderabad

    ReplyDelete

Subscribe to my Newsletter

Acerca de mi:

img

Ing. Angel O. Flores Torres, soy Ingeniero de Sistemas e Ingeniero de Aplicaciones Oracle Apex, he trabajado con Oracle Apex 5 y 5.1 desde el 2017, En los ultimos años he desarrollado habilidades en CSS, JavaScript, Jquery y PlSql , I specialize in Oracle APEX (Oracle Application Express )

Followers

Popular Posts