Setup Oracle 11gR2 for Redhat Linux AS 4 Update 7 x64
1. checking linux version.
[root@localhost ~]# uname -a
Linux redhat4.7 2.6.9-78.EL #1 Wed Jul 9 15:26:38 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
2. linking oracle installing document.
http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCGGJAB
The following or later version of packages for Oracle Linux 4 and Red Hat Enterprise Linux 4 must be installed:
binutils-2.15.92.0.2 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) elfutils-libelf-0.97 elfutils-libelf-devel-0.97 expat-1.95.7 gcc-3.4.6 gcc-c++-3.4.6 glibc-2.3.4-2.41 glibc-2.3.4-2.41 (32 bit) glibc-common-2.3.4 glibc-devel-2.3.4 glibc-headers-2.3.4 libaio-0.3.105 libaio-0.3.105 (32 bit) libaio-devel-0.3.105 libaio-devel-0.3.105 (32 bit) libgcc-3.4.6 libgcc-3.4.6 (32-bit) libstdc++-3.4.6 libstdc++-3.4.6 (32 bit) libstdc++-devel 3.4.6 make-3.80 numactl-0.6.4.x86_64 pdksh-5.2.14 sysstat-5.0.5
[root@localhost ~]# rpm -qa|grep binutils
binutils-2.15.92.0.2-25
[root@localhost RPMS]# rpm -qa|grep sysstat
[root@localhost RPMS]#
/media/cdrecorder/RedHat/RPMS
[root@localhost RPMS]# cd /media/cdrecorder/RedHat/RPMS
[root@localhost RPMS]# ls sysstat-5.0.5-19.el4.x86_64.rpm
sysstat-5.0.5-19.el4.x86_64.rpm
[root@localhost RPMS]# ls glibc-common-2.3.4-2.41.x86_64.rpm
glibc-common-2.3.4-2.41.x86_64.rpm
[root@localhost RPMS]# rpm -ivh sysstat-5.0.5-19.el4.x86_64.rpm
warning: sysstat-5.0.5-19.el4.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]
[root@localhost RPMS]# rpm -ivh glibc-common-2.3.4-2.41.x86_64.rpm
warning: glibc-common-2.3.4-2.41.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
package glibc-common-2
3. IP configuration.
[root@localhost ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
TYPE=Ethernet
NETMASK=255.255.255.0
IPADDR=192.168.10.201
USERCTL=no
IPV6INIT=no
PEERDNS=no
[root@localhost ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.10.201 redhat4.7
[root@localhost ~]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down loopback interface: [ OK ]
Setting network parameters: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
4. Add Group User for Setup Oracle database.
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# passwd oracle
5. Configuring Kernel Parameters.
[root@localhost ~]# vi /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912 #建议大于等于物理内存1/2(与性能相关)
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
~
~
"/etc/sysctl.conf" 31L, 964C written
[root@localhost ~]# sysctl -p
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
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
error: unknown error 22 setting key 'kernel.shmmax'
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
6. Configurting /etc/security/limits.conf
[root@localhost ~]# vi /etc/security/limits.conf
#ftp hard nproc 0
#@student - maxlogins 4
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
7. Configurting /etc/pam.d/login
[root@redhat4 ~]# vi /etc/pam.d/login
#%PAM-1.0
auth required pam_securetty.so
auth required pam_stack.so service=system-auth
auth required pam_nologin.so
account required pam_stack.so service=system-auth
password required pam_stack.so service=system-auth
# pam_selinux.so close should be the first session rule
session required pam_selinux.so close
session required pam_stack.so service=system-auth
session required pam_loginuid.so
session optional pam_console.so
# pam_selinux.so open should be the last session rule
session required pam_selinux.so open
session required /lib/security/pam_limits.so
session required pam_limits.so
~
8. Configurting /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
9. Creating Directories.
[root@redhat4 ~]# mkdir /u01/app/oracle -p
[root@redhat4 ~]# chown -R oracle:oinstall /u01
[root@redhat4 ~]# chmod -R 755 /u01
10. Uploading setup files to Linux by FTP.
[root@redhat4 ~]# unzip linux.x64_11gR2_database_1of2.zip
[root@redhat4 ~]# unzip linux.x64_11gR2_database_2of2.zip
11. Setting xhost display.
[root@redhat4 soft]# w
15:32:37 up 2:09, 4 users, load average: 0.32, 1.16, 0.79
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root 192.168. 192.168.10.1 13:28 0.00s 0.00s 0.13s /usr/bin/gnome-session
root pts/1 192.168.10.1 13:34 56.00s 0.13s 0.04s -bash
root pts/2 192.168.10.1:0.0 15:27 0.00s 0.00s 0.00s w
root :0 - 14:22 ?xdm? 4:58 0.05s /usr/bin/gnome-session
[root@redhat4 soft]# xhost +
access control disabled, clients can connect from any host
[root@redhat4 soft]# export DISPLAY=192.168.10.1:0.0
12. installing oracle software.
[root@redhat4 database]# su - oracle
[oracle@redhat4 ~]$ cd /home/oracle/soft/database/
[oracle@redhat4 database]$ ./runInstaller
…start OUI windows.
Check installing Failed Message.
Swap Size
[root@redhat4 ~]# dd if=/dev/zero of=/home/oracle/swap bs=1024 count=2048000
2048000+0 records in
2048000+0 records out
[root@redhat4 ~]# mkswap /home/oracle/swap
Setting up swapspace version 1, size = 2097147 kB
[root@redhat4 ~]# free -m
total used free shared buffers cached
Mem: 3943 3865 77 0 11 3416
-/+ buffers/cache: 436 3506
Swap: 2047 0 2047
[root@redhat4 ~]# swapon /home/oracle/swap
[root@redhat4 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 4144432 kB
[root@redhat4 ~]# vi /etc/fstab
/home/oracle/swap swap swap defaults 0 0
elfutils-libelf-devel
unixODBC-devel
[root@redhat4 ~]# cd /media/cdrecorder/RedHat/RPMS/
[root@redhat4 RPMS]# ls elfutils-libelf-devel-0.97.1-5.x86_64.rpm
elfutils-libelf-devel-0.97.1-5.x86_64.rpm
[root@redhat4 RPMS]# ls unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm
[root@redhat4 RPMS]# rpm -ivh elfutils-libelf-devel-0.97.1-5.x86_64.rpm
warning: elfutils-libelf-devel-0.97.1-5.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:elfutils-libelf-devel ########################################### [100%]
[root@redhat4 RPMS]# rpm -ivh unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm
warning: unixODBC-devel-2.2.11-1.RHEL4.1.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
1:unixODBC-devel ########################################### [100%]
[root@redhat4 ~]# cd /u01/app/oraInventory/
[root@redhat4 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@redhat4 oraInventory]# cd /u01/app/oracle/product/11.2.0/dbhome_1/
[root@redhat4 dbhome_1]# sh root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_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.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.