Hello,
I tried to install Apex 19.2 and I could finish all steps successfully, I set port number(8087) but I could not access Apex on Chrome (http://localhost:8087/apex/) so I checked the listener file where it is localhost and 1521, so I changed EXEC DBMS_XDB.sethttpport to (1521); but it says 'localhost did not send any data' ...ERR_EMPTY_RESPONSE. how to resolve ? This is my fifth vdo I watched and tried to install. My configuration is...
1)Oracle 19 c on C:\\ORASAN
2)Apex 19.2 extracted on D:\\Apex_19.2
3)changed to pdb by 'ALTER SESSION SET CONTAINER=orclpdb';
In many VDOs people do not alter so I did without altering the container but it gave error saying 'Application Express is installed locally in a PDB and you are connected to CBD$ROOT'. Connect directly to the PDB to upgrade or configure Application Express'
4)Apex installed on D:\\Apex_19.2\\Apex
5)Images installed (@apex_epg_config.sql D:\\Apex_19.2)
I think step # 3 is crucial that gives me error or Is it because of wrong images path or firewall etc ? Can you please tell me where I am going wrong ?
Vinish Kapoor
First of all, you should revert the HTTP port setting you have done for 1521. Port 1521 is the port for Oracle Database, and you can not use it for Oracle Apex.
Check the following tutorial:
Installing Oracle Apex on Pluggable Database
Sanjay
Hello Vinish,
Thanks for your reply. The link you've forwarded is for Apex 5 on Oracle 12C Pluggable Database. Is it the same procedure for my Apex 19.2 on Oracle 19 C ?
Vinish Kapoor
Yes, the procedure is the same for every version 5.0 onwards. And the concept of a pluggable database is also the same from 12c onwards. But there are changes in the last step, where we need to give the ACL permissions. For this step, you can use the following code:
Granting privileges for Oracle database 12C or later:
Sanjay
tried to install as per the link give but at first declare set it givesĀ error as
ERROR at line 1:
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 861
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 853
ORA-06512: at line 6