How to download Oracle 11g & 12c Database software and create your 1st Oracle Database
Things to Do:
- Make sure your laptop has minimum 8 GB of RAM (16 GB or more is recommended).
- Downloads: 7-zip to unzip, Notepad++ for writing notes.
- Register at OTN: https://www.oracle.com/technetwork/index.html – this is a must to download Oracle software.
- We’ll be installing Oracle Enterprise Edition, NOT Standard Edition or any other editions :Download & Install Cygwin: https://cygwin.com/install.html (optional, but highly recommended).
(this might not allow you to download and saying that you haven’t accepted the agreement, try again, otherwise go to the below link and try the same, but make sure to download the same version, as in the below image)
Use 7-zip to unzip these files:
11/06/17 Started downloading … 11:10 am
All the 4 downloads are going on right now:
|Created a folder: D:\Downloads\OraSoft|
|Now unzipping: win64_11gR2_database_1of2.zip|
Now unzipping: win64_11gR2_database_2of2.zip
|Completed – this is the status: D:\Downloads\OraSoft\11g|
Installing Oracle 11g (11.2)
Make sure you name the directory appropriately; follow Naming Conventions.
Here we are naming it: D:\app\ora11g
For 12c it’ll be D:\app\ora12.1 (12.1) D:\app\ora12.2 (12.2)
INSTALLING ORACLE 11G STEPS
This should be your location:
Now right click on Setup – and Run as Administrator
as soon as you click, it’ll give you a black screen, which’ll vanished in a while too.
We’ll be selecting the 2nd option, only installing the Oracle Software.
the NEXT screen:
Here you’ll select the 1st option
English will you your language
And now you’ll select the Database Edition:
We’ll select ENTERPRISE EDITION, you can pick STANDARD too.
You can also save your Response File
Now this screen:
Can click Details to see what’s happening behind the scene.
Gives you the log file location
Should record your log file location:
Log File: C:\Program Files\Oracle\Inventory\logs\installActions2018-03-03_11-17-32AM.
log Copy files … usually takes most of the time.
Keep monitoring the log file (Details)
Log files location: C:\Program Files\Oracle\Inventory\logs
File Name: installActions2017-11-06_01-38-49PM.log
Check these files and try to see, what’s been installed, this’ll give you a lot of beneficial information.
Open these files using Notepad++
You can find all the details about what’s been installed and their corresponding versions too.
Oracle Partitioning 220.127.116.11.0
Enterprise Edition Options 18.104.22.168.0
Oracle Database 11g 22.214.171.124.0
This is what got installed:
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle – OraDb11g_home1
Now let’s go to: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle – OraDb11g_home1\Configuration and Migration Tools
And RIGHT click: Database Configuration Assistant
Run as Administrator
Now we are going to create an 11g Oracle Database
Same as database name
Log file location:
You can find all the log files over here.
Your 1st database ora11g has been created.
All log files:
Search for cmd just type cmd and press enter
Here type sqlplus
Your database is up & ready.
Now need to check at Windows, how to make sure:
Start Task Manager
Sort on the 1st column: Name
Click there and then press O
Quite self-explanatory, please do Google each and everything to understand more about them.
Also make sure that nothing is Automatic, that you can do from Services, because this’ll slow your machine or can leave to auto too.
Highlighted is the Oracle Database
Click Services button on the bottom, Click Standard (tab/bottom), sort by Name, click O
Only change Automatic to Manual, don’t touch anything else.
Setting the ORACLE_HOME environment variable on the OpenPages GRC Platform application servers