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.sql7: 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:\InstallApexNote: 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:\InstallApex10: 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);
13: Granting Connect Privileges:
13.1DECLARE
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
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
ReplyDeleteThanks a lot for sharing a great blog I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more keep going on it helped me a lot I have gained a lot of knowledge by reading your blog.
ReplyDeleteOracle Apex Training
apex oracle training
oracle apex training online
oracle apex courses online
Oracle APEX 19.1 Training
oracle apex 18 training
oracle apex 5 training
Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man learn
ReplyDeletePega Online Training
Pega Online Course