linux环境下安装oracle 11g database方法指导(二)

备注：

    本博内容是承接上期内容的延续，由于内容过长，因此采用分段说明，以免大家看起来疲倦，若了解更多详细的安装流程，请继续关注本博。参照原版安装手册对照安装。

 

4．Configure Oracle Installation Owner Shell Limits

<1>配置limits.conf文件，红色标注为增加的配置内容。

[root@mylinux ~]# vi /etc/security/limits.conf

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form:

#

#<domain>        <type>  <item>  <value>

#

#Where:

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form:

#

#<domain>        <type>  <item>  <value>

#

#Where:

#<domain> can be:

#        - an user name

#        - a group name, with @group syntax

#        - the wildcard *, for default entry

#        - the wildcard %, can be also used with %group syntax,

#                 for maxlogin limit

#

#<type> can have the two values:

#        - "soft" for enforcing the soft limits

#        - "hard" for enforcing hard limits

#

#<item> can be one of the following:

#        - core - limits the core file size (KB)

#        - data - max data size (KB)

#        - fsize - maximum filesize (KB)

#        - memlock - max locked-in-memory address space (KB)

#        - nofile - max number of open files

#        - rss - max resident set size (KB)

#        - stack - max stack size (KB)

#        - cpu - max CPU time (MIN)

#        - nproc - max number of processes

#        - as - address space limit

#        - maxlogins - max number of logins for this user

#        - maxsyslogins - max number of logins on the system

#        - priority - the priority to run user process with

#        - locks - max number of file locks the user can hold

#        - sigpending - max number of pending signals

#        - msgqueue - max memory used by POSIX message queues (bytes)

#

#<domain>      <type>  <item>         <value>

#

 

#*               soft    core            0

#*               hard    rss             10000

#@student        hard    nproc           20

#@faculty        soft    nproc           20

#@faculty        hard    nproc           50

#ftp             hard    nproc           0

#@student        -       maxlogins       4

 

# End of file

 

###############################################################

# oracle configure

###############################################################

 

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

 

 

<2>配置login

[root@mylinux etc]# cd pam.d

 

[root@mylinux pam.d]# vi 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 be the last session rule

session    required     pam_selinux.so open

 

#####################################################

#oracle login configure

#####################################################

 

session required pam_limits.so

 

 

<3>配置环境变量profile
[root@mylinux etc]# vi profile

 

# /etc/profile

 

# System wide environment and startup programs, for login setup

# Functions and aliases go in /etc/bashrc

 

pathmunge () {

        if ! echo $PATH | /bin/egrep -q "(^|:)$1($|:)" ; then

           if [ "$2" = "after" ] ; then

              PATH=$PATH:$1

           else

              PATH=$1:$PATH

           fi

        fi

}

 

# Path manipulation

if [ `id -u` = 0 ]; then

        pathmunge /sbin

        pathmunge /usr/sbin

        pathmunge /usr/local/sbin

fi

 

pathmunge /usr/X11R6/bin after

 

 

# No core files by default

ulimit -S -c 0 > /dev/null 2>&1

 

USER="`id -un`"

LOGNAME=$USER

MAIL="/var/spool/mail/$USER"

 

HOSTNAME=`/bin/hostname`

HISTSIZE=1000

 

if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then

    INPUTRC=/etc/inputrc

fi

 

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC

 

for i in /etc/profile.d/*.sh ; do

    if [ -r "$i" ]; then

        . $i

    fi

done

 

unset i

unset pathmunge

 

##############################################################

#

#oracle profile configure

##############################################################

 

umask 022

if [ $USER = "oracle" ]; then

      if [ $SHELL = "/bin/ksh" ]; then

           ulimit -p 16384

           ulimit -n 65536

      else

           ulimit -u 16384 -n 65536

      fi

fi

 

 

<4>切换到ORACLE用户登陆，配置ORACLE环境变量

 

[root@mylinux etc]# su - oracle

[oracle@mylinux ~]$ pwd

/u01/oracle

[oracle@mylinux ~]$ ls -la

total 56

drwxr-xr-x  2 oracle oinstall 4096 Apr 26 19:19 .

drwxr-xr-x  3 oracle oinstall 4096 Apr 26 15:59 ..

-rw-r--r--  1 oracle oinstall   24 Apr 26 19:19 .bash_logout

-rw-r--r--  1 oracle oinstall  191 Apr 26 19:19 .bash_profile

-rw-r--r--  1 oracle oinstall  124 Apr 26 19:19 .bashrc

-rw-r--r--  1 oracle oinstall  383 Apr 26 19:19 .emacs

-rw-r--r--  1 oracle oinstall  120 Apr 26 19:19 .gtkrc

[oracle@mylinux ~]$ vi .bash_profile

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/bin

 

export PATH

unset USERNAME

 

####################################################

#

#oralce configure

####################################################

 

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=levin

PATH=$ORACLE_HOME/bin:$PATH

 

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

 

 

查看如下记录生效的配置环境：

[root@mylinux ~]# su - oracle

[oracle@mylinux ~]$ env |grep ORA

ORACLE_SID=levin

ORACLE_BASE=/u01

ORACLE_HOME=/u01/oracle

[oracle@mylinux ~]$