Creating a new database and new connection in Oracle SQL Developer

sql oracle database-connection oracle-sqldeveloper
MontyPython picture MontyPython · Sep 8, 2013 · Viewed 149.8k times · Source

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.

Answer

Leniel Maccaferri picture Leniel Maccaferri · Sep 8, 2013

This tutorial should help you:

Getting Started with Oracle SQL Developer

See the prerequisites:

  1. Install Oracle SQL Developer. You already have it.
  2. Install the Oracle Database. Download available here.

  3. 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;

  4. 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?

Related questions

java.sql.SQLException: ORA-01005: null password given; logon denied

I'm getting the follwing exception while trying to connect to a database: java.sql.SQLException: ORA-01005: null password given; logon denied at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.…

Read More
How do I close the cursor created in a database link(ORA-02080)?

I perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer: create database link mydb connect to my_schema identified by mypwd using 'connection1'; select * from users where id = 1; rollback; ALTER SESSION CLOSE DATABASE LINK mydb; …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More