SHIFT

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

User Tools

Site Tools


Sidebar

Sponsor:

Would you like to sponsor this site?
Or buy me a beer?:


Recently Changed Pages:

View All Pages
View All Q Pages


View All Tags


Sign up for Q to post comments.





WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Terms And Conditions for Q users


Pages with comments

PageDateDiscussionTags
2019/06/22 10:36 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 3 Comments
2017/04/20 15:28 1 Comment
2017/04/20 15:23 1 Comment
2017/04/19 14:44 1 Comment
2017/04/17 20:10 1 Comment
2017/04/17 20:07 1 Comment
2017/04/17 19:58 1 Comment
2017/04/17 19:52 1 Comment

View All Comments

oracledbinstallredhat

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:

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

These packages are not required any more but I checked for them anyway to prevent any problems:

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)

These packages were available but in a newer version:

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

These packages were installed extra:

[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

Oracle groups and Users

Add these groups and users:

[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.

Make sure the oracle user has the correct limits for handling files and processes:

/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

Oracle Kernel Settings

These are the default kernel settings:

[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

Add these changes to the kernel settings:

# 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

Directories

Create this file structure and set the correct permissions:

[root@oraclebox Server]# mkdir /opt/oracle
[root@oraclebox Server]# chown -R oracle:oinstall /opt/oracle/
[root@oraclebox Server]# chmod -R 775 /opt/oracle/

X settings

Log in as oraqcle user and make sure you can use the X environment:

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

You can now start the installation.

Resources

You could leave a comment if you were logged in.
oracledbinstallredhat.txt · Last modified: 2013/05/11 17:01 by sjoerd