How to set up local Oracle SQL database in 3 steps

by · September 29, 2012

Step 1: Installing Oracle SQL Express Edition

1. Download Oracle SQL Express Edition 11g Click Here

2. Run the setup file

setup-oracle-sql_1

setup-oracle-sql_2

setup-oracle-sql_3

Leave the default settings and click Next

setup-oracle-sql_4

Enter a password for System (administrator) account

setup-oracle-sql_5

setup-oracle-sql_6

setup-oracle-sql_7

setup-oracle-sql_8

Step 2: Launching SQL Developer

1. Download Oracle SQL Developer Click Here

2. Run sqldeveloper.exe file

setup-oracle-sql_10

setup-oracle-sql_11

Tick all the file types, then click ‘OK’ button

setup-oracle-sql_12

Step 3: Establishing database connections

1. Open SQL Developer, and then right click on “Connections” and click “New Connection”

setup-oracle-sql_13

2. Enter database connection name and username here, the default is:

Name: HR_ORCL

Username: SYSTEM

Password: (SYSTEM Password you entered while installing Oracle Database)

setup-oracle-sql_14

Click Test to test the connection status, if succeeded, Save and Connect.

setup-oracle-sql_15

To Create a new database and username follow the steps below:

1. Open this link ORACLE Database – APEX via your browser

2. Click “Application Express”

setup-oracle-sql_17

Enter the new database name, username and password, and click “Create Workspace”

setup-oracle-sql_18

Then go to SQL Developer, create a new connection and enter the same database name, username and password

setup-oracle-sql_19

setup-oracle-sql_20

Connected successfully to your own database scheme, congratulations Open-mouthed smile

Note: It is recommended to use your own database instead of SYSTEM.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Ahmed Yusuf

About Ahmed Yusuf

BPITS Co-Founder | Software Specialist. Java Developer, Big Fan of Android, Apple products & Open Source.

Tutorials

, , , ,

  • Asma

    does it need a lot of disk space, or make the laptop slow ?

    • AliTalahi

      Dear Asma,

      Both the database and the SQL developer will consume around 3GB of your internal storage (HDD) or (SSD), and it doesn’t not affect on the performance hugely, but it needs not less than 1GB of RAM to operate perfectly, otherwise, you might face some slowness in the system.

  • mohammed

    the version provided in the link is only for 32 bit Windows, mine is 64 bit ..so what can i do ?

  • Abdulla

    It is recommended to use your own database instead of SYSTEM.

    ^why ?

  • Abdulla

    I tried to make a new connection and its fails to connect!
    im using the 64bits version

  • Joshua Williams

    Thanks a TON! Worked perfectly.

  • suprava

    thank u so much..with the help of this post i am now successfully working on my 64 bit system with a 32 bit oracle..thanks a lot.very helpful..

  • Akki

    Thanks Mate this was really helpful.

  • sachin

    how to make use our own database instead of system…..plz help

    the link given Oracle database-Apex is not opening