In Oracle : Prepare Linux for Oracle 10g Installation

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA

-> Prepare Linux for Oracle 10g Installation

 

 Prepare Linux for Oracle 10g Installation

 

 

Note: This document mustn't be seen as a 10g new feature, but if you want to test the Oracle 10g new features, you probably prefer using Linux as a OS.

 

For a complete check please download RDA utility from Metalink and test if the OS is ready for an Oracle 10g Installation. .

Here are some Metalink Notes you can use:

 

250262.1 -> RDA 4 - Health Check / Validation Engine Guide

330344.1 -> Remote Diagnostic Agent (RDA) 4 - Training

To collect information for a 10g installation you have to run the following command:

 

./rda.sh -T hcve 

 

 

In my case after a full fresh Oracle Linux (2.6.9-42.0.0.0.1.ELhugemem #1 SMP  i686 GNU/Linux) installation on a Pentium4 system, I have to do the following (all is done by root ):

 

1. Create the Oracle Groups and User Account

 

/usr/sbin/groupadd dba

/usr/sbin/groupadd oracle
/usr/sbin/useradd -m -g dba -G oracle oracle
id oracle

 

NOTE: 

The User ID and Group IDs must be the same on all cluster nodes (if a RAC will be installed). Using the information from the id oracle command, create the Oracle Groups and User Account on the remaining cluster nodes: 

 

Example:
/usr/sbin/groupadd -g 501

oinstall/usr/sbin/groupadd -g 502 dba

/usr/sbin/useradd -m -u 501 -g dba -G oracle oracle

 

 

2. Set the password on the oracle account:

 

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

 

 

3. Create Mount Points

 

mkdir -p /ORACLE10g

chown -R oracle:dba /ORACLE10g

chmod -R 775 /ORACLE10g

 

 

4. Configure Kernel Parameters

 

cat >> /etc/sysctl.conf << EOF
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 658576
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 1048536
net.core.wmem_max = 1048536
EOF

/sbin/sysctl -p

 

 

5. Setting Shell Limits for the oracle User

cat >> /etc/security/limits.conf << EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login << EOF
session required /lib/security/pam_limits.so
EOF
For Red Hat Enterprise Linux releases, use the following:
cat >> /etc/profile << EOF
if [ \$USER = "oracle" ]; then 
  if [ \$SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
    umask 022
fi
EOF

cat >> /etc/csh.login << EOF
if ( \$USER == "oracle" ) then
  limit maxproc 16384
  limit descriptors 65536
  umask 022
endif
EOF

 

 

6. Configure /etc/hosts (if needed)

 

vi /etc/hosts

gedit /etc/hosts

 

If local host is named supposing linux1 after the /etc/hosts configuration type:

 

ping linux1   -> this command doesn't have to return the loopback address (127.0.0.1).

 

 

In-Oracle.com  -> Oracle DBA

-> Prepare Linux for Oracle 10g Installation

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.