Install the Oracle database correctly under fc6

The following article describes how to install the Oracle database under fc6. The following article will be meaningful to you. I hope you will gain some benefits after browsing.

1. Check the Machine Software System:

Log on to fc6 as root

Uname-r check that the kernel version is later than 2.6.18

Binutils-2.17.50.0.6-2.el5

Run

 
 

  
  
rpm -q compat-libstdc++ elfutils-libelf elfutils-libelf-devel 
glibc glibc-common glibc-devel gcc \  
  
  
gcc-c++ libaio libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC 
 
 

Minimum Software Version:

 
 

  
  
compat-libstdc++-33-3.2.3-61  
  
  
elfutils-libelf-0.125-3.el5  
  
  
elfutils-libelf-devel-0.125  
  
  
glibc-2.5-12  
  
  
glibc-common-2.5-12  
  
  
glibc-devel-2.5-12  
  
  
gcc-4.1.1-52  
  
  
gcc-c++-4.1.1-52  
  
  
libaio-0.3.106  
  
  
libaio-devel-0.3.106  
  
  
libgcc-4.1.1-52  
  
  
libstdc++-4.1.1  
  
  
libstdc++-devel-4.1.1-52.e15  
  
  
make-3.81-1.1  
  
  
sysstat-7.0.0  
  
  
unixODBC-2.2.11  
  
  
unixODBC-devel-2.2.11 
 
 

2. Check the minimum requirements of the hardware system:

Log on to fc6 as root

Grep MemTotal/proc/meminfo memory size 1 GB

1574360 KB

Grep SwapTotal/proc/meminfo swap zone size 2 GB

3418720 KB

Hard Disk Space between GB and GB

3. Create an Oracle group and user account to install Oracle)

Log on to fc6 as root

 
 

  
  
# /usr/sbin/groupadd oinstall  
  
  
# /usr/sbin/groupadd dba  
  
  
# /usr/sbin/useradd -m -g oinstall -G dba Oracle  
  
  
# id Oracle  
  
  
uid=501(Oracle) gid=501(oinstall) groups=501(oinstall),502(dba)  
  
  
# passwd Oracle 
 
 

Show input password:

 
 

  
  
Changing password for user Oracle.  
  
  
New password:  
  
  
Retype new password:  
  
  
passwd:all authentication tokens updated successfully. 
 
 

4. Create a directory

Log on to fc6 as root

 
 

  
  
mkdir -p /Oracle/app/  
  
  
chown -R Oracle:oinstall /Oracle/app/  
  
  
chmod -R 775 /Oracle/app/ 
 
 

5. Configure Linux Kernel Parameters

Log on to fc6 as root

 
 

  
  
#vi /etc/sysctl.conf 
 
 

Add the following content to the file:

 
 

  
  
kernel.shmall = 2097152 
  
  
kernel.shmmax = 2147483648 
  
  
kernel.shmmni = 4096 
  
  
kernel.sem = 250 32000 100 128  
  
  
fs.file-max = 65536 
  
  
net.ipv4.ip_local_port_range = 1024 65000  
  
  
net.core.rmem_default = 4194304 
  
  
net.core.rmem_max = 4194304 
  
  
net.core.wmem_default = 262144 
  
  
net.core.wmem_max = 262144 
 
 

Save and exit

 
 

  
  
# /sbin/sysctl -p 
 
 

Run the following command as the root user to verify your settings:

 
 

  
  
# /sbin/sysctl -a | grep shm  
  
  
kernel.shmmni = 4096 
  
  
kernel.shmall = 2097152 
  
  
kernel.shmmax = 2147483648 
  
  
kernel.shm-use-bigpages = 0 
  
  
# /sbin/sysctl -a | grep sem  
  
  
kernel.sem = 250 32000 100 128  
  
  
# /sbin/sysctl -a | grep file-max  
  
  
fs.file-max = 65536 
  
  
# /sbin/sysctl -a | grep ip_local_port_range  
  
  
net.ipv4.ip_local_port_range = 1024 65000 
 
 

6. Set Shell restrictions for Oracle users

Log on to fc6 as root

 
 

  
  
#vi /etc/security/limits.conf 
 
 

Join:

 
 

  
  
Oracle soft nproc 2047  
  
  
Oracle hard nproc 16384  
  
  
Oracle soft nofile 1024  
  
  
Oracle hard nofile 65536 
 
 

Save and exit

 
 

  
  
#vi /etc/pam.d/login 
 
 

Join:

 
 

  
  
session required /lib/security/pam_limits.so  
  
  
session required pam_limits.so 
 
 

Save and exit

 
 

  
  
#vi /etc/profile 
 
 

Join:

 
 

  
  
if [ $USER = "Oracle" ]; then  
  
  
if [ $SHELL = "/bin/ksh" ]; then  
  
  
ulimit -p 16384  
  
  
ulimit -n 65536  
  
  
else  
  
  
ulimit -u 16384 -n 65536  
  
  
fi  
  
  
fi 
 
 

Save and exit

7. Oracle environment variable Configuration:

Log On As an Oracle user:

Add Oracle_BASE to the logon configuration file in. bash_profile;

 
 

  
  
umask 022  
  
  
export Oracle_BASE=/u01/app/Oracle  
  
  
export Oracle_SID=sales 
 
 

8. Install Oracle 11g. The above content is an introduction to @. I hope you will get some benefits.