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) 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
Now it will ask for the user name, type system, and press enter.
Enter the password that you entered during installation.
create user <username> identified by <password>; grant all privilege to <username>;
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.