Installing Oracle in Linux (installation summary)

1, check the hardware

Memory

# grep Memtotal/proc/meminfo

Swap space

# grep Swaptotal/proc/meminfo

Disk space

# Df-ah

2, download software

Oracle Database 10g Release 2 (10.2.0.1) software download location:

Http://otn.oracle.com/software/products/database/oracle10g/index.html

3, modifyHostfile

The view /etc/hosts file must contain a fully qualified name for the server

4, install package check

1, check whether the following packages are installed, if not installed, you must first install:

Binutils-2.17.50.0.6-2.el5

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

# Rpm-qa | grep make gcc glibc compat openmotif21 setarch et cetera

5,LIBSTDClinks to packages

( old version requirements , new version oracle11 do not set ):

Ln-s/usr/lib/libstdc++.so.6.0.3/usr/lib/libstdc++.so.5

# Detection exists If you do not do this link, the installation process to build the database, you will be unable to link to the database problem.

three.parameter Settings1, set core parameters

Add the following line to the /etc/sysctl.conf file:

#kernel. core_uses_pid = 1

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648--( in bytes, amount of physical memory *1024*1024*2, 2 times of memory )

Kernel.shmmni = 4096

# SEMAPHORES:SEMMSL, Semmns, SEMOPM, Semmni

Kernel.sem = 250 32000 100 128

Fs.file-max = 65536

Net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=8388608

net.core.rmem_max=8388608

net.core.wmem_default=262144

net.core.wmem_max=262144

esc:wq!

# sysctl-p # Run the following command to change the core parameters

2, settingShell Limits (System Resource Limits),improve the efficiency of software operation

A. Add the following red lines to the /etc/security/limits.conf file:

Oracle Soft Nofile 65536

Oracle Hard Nofile 65536

Oracle Soft Nproc 16384

Oracle Hard Nproc 16384

B. Add the following line to the /etc/pam.d/login file, if none:

Session required/lib/security/pam_limits.so

Session Required Pam_limits.so

c. Add the following statement after the /etc/profile :

Vi/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

3.create users and groups and related directories

-- Create dba/oper/oinstall Group

/usr/sbin/groupadd DBA

/usr/sbin/groupadd Oper

/usr/sbin/groupadd Oinstall

-- Create an Oracle user and set the group to which the user belongs

/USR/SBIN/USERMOD-G oinstall-g dba Oracle

/USR/SBIN/USERADD-G oinstall-g dba Oracle

passwd Oracle

# ID Oracle

uid=501 (Oracle) gid=501 (oinstall) groups=501 (Oinstall), 502 (DBA)

-- Create the relevant installation directory

Mkdir-p/opt/oracle/product

Mkdir-p/opt/oracle/product/orahome

Mkdir-p/opt/orainventory # (the default inventory folder)

Mkdir-p/opt/oracle/oradata # (change the right file owner)

Mkdir-p/var/opt/oracle

-- Set directory owner and permissions

Chown-r oracle.oinstall/opt/oracle

Chown-r Oracle.oinstall/opt/oracle/oradata

Chown-r Oracle.oinstall/opt/oracle/product/orahome

Chown-r oracle.dba/opt/orainventory

Chown oracle.dba/var/opt/oracle

Chmod-r 775/opt/oracle

Chmod-r 755/var/opt/oracle

4.setting installation Environment variables

# su-oracle--su to oracle user,

Change some of the user's configuration

$vi. Bash_profile

Add the following parameters, mainly to configure the Oracle software Operation Environment parameters

# Get the aliases and functions

If [-f ~/.BASHRC]; Then

. ~/.bashrc

Fi

Export Oracle_base=/opt/oracle

Export Oracle_home= $ORACLE _base/product/orahome

Export ORACLE_SID=ORCL

Export Oracle_owner=oracle

Export oracle_term=vt100

Export path= $PATH: $ORACLE _home/bin: $HOME/bin

Export path= $ORACLE _home/bin: $ORACLE _home/apache/apache/bin: $PATH

Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib:/usr/local/lib

Export Ld_library_path

Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Classpath= $CLASSPATH: $ORACLE _home/network/jlib

Export CLASSPATH

Note :

11g:ora_nls33= $ORACLE _home/nls/admin/data

10g:ora_nls33= $ORACLE _home/ocommon/nls/admin/data

9i:ora_nls33=/oracle/app/ora92/ocommon/nls/admin/data

Save Exit

-- Execute the following command to have the configuration take effect immediately or with the Oracle user Login to make the settings effective

$ source $HOME/.bash_profile

Installing Oracle in Linux (installation summary)