This content has been marked as final. Show 6 replies
But the main problem I still have is that I cannot access my database on another computer using my laptop as the server and the other one as the client. I also want to access it via the internet apart from using the LAN cable connection. I do not know how. I posted it on Apex Forum. A solution was sent to me by one contributor, which worked with the following code: EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); on the LOCAL AREA NETWORK connection initially.I later had problem with my laptop so I did new window intallation by first formatting the computer. Thereafter, when I installed Apex 11g, inspite of using the above code, I cannot access the application on another computer as before.
I will be glad if anyone would still help me
First things first. Oracle Database is different from Oracle Application Express. You install Apex in an existing Oracle database instance.
There is nothing like Apex 11g. Your Oracle RDBMS 11g (XE or other edition) refers to RDBMS and Apex numbering goes 3.x, 4.x,etc. The latest being 4.2.
When you say you are not able to access the application
i. Are you able to access the application from the DB server?
ii. What do you see in the browser? What page/message?
iii. What the URL you are using ?
After formatting your machine what all have you installed?
a. Oracle RDBMS
b. Which Edition of 11g. E.g. XE, StandardOne, etc.?
b. Apex by running apxinst.sql script?
Sorry for incorrect specification. I rather installed Database 11 EX 2.0. Please what is the procedure of installing the Apex series in the Database instance?
When you say you are not able to access the application*
i. Are you able to access the application from the DB server? -- YES- on URL: http://127.0.0.1:8080/apex/f?p=4950:1 from the DB Server, and http://169.254.164.124:8080/apex/f?p=4950:1 from other clients; having 169.254.164.124 as the IP Address of the server.
+++After formatting your machine what all have you installed?+++ -- The same as above. 11g EX 2.0. That is all I knew. I can still access from the database server but not from any client on the LAN connection.
This the browser message:- *"THE CONNECTION TO THE SERVER WAS RESET WHILE THE PAGE WAS LOADING"*
So how should I install the Apex 4.2 on the instance?
Edited by: Godis-Tei on 06-Dec-2012 09:46
Perform the task detailed here. http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#CBHIJFJF
You have to replace APEX_040200 with the actual schema name you have in your XE database. Maybe APEX_040000.
You may want to upgrade to 4.2, which is the latest at this time, but the above step needs to be completed with the correct schema name.
I applied the following as you directed me:-
-- Look for the ACL currently assigned to '*' and give APEX_040000
-- the "connect" privilege if APEX_040000 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_040000',
'connect') IS NULL THEN
'APEX_040000', TRUE, 'connect');
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
'ACL that lets power users to connect to everywhere',
'APEX_040000', TRUE, 'connect');
The procedure was successful and committed; but still connection to other clients is not successful. Where might the problem be again? Is there anything I am still lacking?
If 169.254.164.124 is the IP of the server then
a. What happens when you access the URL http://169.254.164.124:8080 from another PC on the LAN? Do you get 404-Not Found? Something else?
b. What happens when you access the URL http://169.254.164.124:8080/apex from another PC on the LAN?Do you get 404-Not Found? Something else?
All other setups appear right from what you have said.
Should enable the access from other PCs.
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); COMMIT;
Are you by any chance trying to access Apex over the internet? If yes, you need to ensure that port 8080 is open/forwarded on the firewall/router.
Thanks so much for your assistance. In fact, I did all I could but still not working until I put the Firewall OFF. After that I can access apex on any computer on the LAN. But my worry is that; is it safe to put off the firewall because of access to the application?
Finally; I cannot access it on the internet. i am using Window 7 Ultimate Operating System. On the Firewall Outbond I set the port at 8080 for apex, but still I cannot acess it on the internet - whether the Firewall is ON or OFF. I need more education on how to access my database on the internet. I am looking forward for a help
Edited by: Godis-Tei on 10-Dec-2012 10:58
Edited by: Godis-Tei on 10-Dec-2012 11:04