1、安装oracle需要的rpm包(rpm -q;rpm -Uvh)
gcc-3.2.3-2
make-3.79
binutils-2.11
openmotif-2.2.2-16
setarch-1.3-1
compat-gcc-7.3-2.96.122
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122
compat-db-4.0.14.5
libstdc++
2、修改配置文件/etc/sysctl.conf,加入以下代码:
#use for oracle
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
保存文件后运行(/sbin/sysctl -p)让修改立即生效
3、修改配置文件/etc/security/limits.conf,加入以下代码:
# use for oracle
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
4、修改配置文件/etc/pam.d/login,加入以下代码:
# use for oracle
session required /lib/security/pam_limits.so
5、修改配置文件/etc/selinux/config:
SELINUX=disabled
6、修改配置文件/etc/sysconfig/i18n:
LANG="en_US.UTF-8"
7、修改配置文件/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
8、创建oracle的用户组和用户,创建安装目录:
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
passwd oracle
mkdir xxx
chown -R oracle:oinstall xxx
chmod -R 775 xxx
9、修改配置文件.bash_profile,加入环境变量:
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBARY_PATH=$ORACLE_HOME/lib
10、安装ORACLE
11、测试ORACLE
sqlplus /nolog
conn /as sysdba
startup
shutdown immediate
12、使用dbstart,dbshut
/etc/oratab:orcl:/oracle/app/product/10.2.0/db_1:Y
$ORACLE_HOME/bin/dbstart:ORATAB=/etc/oratab
13、修改监听配置文件:
$ORACLE_HOME/network/admin/listener.ora
$ORACLE_HOME/network/admin/tnsnames.ora
14、开启监听
lsnrctl start