美文网首页
Oracle11g安装

Oracle11g安装

作者: 这货不是王马勺 | 来源:发表于2022-12-13 15:10 被阅读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即可

    相关文章

      网友评论

          本文标题:Oracle11g安装

          本文链接:https://www.haomeiwen.com/subject/gnkfqdtx.html