I've installed oracle 11g express edition and sql developer. I don't know ho to connect to a database on remote server. Can anyone help please. Note that I didn't installed any other software like oracle client. Please help, I'm new to this environment
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as not a real question by Mark Storey-Smith, ypercubeᵀᴹ, Phil, Leigh Riffel, Jon Seigel Jan 5 '13 at 17:11
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
If I understand you correctly, you want to connect SQL Developer to an Oracle XE database on a remote host.
Assuming you installed everything with default options and provided you have nothing blocking the network traffic to port 1521 of your oracle server, you should now be able to connect.
I just happened to see a nice screenshot in another question here: How to open Oracle listener for three database instances?
I recommend the book Oracle Database XE 11gR2 Jump Start Guide by Asif Momen to get you started. It's available as an e-book on Amazon or can be read on Safari Books Online, I believe they still offer a free trial.