OraFAQ Forum: Client Tools » need help with setting up a connection

Home » SQL & PL/SQL » Client Tools » need help with setting up a connection (oracle sql developer, version:3.0.04, windows7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need help with setting up a connection [message #526078]

Sat, 08 October 2011 01:44

sethuspl
Messages: 4
Registered: October 2011
Location: bangalore

Junior Member

hi everybody..... this is sethu and am totally new to SQL. am trying to study sql myself and work out.... so i tried installing oracle sql developer in my laptop and i have problem in setting up a new connection..... i don't have any idea about which server am suppose to connect or whats the host no.: i entered the following:

connection name:sethu
username:sethu
password:sethu
connection type:basic and role:default
hostname:localhost
port:1521
SID:xe
and when i give test...

the error shown is "status:failure-test failure: IO Error: The Network could not establish the connection". what am i suppose to do for this....hoping for a solution soon... pls...

Report message to a moderator

Re: need help with setting up a connection [message #526082 is a reply to message #526078]

Sat, 08 October 2011 01:53

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you have a database anywhere?

Regards
Michel

Report message to a moderator

Re: need help with setting up a connection [message #526093 is a reply to message #526082]

Sat, 08 October 2011 03:11

sethuspl
Messages: 4
Registered: October 2011
Location: bangalore

Junior Member

no... i don't have any database.... how do i create one??

[Updated on: Sat, 08 October 2011 03:17]

Report message to a moderator

Re: need help with setting up a connection [message #526096 is a reply to message #526093]

Sat, 08 October 2011 03:40

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you cannot connect.
Go to OTN and download Oracle XE.

I advise you to watch Stephane Faroult's YouTube videos named "Oracle DBA Lite: an introduction to Oracle" (parts 1 to 7); they are based on Oracle XE.

Regards
Michel

Report message to a moderator