Home » SQL & PL/SQL » Client Tools » need help with setting up a connection (oracle sql developer, version:3.0.04, windows7)
icon9.gif  need help with setting up a connection [message #526078] Sat, 08 October 2011 01:44 Go to next message
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...
Re: need help with setting up a connection [message #526082 is a reply to message #526078] Sat, 08 October 2011 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have a database anywhere?

Regards
Michel
Re: need help with setting up a connection [message #526093 is a reply to message #526082] Sat, 08 October 2011 03:11 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
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
Re: need help with setting up a connection [message #526105 is a reply to message #526096] Sat, 08 October 2011 05:03 Go to previous messageGo to next message
sethuspl
Messages: 4
Registered: October 2011
Location: bangalore
Junior Member
thank you very much for your reply sir..... hope its useful for me... Smile
Re: need help with setting up a connection [message #526126 is a reply to message #526105] Sat, 08 October 2011 10:38 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
>hi everybody..... this is sethu and am totally new to SQL.
SQL depends upon some RDBMS & MYSQL is easier to install & manage than Oracle.
Re: need help with setting up a connection [message #526777 is a reply to message #526126] Wed, 12 October 2011 22:52 Go to previous message
sethuspl
Messages: 4
Registered: October 2011
Location: bangalore
Junior Member
thank you very much Mr.Michel Cadot and BlackSwan.... my problem solved.... Smile
Previous Topic: how to install oracle developer suit 10g on window 7 32 bit
Next Topic: Oracle User Management
Goto Forum:
  


Current Time: Wed Feb 21 21:57:09 CST 2018

Total time taken to generate the page: 0.16455 seconds