If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Sql developer connection

Hi!

I'm a beginner in databases and I'm trying to study it but I have a problem.
I need to connect to SQL Developer from Oracle 11g just to write (and lean sql code). I don't want (and know how to) to make a reallife-working database. In fact I don't know to do pretty much nothing with Sql developer.
My problem is that I don't know how to make a Database Connection, It say: "the network adaptor could not establish the connection".
Could anyone tell what I should do?

For those who know about it I am talking alout SQL Bible book (2003)http://www.amazon.com/SQL-Bible-Alex...f=cm_lmf_tit_2 who has a CD with a database (ACME). But in the book they use oracle 9 version installed on XP. I have a Win 7 and because oracle 9 is not compatible with win 7 I installed oracle 11g.

OK, so you installed a database. 11g on Windows 7 is perfectly OK (unless it is Windows 7 Home Edition; Oracle was never certified on any home edition).

Can you connect to the database via SQL*Plus? That would mean that your database is up and running; SQL Developer is just another tool. Though, I don't quite understand how come that User's Guide for SQL Developer, that is supposed to guide users, didn't help at all.

>All I'm trying to do is to figure out why I get the "the network adaptor could not establish the connection"
error.

Are OS Services for both DB & Listener running?
Is listener running?

post results from following OS command
lsnrctl status

JDBC Thin does not require or use tnsnames.ora

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

You have serious Operating System/networking mis-configuration issue.
Oracle is victim; not culprit.
root cause is external to Oracle & must be corrected at OS level.
Installation Guide contains instructions for proper OS configuration
Good Luck!

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.