Oracle11g安装

2022-12-13  本文已影响0人  这货不是王马勺

环境配置

OS:Redhat6.6

安装依赖包

yum install -y compat-db-4*

yum install -y libaio-0*

yum install -y compat-libstdc++-33-3*

yum install -y glibc-headers-2*

yum install -y glibc-devel-2*

yum install -y compat-gcc-34-3*

yum install -y compat-gcc-34-c++-3*

yum install -y libXp-1*

yum install -y openmotif-2*

yum install -y gcc-4*

yum install -y glibc-2*

yum install -y libgomp-4*

yum install -y binutils-*

yum install -y compat-libstdc++-*

yum install -y elfutils-libelf-*

yum install -y elfutils-libelf-devel-*

yum install -y glibc-*

yum install -y glibc-common-*

yum install -y glibc-devel-*

yum install -y gcc-*

yum install -y gcc-c++-*

yum install -y libaio-devel-*

yum install -y libaio-*

yum install -y libgcc-*

yum install -y libstdc++-*

yum install -y libstdc++-devel-*

yum install -y make-*

yum install -y sysstat-*

yum install -y unixODBC-*

yum install -y unixODBC-devel-*

修改limits参数

vim /etc/security/limits.conf

oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

修改内核参数

kernel.shmmax = 28147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 510 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_max = 16777216
net.core.wmem_default = 266960

生效:

sysctl -p

改主机名
编辑/etc/hosts即可

创建组和用户

groupadd oinstall
groupadd dba
useradd -g dba -G oinstall -m oracle
passwd oracle

创建目录和授权

mkdir -p /data/oracle/    #base
mkdir -p /data/oracle/product #home父目录
mkdir -p /data/oracle/oradata/ #表空间数据文件
mkdir -p /data/oracle/oralnventory
chown -R oracle:oinstall /data/oracle
chown -R oracle:oinstall /app

配置环境变量:

su - oracle
vim .bash_profile

export ORACLE_BASE=/data/oracle/
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=esbdb
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

上传和解压
上传两个安装包到/app下:

yum install -y unzip

unzip V17530-01_1of2.zip
unzip V17530-01_2of2.zip

安装

yum install -y xorg-x11-xauth xorg-x11-server-utils-*

su - oracle
export DISPLAY=10.10.199.33:0.0
export LANG='en_US'
xhost +

cd /app/database
./runInstaller

然后就按步骤安装实例,dbca建库,netca配监听和TNS即可

上一篇 下一篇

猜你喜欢

热点阅读