Setup Oracle 11gR2 for Redhat Linux as 4 Update 7 x64

Setup Oracle 11gR2 for Redhat Linux as 4 Update 7 x64

1. Checking Linux version.

[Email protected] ~]# uname-a
Linux redhat4.7 2.6.9-78.el #1 Wed Jul 9 15:26:38 EDT-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.2compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (+ bit) elfutils-libelf-0.97elfutils-libelf-devel-0.97expat-1.95.7gcc-3.4.6gcc-c++- 3.4.6glibc-2.3.4-2.41glibc-2.3.4-2.41 (+ bit) glibc-common-2.3.4glibc-devel-2.3.4glibc-headers-2.3.4libaio-0.3.105libaio-0.3.105 (+ bit) libaio-devel-0.3.105libaio-devel-0.3.105 (+ bit) libgcc-3.4.6libgcc-3.4.6 (32-bit) libstdc++-3.4.6libstdc++-3.4.6 ( + bit) Libstdc++-devel 3.4.6make-3.80numactl-0.6.4.x86_64pdksh-5.2.14sysstat-5.0.5

[Email protected] ~]# Rpm-qa|grep binutils
binutils-2.15.92.0.2-25

[Email protected] rpms]# Rpm-qa|grep Sysstat
[Email protected] rpms]#

/media/cdrecorder/redhat/rpms
[Email protected] rpms]# Cd/media/cdrecorder/redhat/rpms
[[email protected] rpms]# ls sysstat-5.0.5-19.el4.x86_64.rpm
sysstat-5.0.5-19.el4.x86_64.rpm
[[email protected] rpms]# ls glibc-common-2.3.4-2.41.x86_64.rpm
glibc-common-2.3.4-2.41.x86_64.rpm
[Email protected] 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%]
[Email protected] 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.

[Email protected] ~]# 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

[Email protected] ~]# vi/etc/hosts

# don't remove the following line, or various programs
# that require network functionality would fail.
127.0.0.1 localhost.localdomain localhost
192.168.10.201 redhat4.7

[Email protected] ~]# 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.

[Email protected] ~]# Groupadd Oinstall
[[email protected] ~]# Groupadd DBA

[Email protected] ~]# useradd-g oinstall-g dba Oracle
[Email protected] ~]# passwd Oracle

5. Configuring Kernel Parameters.

[Email protected] ~]# vi/etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux
#
# for binary values, 0 are 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 would 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 (performance-related)
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

[Email protected] ~]# 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 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

[Email protected]alhost ~]# 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

[Email protected] ~]# 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 is 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.

[Email protected] ~]# mkdir/u01/app/oracle-p
[Email protected] ~]# chown-r oracle:oinstall/u01
[Email protected] ~]# chmod-r 755/u01

Uploading Setup files to Linux by FTP.

[Email protected] ~]# Unzip Linux.x64_11gR2_database_1of2.zip
[Email protected] ~]# Unzip Linux.x64_11gR2_database_2of2.zip

Setting xhost display.

[Email protected] soft]# W
15:32:37 up 2:09, 4 users, load average:0.32, 1.16, 0.79
USER TTY from [email protected] IDLE jcpu PCPU
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

[Email protected] soft]# Xhost +
Access control disabled, clients can connect from any host
[Email protected] soft]# export display=192.168.10.1:0.0

Installing Oracle software.

[Email protected] database]# su-oracle
[Email protected] ~]$ cd/home/oracle/soft/database/
[Email protected] database]$./runinstaller

... start OUI windows.

Check installing Failed Message.

Swap Size

[[email protected] ~]# dd If=/dev/zero of=/home/oracle/swap bs=1024 count=2048000
2048000+0 Records in
2048000+0 Records out
[Email protected] ~]# Mkswap/home/oracle/swap
Setting up Swapspace version 1, size = 2097147 KB
[Email protected] ~]# free-m
Total used free shared buffers Cached
mem:3943 3865 77 0 11 3416
-/+ buffers/cache:436 3506
swap:2047 0 2047
[Email protected] ~]# Swapon/home/oracle/swap
[[email protected] ~]# grep swaptotal/proc/meminfo
swaptotal:4144432 KB
[Email protected] ~]# Vi/etc/fstab

/home/oracle/swap swap swap defaults 0 0

Elfutils-libelf-devel

Unixodbc-devel

[Email protected] ~]# cd/media/cdrecorder/redhat/rpms/
[[email protected] rpms]# ls elfutils-libelf-devel-0.97.1-5.x86_64.rpm
elfutils-libelf-devel-0.97.1-5.x86_64.rpm
[[email protected] rpms]# ls unixodbc-devel-2.2.11-1.rhel4.1.x86_64.rpm
unixodbc-devel-2.2.11-1.rhel4.1.x86_64.rpm
[Email protected] 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%]
[Email protected] 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%]

[Email protected] ~]# cd/u01/app/orainventory/
[Email protected] orainventory]#./orainstroot.sh
changing permissions of/u01/app/orainventory.
Adding read,write permissions for group.
Removing Read,write,execute permissions for the world.

Changing groupname of/u01/app/orainventory to Oinstall.
The execution of the script is complete.

[Email protected] orainventory]# cd/u01/app/oracle/product/11.2.0/dbhome_1/
[Email protected] dbhome_1]# sh root.sh
Running Oracle 11g root.sh script ...

The following environment variables is 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'll 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 would be performed.
Finished product-specific root actions.

Setup Oracle 11gR2 for Redhat Linux as 4 Update 7 x64