Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to remotely access to oracle database XE ?

898236Jan 31 2012 — edited Feb 2 2012
hello

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2012
Added on Jan 31 2012
52 comments
14,899 views