Tuesday 25 May 2021

Installation of Oracle Database 11.2.0.2 in Oracle Linux 6 inside Virtual Machine


Do you know ..that 11.2.0.3 patch set is a full release..? 

There is no need to install 11.2.0.1 software


See this Note 1189783.1 : Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2

"Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of a set of files that replaced files in an existing Oracle home. Beginning with Oracle Database 11g Release 2, patch sets are full installations that replace existing installations."


The software can be downloaded from My Oracle support: Patch:10404530

Please select your platform before downloading (Click on "Platform or Language" drop down menu)

You can check README and download the modules u need like RAC, database, etc.. as i only need grid/Clusterware, database . I downloaded parts 1,2,3

Oracle Database (includes Oracle Database and Oracle RAC)

Note: you must download both zip files to install Oracle Database.

unzip p10098816_112020_Linux-x86-64_1of7.zip

unzip p10098816_112020_Linux-x86-64_2of7.zip

unzip p10098816_112020_Linux-x86-64_3of7.zip


[root@ol6 ~]# yum install oracle-rdbms-server-11gR2-preinstall

[root@ol6 yum.repos.d]# cat  /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.XXX   ol6.localdomain ol6

[oracle@ol6 database]$ export DISPLAY=:0

[oracle@ol6 database]$ xhost +

access control disabled, clients can connect from any host

[oracle@ol6 database]$ ll

total 52

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 doc

drwxrwx--- 1 root vboxsf  4096 Nov 16  2010 install

-rwxrwx--- 1 root vboxsf 27303 Nov 16  2010 readme.html

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 response

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 rpm

-rwxrwx--- 1 root vboxsf  3226 Nov 16  2010 runInstaller

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 sshsetup

drwxrwx--- 1 root vboxsf  8192 Nov 16  2010 stage

-rwxrwx--- 1 root vboxsf  5394 Nov 16  2010 welcome.html

[oracle@ol6 database]$ ./runInstaller 

Starting Oracle Universal Installer...

and for this installation screenshots you can refer to 


or you can simply install software without database and later create database using DBCA.

My DB :

[oracle@ol6 ~]$ 
[oracle@ol6 ~]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 25 19:26:58 2021

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


Connected to:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

SQL> select name from v$database;

NAME
---------
MANGO

SQL> 





No comments:

Post a Comment