how to remotely access to oracle database XE ?
898236Jan 31 2012 — edited Feb 2 2012hello
I have oracle database XE 10.2.0.1.2 installed on a centos 6.2 (~redhat).
I would like to connect to it from a java program, and at the moment from dbschema, a database manager, graphical.
I hava the port used for the TCP access by the server : 1521
the url is : jdbc:orac:e:thin@<the address of my computer with dns-admin>:1521:XE .
I can ping the address of my computer so this is good for this part.
I disabled the firewall of the OS, and opened a port in my livebox : port 1521, protocol TCP.
but when I try to connect from dbschema, I have this error :
--------------------------------------------------------------------------------------------------------------------------------
Error
java.net.ConnectException: Connexion refusée oracle.net.ns.NetException: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: Erreur d'E/S: The Network Adapter could not establish the connection
Advice
Please disable the Firewall on server if any. Do 'ping <hostname>' from command prompt to check the hostname. Make sure the Port is correct and the database is running.
---------------------------------------------------------------------------------------------------------------------------------
I don't know what to do, and I would like to connect to my database tomorrow.
can you help me?
olivier
Edited by: lolveley on 31 janv. 2012 13:46