7.Oracle用户设置内核限制
 
上线为:
Shell Limit
Item in limits.conf
Hard Limit
Maximum number of open file descriptors
nofile
65536
Maximum number of processes available to a single user
nproc
16384
vim /etc/security/limits.conf
 
 
 
 
 
vim /etc/pam.d/login
session required  /lib/security/pam_limits.so
session   required  pam_limits.so
以下根据用户的 shell 来限制:
vim /etc/profile
 
o                     
 
o                     
 
o                     
 
o                     
 
o                     
 
o                     
 
o                     
 
o                     
vim /etc/csh.login (如果用户的 Shell csh 或者 tcsh
 
o                     
 
o                     
 
o                     
 
o                     
8. 创建 oracle 的基本目录,并进行挂载
 
类似结构:
Requirement
Free Disk Space
The Oracle base directory will contain only software files.
Up to 3 GB
The Oracle base directory will contain both software and database files (not recommended for production databases).
Up to 4 GB
 
 
 
  
 
fdisk –l
 
fdisk /dev/sda
 
partprobe
 
mkfs.ext3 /dev/sda6
 
vim /etc/fstab
 
 
  
 
 
 
  
 
 
  
 
 
  
 
9.定义根目录和SID
 
 
vim .bash_profile
 
PATH=$PATH:$HOME/bin:/u01/app/oracle/product/10.2.0/db_1/bin
 
umask 022
 
ORACLE_BASE=/u01/app/oracle
 
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 
ORACLE_SID=orcl
 
export ORACLE_BASE ORACLE_SID ORACLE_HOME
 
 
 
9.定义根目录和SID
 
 
vim .bash_profile
 
PATH=$PATH:$HOME/bin:/u01/app/oracle/product/10.2.0/db_1/bin
 
umask 022
 
ORACLE_BASE=/u01/app/oracle
 
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 
ORACLE_SID=orcl
 
export ORACLE_BASE ORACLE_SID ORACLE_HOME