2

I am absolute beginner to oracle and thought of getting started with installing Oracle Sql developer. Basically i downloaded the zip package and unzipped to program files and opened sqldeveloper.exe. Then I chose New connection and then filled the connection name,username,password and others but when I test the connection I get the following error.

Status : Failure-Test failed: IO Error: The Network Adapter could not establish the connection

I'm looking to connect to local database for practicing queries. How do I fix this, is there something else I should install?

Improve this question
7
  • What value have you given as hostname? Commented May 24, 2014 at 5:37
  • localhost is the hostname and Port is 1521,Which are the default ones. Commented May 24, 2014 at 5:39
  • 1
    There are many things that could be causing this. Here is a link to the latest documentation on setting up SQL Developer. docs.oracle.com/cd/E39885_01/appdev.40/e38414/… Commented May 24, 2014 at 5:42
  • 2
    Did you install a database? SQL Developer doesn't come with an Oracle database. Commented May 24, 2014 at 5:42
  • 2
    Here is a link to the downloads page: oracle.com/technetwork/database/enterprise-edition/downloads/… Commented May 24, 2014 at 5:45

1 Answer 1

Reset to default
5

Before downloading the Sql Developer, Download the Latest version of Oracle Database from here

1) Now run the Downloaded Oracle database and during installation, it will prompt to create a password for User named 'SYSTEM' .

In my case i have created the password as 'oracle'.

So my credentials for Oracle Database are

User Name: SYSTEM

Password : oracle

2) Now download the SQL Developer and extract it to a local folder.Once Extracted, click the sql developer application file --> Connections Tab --> New Connection (+ icon)-->

Connection Name: TestConn (give some random name)

Username: SYSTEM

Password: oracle (the password i have given during installation of oracle database)

Leave all the other default fields as they are .(see the screenshot below).

Click on test for testing the connection.

Database Connection

References:-

https://www.thatjeffsmith.com/archive/2012/12/i-have-oracle-sql-developer-installed-now-what/

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.