linux下安装oracle需要的配置

时间:2021-03-08 08:33:36
1.检查系统包安装情况
rpm -qa|grep binutils
rpm -ivh sysstat-
7.0.2.rpm

rpm -ivh binutils-
2.17.50.0.6-14.el5.*.rpm
rpm -ivh compat-libstdc
++-33-3.2.3-61.*.rpm
rpm -ivh elfutils-libelf-
0.137-3.el5.*.rpm
rpm -ivh elfutils-libelf-devel-
0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
rpm -ivh elfutils-libelf-devel-
0.137-3.el5.x86_64.rpm elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm
rpm -ivh gcc-
4.1.2-48.el5.*.rpm
rpm -ivh gcc-c
++-4.1.2-48.el5.*.rpm
rpm -ivh glibc-
2.5-49.*.rpm
rpm -ivh glibc-common-
2.5-49.*.rpm
rpm -ivh glibc-devel-
2.5-49.*.rpm
rpm -ivh libaio-
0.3.106-5.*.rpm
rpm -ivh libaio-devel-
0.3.106-5.*.rpm
rpm -ivh libgcc-
4.1.2-48.el5.*.rpm
rpm -ivh libstdc
++-4.1.2-48.el5.*.rpm
rpm -ivh libstdc
++-devel-4.1.2-48.el5.*.rpm
rpm -ivh make-
3.81-3.el5.*.rpm
rpm -ivh sysstat-
7.0.2-3.el5.*.rpm
rpm -ivh unixODBC-
2.2.11-7.1.*.rpm
rpm -ivh unixODBC-devel-
2.2.11-7.1.*.rpm
rpm -ivh libXp-
1.0.0-8.1.el5.*.rpm
rpm -ivh libXau-devel-
1.0.1-3.1.*.rpm
rpm -ivh libXp-devel-
1.0.0-8.1.el5.*.rpm


2.修改网络配置
vi
/etc/sysconfig/network-scripts/ifcfg-eth0
----------------------------
DEVICE=eth0
BOOTPROTO
=none
HWADDR
=00:0c:29:d4:f5:b4
ONBOOT
=yes
TYPE=Ethernet
USERCTL
=yes
IPV6INIT
=no
PEERDNS
=yes
NETMASK
=255.255.255.0
IPADDR
=192.168.91.100
GATEWAY
=192.168.91.1
----------------------------
vi
/etc/hosts
-----------------------------
127.0.0.1 localhost.localdomain localhost
192.168.91.100 RHL5
-----------------------------

3.添加oracle用户
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle

4.添加初始化参数
vi
/etc/sysctl.conf
sysctl -p
-----------------------------
fs
.aio-max-nr = 1048576
fs
.file-max = 6815744
#kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel
.shmmni = 4096
kernel
.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
-----------------------------

5.关闭强制访问控制,避免路由访问失败
vi
/etc/selinux/config
-----------------------
SELINUX
=disabled
-----------------------

6.设置oracle软硬件进程数
vi
/etc/security/limits.conf
-----------------------
oracle soft nproc
2047
oracle hard nproc
16384
oracle soft nofile
1024
oracle hard nofile
65536
-----------------------

7.全局进程,线程配置
vi
/etc/profile
----------------------
if [$USER = 'oracle']; then
ulimit -u
16384
ulimit -n
65536
fi
----------------------

8.创建oracle根目录,并设置目录权限
mkdir /u01/app/oracle -p
chown -R oracle
:oinstall /u01
chmod -R
755 /u01

9.设置oracle用户环境变量
su - oracle
vi
.bash_profile
----------------------
export ORACLE_BASE
=/u01/app/oracle
export ORACLE_HOME
=/u01/app/oracle/product/11.2/db_1
export ORACLE_SID
=oracle11g
export NLS_LANG
=american_america.zhs16gbk
export LD_LIBRARY_PATH
=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export
PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask
022
----------------------

让其生效
. ./.bash_profile

检验是否设置成功
echo $ORACLE_HOME