Oracle SQL - Environment Setup

For work with Oracle SQL we need to setup an environment. In this post we will discuss the step by step procedure for setup Oracle Database.

Requirements:

Disk Space: Minimum 2GB(3GB recommended for not getting errors during installation).

RAM: Minimum 512MB(it Depending on the Operating system). 

Download Oracle SQL:

First go to Oracle official website from the given link. Now, for download Oracle SQL you have to create an account and it is free. 

 After you create an account click on Accept Licence Agreement.After that choose your operating system. If you have Windows 64 bit computer then choose the first download option. If you have Windows 32 bit computer then choose the second option and if you have linux then choose the third option. For download the Oracle SQL click the link given below.

Download Oracle Database 11g Express Edition 

Oracle Database Installation:

1) The Oracle Database you downloaded will be in zip format. First you extract the file and then you get the setup file.

2) Now, click on the setup file to start installation. When you click on setup file it will start extracting all files that required.It will take around 2-3 minutes depending on your computer. 

3) After this is complete you will see a screen appears.. Simply click on Next.
4) After this you see the license agreement. Now, simply select 'I accept the terms in the license agreement' and click Next.

5) Now, it gives you option for change the installation location. You can leave it same if you don't want to change the default location and click Next.

6) After this it ask for the password for database. Now, in Oracle database we have two default user of database - a) SYSTEM & b) SYS. For access them we have to set a password. So, enter a password you like & click next.

7) Now, in the next page it shows you all the settings you have made before starting installation. If everything is alright then simply click on Install to start installation.

8) The installation will take around 5-10 min depending on your computer. After the installation complete it shows a dialog box that 'Setup has been finished installing Oracle Database 11g Express Edition on your computer'. Click on Finish.

You have now installed the Oracle Database Express Edition 11g. Now, go to All Programs and there you find a new folder Oracle Database 11g Express Edition, open the folder and there you find some applications.

Now, for check the database open the Get started file in the folder. This file will open in browser and shows the homepage of your oracle database.
If anyone have any question then ask me in the comment section, thank you.