This article explains how to install Oracle Express Edition 11G, a very common software among programmers.
Steps
Step 1. Connect to this link
Step 2. Choose "Accept License Agreement"
Download the correct version for your computer, be it Windows or Linux. Save the file.
Step 3. Find the file you just downloaded
When you find it, unpack it, then double-click "Setup" to install Oracle.
Step 4. Click on "Next"
Step 5. Select "I accept the term in the license agreement" and click "Next"
Step 6. Choose the path to install Oracle, and click "Next"
Step 7. Enter and confirm the password for database access
Then click on "Next".
Step 8. Click on "Finish"
Step 9. Launch Oracle Database 11G Express by clicking "Start"
Then click "Oracle Database 11G Edition", then go to the Database homepage.
Step 10. Enter Username:
System and type the password (the one used a few steps back).
Step 11. Select "Administration", then "Database Users" and then "Create User"
Then, close the session.
Step 12. Now you can log in again (with the newly created user) and use the Oracle database
Advice
- In step 7 use SYS or SYSTEM as password.
- To be able to upload tables that you have already created on other systems, go to Home, click "SQL", then "SQL Scripts" and "Upload" (it will allow you to upload table creation scripts).
Warnings
- In step 11, select "All System Privileges" to be able to experiment with the commands (you will not need all permissions to work normally). Do not choose "DBA" (as your account must be different from SYSTEM and SYS).
- Before downloading and installing you have to choose "I accept the agreement"!