Geek Answers Handbook

Oracle Express Edition - Unable to connect remotely (plus others)

I cannot make a remote connection to an Oracle XE installation (via TOAD / SQL Developer). Here's the deal.

I installed a new server (windows 2003). The goal was to create a new image with preinstalled applications, one of which is Oracle XE. Got Oracle did not install any problems locally, remotely, and had access to the web interface - the one that was found at http://127.0.0.1:8081/apex (Note: I changed the web interface port manually as we run Tomcat dev environment on 8080).

So, everything goes smoothly, I create an image, wipe the car and put the image just created. Everything works except Oracle. After many copies, I update the tnsnames.ora file, add the ORACLE_HOME and ORACLE_SID environment variables, so I can connect locally. I still cannot connect remotely and completely lost access to the web interface. I spent 2 days on Google and I have all the ideas. Please, help!

+5
source share
6 answers

ManuelF refers to web-based access, but is not related to local web-based access.

, / . SQLPLUS / AS SYSDBA, . SQLPLUS user/pass@XE, . , - , listener.ora . ,

sqlplus user/pass@127.0.0.1:1521/XE

, tnsnames.ora.

, "a", " b", " a" "b". , box_b

sqlplus user/pass@box_a:1521/XE

, Oracle sql * plus, box_b. , tnsnames.ora box_b. Oracle box_b, Oracle SQL Developer JDBC ( Oracle), , ( 1521 ) sid (XE -)

+4

, 1521 ?

+2

- [ ], , " ".

EDIT: : WebInterface → → [ ] HTTP- → .

+1

, Ubuntu, /etc/hosts. IP-, /etc/interfaces, IP-:

127.0.0.1       localhost
127.0.1.1       fqdn.domain.com        myhost
sta.tic.ip.address        fqdn.domain.com        myhost

IP.

lnsrctl status XE. hosts, oracle-xe, .

0

Windows 8.1 . Oracle XE 11g Oracle Application express 5.0.2. /. oracle express .

TNSLSNR Windows Fire Wall, .

→ Windows →

0

, . http://localhost:8080/apex/ SYSTEM, "" " HTTP-",

.

, .

0

More articles:


All Articles