Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

After lots of futzing around with all of the settings, I finally managed to get APEX to work on a remote server. To get that to happen, I had to grant my user the SYSDBA role, and I also included myself in the ORADBA group on that machine. I can log in to APEX at http://computername:8085/apex. (Note that I used port 8085 instead of 8080 - there seemed to be an Apache listener using 8080).

My question is, how do I connect to APEX without using the remote desktop. That is, VPNing to the machine, and just opening the browser on my local computer and typing http://computername:8085/apex. I've looked all over and tried numerous approaches, including

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Any ideas?

share|improve this question
add comment

1 Answer

In case anyone comes looking for this: I had to open up port 8085 (the port that I chose; by default it's 8080, but I had a listener there already) on the local computer's firewall (where Oracle & APEX are installed) to both incoming and outgoing connections. For me, this was as easy as opening up Windows firewall, going to advanced settings, and adding a rule for this port to both the inbound and outbound rules section.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.