SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


oracledbinstallredhat
Differences

This shows you the differences between two versions of the page.

Link to this comparison view

oracledbinstallredhat [2013/05/11 17:01] (current)
sjoerd created
Line 1: Line 1:
 += Installing Oracle 11g R2 on Red Hat 5 =
  
 += Red Hat Installation =
 +Red Hat 5.7 64 bits installed with default settings, with development server software group added during the installation. ​
 +
 += Oracle Installation =
 +
 +== Required Packages ==
 +> Note: Starting with Oracle Database 11g Release 2 (11.2.0.2), all the 32-bit packages, except for gcc-32bit-4.3,​ listed in the following table are no longer required for installing a database on Linux x86-64. Only the 64-bit packages are required. However, for any Oracle Database 11g release before 11.2.0.2, both the 32-bit and 64-bit packages listed in the following table are required.
 +
 +These packages are required:
 +<​code>​
 +rpm -q binutils-2.17.50.0.6
 +rpm -q compat-libstdc++-33-3.2.3
 +rpm -q elfutils-libelf-0.125
 +rpm -q elfutils-libelf-devel-0.125
 +rpm -q gcc-4.1.2
 +rpm -q gcc-c++-4.1.2
 +rpm -q glibc-2.5-24
 +rpm -q glibc-common-2.5
 +rpm -q glibc-devel-2.5
 +rpm -q glibc-headers-2.5
 +rpm -q ksh-20060214
 +rpm -q libaio-0.3.106
 +rpm -q libaio-devel-0.3.106
 +rpm -q libgcc-4.1.2
 +rpm -q libstdc++-4.1.2
 +rpm -q libstdc++-devel 4.1.2
 +rpm -q make-3.81
 +rpm -q sysstat-7.0.2
 +</​code>​
 +
 +These packages are not required any more but I checked for them anyway to prevent any problems:
 +<​code>​
 +rpm -q compat-libstdc++-33-3.2.3 (32 bit)
 +rpm -q glibc-2.5-24 (32 bit)
 +rpm -q glibc-devel-2.5 (32 bit)
 +rpm -q libaio-0.3.106 (32 bit)
 +rpm -q libaio-devel-0.3.106 (32 bit)
 +rpm -q libgcc-4.1.2 (32 bit)
 +rpm -q libstdc++-4.1.2 (32 bit)
 +</​code>​
 +
 +These packages were available but in a newer version:
 +<​code>​
 +rpm -ivh elfutils-libelf-0.125 ​ (137-3)
 +rpm -ivh elfutils-libelf-devel-0.125 (137-3)
 +rpm -ivh glibc-2.5-24 (65)
 +rpm -ivh glibc-2.5-24 (65)
 +rpm -ivh ksh-20060214 (20100202-1.el5_6.6)
 +rpm -ivh libaio-devel-0.3.106
 +rpm -ivh libaio-devel-0.3.106
 +rpm -ivh sysstat-7.0.2
 +</​code>​
 +
 +These packages were installed extra:
 +<​code>​
 +[root@oraclebox Server]# rpm -ivh libaio-devel-0.3.106-5.*
 +warning: libaio-devel-0.3.106-5.i386.rpm:​ Header V3 DSA signature: NOKEY, key ID 37017186
 +Preparing... ​               ###########################################​ [100%]
 +   ​1:​libaio-devel ​          ###########################################​ [ 50%]
 +   ​2:​libaio-devel ​          ###########################################​ [100%]
 +[root@oraclebox Server]# rpm -q libaio-devel
 +libaio-devel-0.3.106-5
 +libaio-devel-0.3.106-5
 +
 +[root@oraclebox Server]# rpm -ivh sysstat-7.0.2-11.el5.x86_64.rpm
 +warning: sysstat-7.0.2-11.el5.x86_64.rpm:​ Header V3 DSA signature: NOKEY, key ID 37017186
 +Preparing... ​               ###########################################​ [100%]
 +   ​1:​sysstat ​               ###########################################​ [100%]
 +[root@oraclebox Server]# rpm -q sysstat
 +sysstat-7.0.2-11.el5
 +</​code>​
 +
 +== Oracle groups and Users ==
 +Add these groups and users:
 +<​code>​
 +[root@oraclebox Server]# groupadd oinstall
 +[root@oraclebox Server]# groupadd dba
 +[root@oraclebox Server]# groupadd oper
 +[root@oraclebox Server]# useradd -g oinstall -G dba,oper oracle
 +[root@oraclebox Server]# passwd oracle
 +Changing password for user oracle.
 +New UNIX password:
 +BAD PASSWORD: it is based on a dictionary word
 +Retype new UNIX password:
 +passwd: all authentication tokens updated successfully.
 +</​code>​
 +
 +Make sure the oracle user has the correct limits for handling files and processes:
 +<​code>​
 +/​etc/​security/​limits.conf file:
 +
 +oracle ​             soft    nproc   2047
 +oracle ​             hard    nproc   16384
 +oracle ​             soft    nofile ​ 1024
 +oracle ​             hard    nofile ​ 65536
 +oracle ​             soft    stack   10240
 +</​code>​
 +
 +== Oracle Kernel Settings ==
 +These are the default kernel settings:
 +<​code>​
 +[root@oraclebox Server]# cat /​etc/​sysctl.conf | grep ^[a-z]
 +net.ipv4.ip_forward = 0
 +net.ipv4.conf.default.rp_filter = 1
 +net.ipv4.conf.default.accept_source_route = 0
 +kernel.sysrq = 0
 +kernel.core_uses_pid = 1
 +net.ipv4.tcp_syncookies = 1
 +kernel.msgmnb = 65536
 +kernel.msgmax = 65536
 +kernel.shmmax = 68719476736
 +kernel.shmall = 4294967296
 +</​code>​
 +
 +Add these changes to the kernel settings:
 +<​code>​
 +# Added for oracle installation
 +fs.aio-max-nr = 1048576
 +fs.file-max = 6815744
 +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 = 1048586
 +</​code>​
 +
 +== Directories ==
 +
 +Create this file structure and set the correct permissions:​
 +<​code>​
 +[root@oraclebox Server]# mkdir /opt/oracle
 +[root@oraclebox Server]# chown -R oracle:​oinstall /​opt/​oracle/​
 +[root@oraclebox Server]# chmod -R 775 /​opt/​oracle/​
 +</​code>​
 +
 +== X settings ==
 +
 +Log in as oraqcle user and make sure you can use the X environment:​
 +<​code>​
 +login as: oracle
 +oracle@oraclebox'​s password:
 +/​usr/​bin/​xauth: ​ creating new authority file /​home/​oracle/​.Xauthority
 +[oracle@oraclebox ~]$ umask
 +0022
 +[oracle@oraclebox ~]$ xclock
 +
 +[oracle@oraclebox ~]$ echo $DISPLAY
 +localhost:​11.0
 +[oracle@oraclebox ~]$ xclock
 +[oracle@oraclebox ~]$ export ORACLE_BASE=/​opt/​oracle
 +</​code>​
 +
 +You can now start the installation.
 +
 += Resources =
 +http://​docs.oracle.com/​cd/​E11882_01/​install.112/​e24326/​toc.htm \\
 +
 +{{tag>​linux oracle}}
oracledbinstallredhat.txt ยท Last modified: 2013/05/11 17:01 by sjoerd