Install and Configure Oracle 11g for Free (legally)

How to install and configure Oracle 11g for Free

Oracle needs no introduction. The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system(ORDBMS)[2] produced and marketed by Oracle Corporation.

Oracle is a proprietary software, meaning you need to pay (a lot of ) money to get a license of Oracle. Thankfully you can now get Oracle for free, the express editions that is. They are pretty good unless you want more business end solutions. For personal use or small businesses, or simple development needs Oracle Express Edition will do just fine.

Download the file from here –Oracle Express Editions

You will be required to log into Oracle to be able to download this file. In case you are not registered, you can go through a very lengthy registration process or go through a simpler approach by finding a suitable userid and password from bugmenot.com.

Of course I recommend you do the former only.

Now you just need to download the file and install it on your system. Depending on your Operating systems, the installation procedure might be slightly different. Just make sure you note down the password for the system user of Oracle. This password will be asked during installation only.

Configure Oracle 11g

Post install fire up Start Menu and go to SQL command line.
In the prompt type the following commands one by one

SQL> conn

Now it will ask for the user name, type system, and press enter.
Enter the password that you entered during installation.

It should say ‘Connected’
Connect to System user in Oracle configure oracle
Now type in :

create user <username> identified by <password>;
grant all privilege to <username>;

create new user in oracle 11g configure oracle
Choose any username and password of your choice and press enter. All you have to do now is to type conn again. This time give your new username and password and connect to your session.

connect new user in oracle 11g configure oracle

That’s how you have configured Oracle Database on your system. Enjoy and in case something doesn’t work out do mention that in the comments, I will check them out.