Saturday, 2 January 2021

Oracle Database 11gR2 (11.2.0.4) installation on Linux 7

Before you start, make sure your Linux server meets the minimum hardware requirements:

Memory and Disk Space Requirements

  • Minimum: 1 GB of RAM
  • 4.7 GB of disk space for the software installation
  • 1.7 GB of disk space for the Database files
  • At least 1 GB of disk space in the /tmp directory
  • Swap space recommendation:

     Available RAM                                   Swap Space Required
1. Between 1 GB and 2 GB                              1.5 times the size of the RAM
2. Between 2 GB and 16 GB                             Equal to the size of the RAM
3. More than 16 GB                                          16 GB


Automatic Memory Management
Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/dev/shm)and file descriptors. The shared memory should be sized to be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on that computer.


To determine the amount of shared memory available, enter the following command:


[root@joshi ~]# df -h /dev/shm/
Filesystem Size Used Avail Use% Mounted on
tmpfs 1.9G 385M 1.5G 21% /dev/shm

System Architecture
To determine whether the system architecture can run the software, enter the following command:

[root@joshi ~]# uname -m
x86_64


Checking the Software Requirements


  • Starting with Oracle Database 11g Release 2 (11.2.0.4), Oracle Linux 7 and Red Hat Enterprise Linux 7 are supported on Linux x86-64.

[root@joshi ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)

[root@joshi ~]# cat /proc/version
Linux version 3.10.0-1160.el7.x86_64 (mockbuild@jenkins-172-17-0-2-64d560bf-4b94-4bde-a5f8-f55888be27a0) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-44.0.3) (GCC) ) #1 SMP Thu Oct 1 17:21:35 PDT 2020
[root@joshi ~]#


  • kernel requirements for Oracle Database 11g Release 2 (11.2): On Oracle Linux 7 3.8.13-33.el7uek.x86_64 or later

[root@joshi ~]# uname -r
3.10.0-1160.el7.x86_64


  • The following or later version of packages for Oracle Linux 7, and Red Hat Enterprise Linux 7 must be installed:
binutils-2.23.52.0.1-12.el7.x86_64 
compat-libcap1-1.10-3.el7.x86_64  
compat-libstdc++-33-3.2.3-71.el7.i686 
compat-libstdc++-33-3.2.3-71.el7.x86_64 
gcc-4.8.2-3.el7.x86_64 
gcc-c++-4.8.2-3.el7.x86_64 
glibc-2.17-36.el7.i686 
glibc-2.17-36.el7.x86_64 
glibc-devel-2.17-36.el7.i686 
glibc-devel-2.17-36.el7.x86_64 ksh 
libaio-0.3.109-9.el7.i686 
libaio-0.3.109-9.el7.x86_64 
libaio-devel-0.3.109-9.el7.i686 
libaio-devel-0.3.109-9.el7.x86_64 
libgcc-4.8.2-3.el7.i686 
libgcc-4.8.2-3.el7.x86_64 
libstdc++-4.8.2-3.el7.i686 
libstdc++-4.8.2-3.el7.x86_64 
libstdc++-devel-4.8.2-3.el7.i686 
libstdc++-devel-4.8.2-3.el7.x86_64 
libXi-1.7.2-1.el7.i686 
libXi-1.7.2-1.el7.x86_64 
libXtst-1.2.2-1.el7.i686 
libXtst-1.2.2-1.el7.x86_64
make-3.82-19.el7.x86_64 
sysstat-10.1.5-1.el7.x86_64
unixODBC-2.3.1-6.el7.x86_64 or later
unixODBC-2.3.1-6.el7.i686 or later
unixODBC-devel-2.3.1-6.el7.x86_64 or later
unixODBC-devel-2.3.1-6.el7.i686 or later


Create Required Operating System Groups and Users

groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle


If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command: 

 usermod -g oinstall -G dba oracle



Configuring Kernel Parameters and Resource Limits

For production database systems, Oracle recommends that you tune these values to optimize the performance of the system.

edit the /etc/sysctl.conf file, and add or edit lines similar to the following:

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576


Enter the following command to change the current values of the kernel parameters:

/sbin/sysctl -p


Add the following lines to the "/etc/security/limits.conf" file.


oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240


Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/11.2.0.4/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01


Automatic Setup
If you plan to use the "yum install oracle-rdbms-server-11gR2-preinstall" package to perform all your prerequisite setup, issue the following command.

yum install oracle-rdbms-server-11gR2-preinstall


Download Software



Once you’ve downloaded the software, unzip both files to a staging area:

unzip p13390677_112040_Linux-x86-64_1of7.zip -d /soft/oracle
unzip p13390677_112040_Linux-x86-64_2of7.zip -d /soft/oracle




Installation

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

[oracle@joshi database]$ ls -ltrh
total 48K
drwxr-xr-x.  2 oracle oinstall   29 Aug 27  2013 sshsetup
-rwxr-xr-x.  1 oracle oinstall 3.2K Aug 27  2013 runInstaller
drwxr-xr-x.  2 oracle oinstall   34 Aug 27  2013 rpm
drwxr-xr-x.  2 oracle oinstall   61 Aug 27  2013 response
-rw-r--r--.  1 oracle oinstall  30K Aug 27  2013 readme.html
drwxr-xr-x. 14 oracle oinstall 4.0K Aug 27  2013 stage
-rw-r--r--.  1 oracle oinstall  500 Aug 27  2013 welcome.html
drwxr-xr-x.  4 oracle oinstall 4.0K Aug 27  2013 install

[oracle@joshi database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 36822 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3934 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-01-03_12-40-53AM. Please wait ...[oracle@joshi database]$

















During the link phase you will encounter an error invoking the "ins_emagent.mk" file.
 
To fix this, edit the "$ORACLE_HOME/sysman/lib/ins_emagent.mk", doing a search and replace for the line shown below.


FROM:
$(MK_EMAGENT_NMECTL)


TO :
$(MK_EMAGENT_NMECTL) -lnnz11






[root@joshi ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.


Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@joshi ~]# /u01/app/oracle/product/11.2.0.4/db_1/root.sh
Performing root user operation for Oracle 11g


The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.4/db_1


Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...




Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.




Reference link ;
https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#CHDJFDAJ

No comments:

Post a Comment