Установка oracle 11g на windows 10

Update: 9th October 2015

The installation procedure mentioned below are applicable for Windows 10 also. So enjoy! I just finished installing the 11G R2 64Bit database in my computer running Windows 10 64Bit professional.

I believe if someone is attempting to install Oracle database in a laptop or desktop machine, it is purely for limited development requirements or learning.

A many who are new to Oracle database may not able to install the software on many versions of Microsoft client OS like Windows 7 or 8 until certain levels of hacks are made.

Ignore what “I know everything” geeks screaming across tech forums, asking you questions like “DID YOU READ THE CERTIFICATION MATRIX”

You don’t have the time, neither do I.

Let us install the Oracle database 11g R2 this time on a Windows 8.1 (Update 1) dell laptop with following configuration 8GB memory, 1TB Hdd, Windows 8.1 update 1 64Bit Other oracle software installed

1. Developer Suite 6i
2. Developer Suite 10g

Download the installation files from Oracle repositories

1. There are two files to download, a total of 2GB
2. Extract the zip files and move the files inside a single folder

Once extracted, you have something like below

1. 

   Картинка с сайта: simpleoracle.com

   Now Switch to the second folder, which reads as “win64_11gR2_database_2of2”

2. Open up the “components” folder (D:\Oracle11gR2_64Bit\win64_11gR2_database_2of2\database\stage\Components)
3. There will be four sub-folders within “Components” folder, copy them to D:\Oracle11gR2_64Bit\win64_11gR2_database_1of2\database\stage\Components folder

That’s all. Just start the installation process. Make sure you have changed the virtual memory settings of your box prior the installation (If you already have developer suite 10g, you already changed it) Start the installation by executing “setup.exe”

Картинка с сайта: simpleoracle.com

You will get one warning, about not meeting the recommended environment requirements (/me chuckles). We didn’t check the 32Bit version of Oracle Database 11g R2, however the method should be same. Hope you enjoyed another post from us

for Windows7bugs

rajesh

In this article, we will look at how to download & install Oracle 11g database on Windows 10. You can follow same process for any version of windows like Windows 11, Windows 10 (62 bit/32 bit), Windows 7 and Windows 8.

Oracle database is a widely used Relational Database Management System (RDBMS). Oracle 11g is one of the most popular versions of oracle database. The “g” stood for “grid computing” which supports clusters of servers that are treated as a single unit.

First, let’s look at system requirements for Oracle 11g database.
Operating System Requirements (Any of it):-

Hardware Prerequisites:-

Oracle 11g version is now not available under Download tab on official website of oracle, please use following direct link to download it from Oracle corporation website.

Direct Download Link for Oracle 11g

You can also search for “oracle database xe prior release archive” in Google Search to go to above download link.

On download page, you will see 3 options for different operating systems. I have windows 64 bit so I will go with first option.
Please go with respective file type based on your processer 32/64 bit.
To check processer type go to file Explore, right click on This PC/My Computer –> Properties –> System type

In the pop window, you need to accept Oracle License Agreement & click on checkbox.

In the next page, it will display login option for Oracle account. I have already created my oracle account so I will login with my account details. After successful login, it will start download automatically.

If you don’t have oracle account, don’t worry. Its free & you can create it by just providing your email id & some personal details.

Once download is completed, you will see OracleXE112_Win64 zip file in your default download directory.

Oracle 11g Installation

Now we will start installation process for Oracle 11g. First you need to unzip downloaded file. Right click on zip file & unzip it using any software or windows option.

Inside unzip folder, you will have DISK1 folder when you go inside it you will see your setup.exe file for Oracle 11g Database.
To Start installation process, double click on steup.exe or right click on it & “Run as Administrator“. Please make sure your windows user has administrator access to install software on your system.

After confirming “do you want to allow this app to make changes to your device“, you will see Welcome Page for Oracle 11g installation, just click on Next.

In License Agreement page, select “I accept the terms in license agreement” & click on Next.

Now you have to select setup location of your oracle 11g, by default it goes to C:\orclexe. You can click on Browse & change the location for setup as per your preference however I will go with default location. Now go ahead & click on Next.

In the next page you have to set the password for your oracle database which will be used for SYS & SYSTEM database account, please make sure you note down the login password. Now Click on Next.

In next windows it will give you Summary for Oracle 11g database configuration, review it & Click on Install.
Now your installation process should be started which will take some time based on your system configuration, please relax & wait till it is completed.
Note: – Oracle stopped support for oracle 11g version so you might run into issue with your latest version of windows however oracle 11g is light version out of all oracle database version & you should definitely try once, in case of any error you can try with another version like oracle 19c.

This is going to be last page for your oracle database installation if you don’t run into any issue. Now click on Finish to complete your setup.

Verify Oracle 11g Setup

Now we are going to check our oracle 11g database. Go to windows command line (cmd) & run “tnsping XE“. You will get OK message as shown in below screen-shot.

Now got to Windows Start -> Run. In Open box type “Services.msc” & hit entre. In Services window scroll-down & look for Oracle. As given in screen-shot “OracleServiceXE” & “OracleXETNSListener” should be running. By default, both services will be setup as Automatic & server will be started automatically. You can set it manually in case your system is running slow & you don’t need oracle database running all time. You can start it manually whenever you need it.

Connect to Oracle 11g

Web Interface:- You can connect to oracle 11g database using Web Interface. Go to Desktop & click on Shortcut “Get Started with Oracle Database 11g Express Edition“.

In case of any error please checkout below link, we have covered all common database connection errors in below post.

Oracle 11g Database Connection Errors

Now go back to desktop & again double click on Shortcut “Get Started with Oracle Database 11g Express Edition”. Oracle web console will be opened in default web browser. Not click on “Application Express“.

Login with SYSTEM username & password which you set while installation (That’s why I asked to make a note of password while installation process).
In this page, you can create new workspace. To create new workspace, use database user as Create New ( new database user will be created). Give name for new database (MYDB) & set username & password for new database (make a note of it). Now click on Create Workspace.
After “Successfully created workspace MYDB. To begin, click here to login” message, click on “click here”

Login using new database username & password which you set while creating new workspace & click on Login.
Now click on “SQL Workshop“, Go to SQL Commands.It will open sql editor where you can write your SQL Query, now write sql query “select sysdate from dual” & click on Run. You will see output of your select as “Results“. That’s how you can connect to oracle 11g database using web Interface (its only available with old version like 11g).

SQL Plus:- Go to Windows Serach bar & search for “Run SQL” , click “Run SQL command line“. You can use any account to connect to database, I am going to use SYSTEM so type “connect SYSTEM“. In next step you need to enter password for SYSTEM username (password will not be visible so just type your password & hit enter).

Same way lets run one test sql, “SELECT SYSDATE FROM DUAL“. You will get current date as output.

SQL Developer:- SQL developer is database client which is used to connect to oracle database. Open your sql developer & click on “New Connection“, please fill-up all details as shown in screen-shot, save new connection & click on connect button to connect to MYDB.

Please check out below post for SQL Developer installation on windows.

How to Install Oracle SQL Developer on Windows 10

To execute query Write “select * from emp” in sql worksheet & click on RUN icon, you should able to see data for your emp table.

That’s it. Hope this article will help you to install oracle 11g database on your windows system. Happy Learning !!

Please don’t forget to leave your feedback in below comments section!!