Posted By: Anonymous
I have installed Oracle Database 11g Express Edition on my pc (windows 7)
and I have installed Oracle SQL Developer as well.
I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert data and query it.
When I open Oracle SQL Developer, it asks me to create a new connection, therefore it assumes that a database has already been created.
So my question is, how do I create an initial database in Oracle 11g?
This link: Creating the Sample Database in Oracle 11g Release 2 is a good example of creating a sample database.
This link: Newbie Guide to Oracle 11g Database Common Problems should help you if you come across some common problems creating your database.
Best of luck!
EDIT: As you are using XE, you should have a DB already created, to connect using SQL*Plus and SQL Developer etc. the info is here: Connecting to Oracle Database Express Edition and Exploring It.
Connecting to Oracle Database XE from SQL Developer SQL Developer is a
client program with which you can access Oracle Database XE. With
Oracle Database XE 11g Release 2 (11.2), you must use SQL Developer
version 3.0. This section assumes that SQL Developer is installed on
your system, and shows how to start it and connect to Oracle Database
XE. If SQL Developer is not installed on your system, see Oracle
Database SQL Developer User’s Guide for installation instructions.
For the following procedure: The first time you start SQL Developer
on your system, you must provide the full path to java.exe in step 1.
For step 4, you need a user name and password.
For step 6, you need a host name and port.
To connect to Oracle Database XE from SQL Developer:
Start SQL Developer.
For instructions, see Oracle Database SQL Developer User’s Guide.
If this is the first time you have started SQL Developer on your
system, you are prompted to enter the full path to java.exe (for
example, C:jdk1.5.0binjava.exe). Either type the full path after
the prompt or browse to it, and then press the key Enter.
The Oracle SQL Developer window opens.
In the navigation frame of the window, click Connections.
The Connections pane appears.
In the Connections pane, click the icon New Connection.
The New/Select Database Connection window opens.
In the New/Select Database Connection window, type the appropriate
values in the fields Connection Name, Username, and Password.
For security, the password characters that you type appear as
Near the Password field is the check box Save Password. By default, it
is deselected. Oracle recommends accepting the default.
In the New/Select Database Connection window, click the tab Oracle.
The Oracle pane appears.
In the Oracle pane:
For Connection Type, accept the default (Basic).
For Role, accept the default.
In the fields Hostname and Port, either accept the defaults or type
the appropriate values.
Select the option SID.
In the SID field, type accept the default (xe).
In the New/Select Database Connection window, click the button Test.
The connection is tested. If the connection succeeds, the Status
indicator changes from blank to Success.
Description of the illustration success.gif
If the test succeeded, click the button Connect.
The New/Select Database Connection window closes. The Connections pane
shows the connection whose name you entered in the Connection Name
field in step 4.
You are in the SQL Developer environment.
To exit SQL Developer, select Exit from the File menu.