Tuesday, April 21, 2009

Oracle for Linux Installation HOWTO

Posted on 10:52 PM by Kalum Umesh

1).create dba group and oracle user

groupadd dba
useradd -g dba oracle
mkdir /home/oracle
chown oracle:dba /home/oracle
passwd oracle

2). set 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

3).as oracle, decompress oracle10g image (oracle db 10.1.0.3)

chown oracle:dba $HOME/ship.db.lnx32.cpio
cd /home/oracle
su - oracle
cpio -idmv < $HOME/ship.db.lnx32.cpio

4).modify /home/oracle/.bash_profile to add oracle environment variables

su - oracle
vi /home/oracle/.bash_profile

# User specific environment and startup programs
##glibc library compay
export LD_ASSUME_KERNEL=2.4.19

## BEGIN ORACLE SPECIFIC VARIABLES
ORACLE_SID=erprod
ORACLE_OWNER=oracle
ORACLE_BASE=/home/oracle
ORACLE_HOME=$ORACLE_BASE/product/10g

export ORACLE_HOME ORACLE_OWNER ORACLE_SID ORACLE_BASE
SH_LIB_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/usr/lib:/usr/local/lib:.
TNS_ADMIN=$ORACLE_HOME/network/admin
export SH_LIB_PATH LD_LIBRARY_PATH TNS_ADMIN
PATH=$ORACLE_HOME/bin:$PATH
export PATH
CLASSPATH=.:$ORACLE_HOME/jdbc/lib/classes111.zip;
export CLASSPATH
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;
export ORA_NLS33
NLS_LANG=american; export NLS_LANG

5).modify the kernel environment (/etc/sysctl.conf)

vi /etc/sysctl.conf

kernel.shmmax=2147483648
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000

sysctl -p


6).made directories owned by oracle:dba

mkdir -p /u01
mkdir -p /u02
mkdir -p /u03
mkdir -p /u04
mkdir -p /u01/app
mkdir -p /u01/app/oracle
mkdir -p /u01/oradata
mkdir -p /u02/oradata
mkdir -p /u03/oradata
chown -R oracle:dba /u01 /u02 /u03 /u04
chmod -R 775 /u01 /u02 /u03 /u04
chown -R oracle:dba /home/oracle

7).run oracle installer

as oracle executed /home/oracle/Disk1/runInstaller (requires an X session to remote install - ssh user@ip -X)
as root executed /home/oracle/oraInventory/orainstRoot.sh
Name: 10g_10_1_0_3 Path: /home/oracle/product/10g
chose Standard Edition
Warning messages on install 
  Checking for openmotif-2.1.30-11; found Not found.Failed <<<<

  continued install despite warnings

install log is /home/oracle/oraInventory/logs/installActions2005-07-13_03-17-54pm.log
           and /home/oracle/oraInventory/logs/installActions2005-09-12_11-46-20AM.log

as root executed /home/oracle/product/10g/root.sh
accepted defaults

Extra requirements :

To check the RPMs, run:

rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel openmotif21 setarch libaio
Also ensure to install the libaio-0.3.96-5 RPM or a newer version! Otherwise the OUI prerequisite check will fail.
For 10g R2 (32-bit), the document Oracle Database Installation Guide 10g Release 2 (10.2) lists the following required package versions or higher:
  compat-db-4.0.14-5
  compat-gcc-7.3-2.96.128
  compat-libstdc++-7.3-2.96.128
  compat-libstdc++-devel-7.3-2.96.128
  openmotif21-2.1.30-8


No Response to "Oracle for Linux Installation HOWTO"

Leave A Reply

 
Free Website Hosting