Step 2. Install Oracle 11g Release 2

Download Oracle 11g Release 2 here

Choose Accept License Agreement then download 2 file there win64_11gR2_database_1of2.zip and win64_11gR2_database_2of2.zip

After download complete, you will get 2 rar file of Oracle 11g, then Extract both file and it will automatic will create new folder with name database

Inside database folder like this, choose setup, right click then choose Run as administrator

Uncheck I wish to receive security updates via My Oracle Support, then click Next to continue

There is will pop up warning about Email Address Not Specified, just click Yes to continue

Because we need for Development, choose Create and configure a database then click Next to continue

Choose Desktop Class for light database, click Next to continue

Setting List for Typical Installation Window

• Oracle base : default
• Software location : default
• Database file location : default
• Database edition : default – Enterprise Edition (3.34 GB)
• Character Set : Change to Unicode (AL32UTF8)
• Global database name : orcl
• Administrative pass : orcl
• Confirm password : orcl

Click Next to continue

Because our password does not conform to the Oracle recommended standard, it will show pop up like this, just Click Yes to continue

There is will summary about our Prerequisite Checks Result, just click Finish to continue Install

Install Product, just wait for process

When in middle of Install Product, there is will 2 pop up Java, just check Private Networks and click Allow access to continue

Before Installation Complete, Database Configuration Assistant will show and just wait until process complete

Before click OK to finish Database Configuration, we need to Unlock HR Username, to configure that click Password Management

Scroll down until Username HR, uncheck Lock Account? Then give 

New Password : hr and Confirm Password : hr

Click OK to continue

There is will Pop Up, Just Click Yes to continue

Installation of Oracle Database was successful, click Close to finish

Check Installed Database on SQL Developer

Search SQL Developer on Windows Search

There is will pop up Missing Shortcut, just click Browse to continue

You will directed to SQL Developer bin path, run sqldeveloper.exe

There is will pop up, we need to Enter the full pathname for java.exe, just click Browse to continue

Locate java.exe of J2SE to be used, we use Java 7 32 bit, in this case our Java path

C:\Program File (x86)\Java\jdk1.7.0_80\bin, choose java.exe, then click Open to continue

The result of full pathname for java.exe

In my case, I have 2 pop up System Error, First Error because missing MSVCR100.dll then the second Error because Unable to launch the Java Virtual Machine

For fix both Error, search file msvcr100.dll from your Java bin path, in my case, I can get msvcr100.dll from my Java path C:\Program File (x86)\Java\jdk1.7.0_80\bin, then copy msvcr100.dll

Paste that msvcr100.dll file to sqldeveloper path, in my case my sqldeveloper path at

C:\app\user\product\11.2.0\dbhome_1\sqldeveloper

Click sqldeveloper again, and Oracle SQL Developer start up will appear like image below

There is will show Migrate User Settings pop up, just click Yes to continue

There is will show Oracle Java check, just check Skip This Message Next Time, then click Yes to continue

SQL Developer for first time start up

There is will show Configure File Associations pop up, just check all file types

Click New Connection to connect to database

For setup on New/Select Database Connection, do setup like this

Connection name : orcl_hr

Username : hr

Password : hr

Save Password : check it

Role : default

Connection Type : Basic

Hostname : localhost

Port : 1521

SID : orcl

Click Test first, then see status on left bottom window, there is message Status : Success, if already success on Test Connection, just click Connect to continue

We will see on Connection window, under Connection there is will orcl_hr is alredy connect to SQL Developer

Lets try to connect Scott schema to SQL Developer, Username/Password = scott/tiger

If we check Test connection, there is will Status Failure like image above, this is because scott schema is locked when we install database, to solve this problem go to next step

Check port database, go to Command Prompt, then type tnsping [database name], in our case we type tnsping orcl

To unlock scott schema, goto Command Promt, then type sqlplus / as sysdba to connect to database as sysdba, if connected just type on 

SQL>alter user scott identified by tiger account unlock;

Lets check scott connection again after we unlock the user

If status : Success when Test Connection, click Connect to continue