Creating a new database and new connection in Oracle SQL Developer

Question

I've installed SQL Developer on my system. No connections are being shown in my system yet. How do I create a new connection. Must I create a database first? If yes, then how do I create a new database. The SQL Query Editor window is not opening because there is no connection. All of this because there is no database. How do I create an empty database and then connect to it.

Did you install Oracle database first? – Leniel Maccaferri Sep 08 '13 at 04:13 — Leniel Maccaferri, Sep 08 '13 at 04:13
No. How to do it. I didn't get it from the documentation. – MontyPython Sep 08 '13 at 04:16 — MontyPython, Sep 08 '13 at 04:16

score 28 · Accepted Answer · edited May 23 '17 at 12:26

28

This tutorial should help you:

Getting Started with Oracle SQL Developer

See the prerequisites:

Install Oracle SQL Developer. You already have it.
Install the Oracle Database. Download available here.
Unlock the HR user. Login to SQL*Plus as the SYS user and execute the following command:

alter user hr identified by hr account unlock;
Download and unzip the sqldev_mngdb.zip file that contains all the files you need to perform this tutorial.

Another version from May 2011: Getting Started with Oracle SQL Developer

For more info check this related question:

How to create a new database after initally installing oracle database 11g Express Edition?

edited May 23 '17 at 12:26

Community

1
1

answered Sep 08 '13 at 04:17

Leniel Maccaferri

100,159
46
371
480

2

@SachinKainth - Installing MySQL is such a relief! – MontyPython Dec 28 '17 at 20:39
'alter' is not recognized as an internal or external command, operable program or batch file. – Philip Rego Mar 09 '18 at 22:11

score 6 · Answer 2 · edited Jan 13 '22 at 09:53

6

Connect to sys.
Give your password for sys.
Unlock hr user by running following query:

alter user hr identified by hr account unlock;
Then, Click on new connection
Give connection name as HR_ORCL

Username: hr

Password: hr

Connection Type: Basic

Role: default

Hostname: localhost

Port: 1521

SID: xe
Click on test and Connect

edited Jan 13 '22 at 09:53

Kamlesh

5,233
39
50

answered Apr 23 '17 at 12:56

Niti

61
1
1

1

Please don't provide duplicate answer. – nomem Apr 23 '17 at 13:17
Username and password are upper case HR – Mike Nov 30 '18 at 17:55

score 1 · Answer 3 · answered Apr 17 '17 at 05:48

Open Oracle SQLDeveloper

Right click on connection tab and select new connection

Enter HR_ORCL in connection name and HR for the username and password.

Specify localhost for your Hostname and enter ORCL for the SID.

Click Test.

The status of the connection Test Successfully.

The connection was not saved however click on Save button to save the connection. And then click on Connect button to connect your database.

The connection is saved and you see the connection list.

Copy-pasting from the documentation is not an answer. – alelom Nov 21 '20 at 10:35 — alelom, Nov 21 '20 at 10:35

Creating a new database and new connection in Oracle SQL Developer

3 Answers3

Linked