How to Upgrade Oracle 11g & 12c

Downloading  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).

11g

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

(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)

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Use 7-zip to unzip these files:

11/06/17 Started downloading … 11:10 am

12c

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

12.1: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

All the 4 downloads are going on right now:

Windows

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

ORACLE_BASE: D:\app\ora11g\product\11.2.0\dbhome_1

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.

Performing Pre-checks:

Passed

You can also save your Response File

Click Finish

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.

Excerpt:
Oracle Partitioning 11.2.0.1.0

Enterprise Edition Options 11.2.0.1.0
Oracle Database 11g 11.2.0.1.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

yes

Log file location:

cywgin

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

Type system/ora11g

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

https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.3.0/com.ibm.swg.ba.cognos.op_installation_guide.7.3.0.doc/t_camphor_setting_environment_variables_ora.html

……contd.