Oracle 11g and SQL Developer installation and setup on 32/64bit windows - explained step by step with screenshots


In this tutorial we will learn how to install oracle 11g for windows in 14 steps and than we will install Sql developer in 6 steps.

  • 14 steps to download and install oracle 11g for windows 32
  • 6 steps to download and install Sql developer

14 steps to download and install oracle 11g for windows 32

oracle 11g  installation - STEP 1) Download oracle 11g for windows 32 or 64 depending on your system.

oracle 11g  installation - STEP 2) Download
  • win32_11gR2_database_1of2.zip
  • win32_11gR2_database_2of2.zip

oracle 11g  installation - STEP 3) Unzip both zip files.

oracle 11g  installation - STEP 4) Go to unzipped folder of win32_11gR2_database_2of2 >
In my system it was in directory=
C:\Users\ankitmittal01\Downloads\Oracle\win32_11gR2_database_2of2

copy database folder


oracle 11g  installation - STEP 5) Copy it in unzipped folder of win32_11gR2_database_1of2
In my system it was in directory=
C:\Users\ankitmittal01\Downloads\Oracle\win32_11gR2_database_1of2

system will display message to merge this folder, click Yes

oracle 11g  installation - STEP 6)
Go to directory =
C:\Users\ankitmittal01\Downloads\Oracle\win32_11gR2_database_1of2\database

Execute setup.exe, Run as administrator

oracle 11g  installation - STEP 7)
You may optionally fill your email and password for security issues and updates,
click Next>

oracle 11g  installation - STEP 8)
If email and password are not filled, error message will be prompted, click Yes

oracle 11g  installation - STEP 9)
Click Next>



oracle 11g  installation - STEP 10)
Click Next>

oracle 11g  installation - STEP 11)
Give password, you must remember it - here I have given it as Oracle123
click Next>


oracle 11g  installation - STEP 12)
Click Finish


Let this step complete(it might take few minutes), in case of error click Retry


Let this step complete(it might take few minutes)


oracle 11g  installation - STEP 13)
Click Ok,
generated System identifier(SID) : orcl, will be used later.

oracle 11g  installation - STEP 14)
Click Close, and you done with Oracle 11g installation on your system.


So far we have learned how to install Oracle 11g setup on 32/64bit windows.


6 steps to download and install Oracle Sql developer >

Oracle SQL Developer installation - STEP 1)
Now, let’s download and install Sql developer.



Oracle SQL Developer installation - STEP 2)
Download
Windows 32-bit - zip file includes the JDK1.6.0_35


Oracle SQL Developer installation - STEP 3)
Execute sqldeveloper.exe


Oracle SQL Developer installation - STEP 4)
while starting your Oracle SQL Developer you might face such problems >
Enter full path of java.exe, the folder in which you installed Oracle 11g
E:\app\ankitmittal01\product\11.2.0\dbhome_1\jdk\bin\java.exe





Oracle SQL Developer installation - STEP 5)
Click on New connection (green colour Plus sign)


Sometimes, you might face missing msvcr71.dll
google and download this msvcr71.dll and copy it in folder where sqldeveloper.exe exists.



Oracle SQL Developer installation - STEP 6)
Now, let’s create a user , Go to CMD and type below commands >
user-name : system
password   : Oracle123  (As entered in oracle 11g  installation - STEP 11)
C:\Users\ankitmittal01>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 9 17:26:40 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user ankit identified by Oracle123;

User created.

SQL> grant all privileges to ankit;

Grant succeeded.

Now, new user ankit will be created with password=Oracle123



Oracle SQL Developer installation - STEP 7)
Enter
Connection name = dev  (Or as per your choice)
Username = ankit
password=Oracle123 (Oracle SQL Developer installation - STEP 5)
SID= orcl (As generated in oracle 11g  installation - STEP 13)
Click Test



Congrats! you are done with Oracle 11g and SQL Developer installation and setup on 32 bit windows



/** javamadesoeasy.com **/
















No comments:

Post a Comment