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 **/
Labels:
Core Java