• Oracle安装部署之一键安装oracle数据库及其脚本


    准备工作:通过ftp工具上传oracle安装软件到linux系统/mnt目录下,并通过unzip命令解压软件。
    ------------------------------------------------------------------------------------------------------------------------------------------------------------
    1、创建oracle图形界面安装前脚本(root用户操作),按如下方法操作即可:
    [root@localhost ~]# cd /mnt
    [root@localhost mnt]# vim oracleinstall
    --输入上面命令后出现的界面下按“i”,并输入如下内容后,点击“esc”键,输入“:wq”并回车保存。其中#1.create groups and users部分根据实际情况修改具体环境变量值即可。
    #!/bin/bash
    #Purpose:Create and config oracle install.
    #Usage:Log on as the superuser('root')
    groupadd dba -g 111
    groupadd oinstall -g 110
    useradd oracle -u 110 -g 110 -G 111
    echo "oracle" | passwd --stdin oracle
    echo "export TMP=/tmp">> /home/oracle/.bash_profile
    echo 'export TMPDIR=$TMP'>>/home/oracle/.bash_profile
    echo "export ORACLE_HOSTNAME=localhost.localdomain">> /home/oracle/.bash_profile
    echo "export ORACLE_SID=orcl">> /home/oracle/.bash_profile
    echo "export ORACLE_BASE=/u01/app/oracle">> /home/oracle/.bash_profile
    echo 'export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1'>> /home/oracle/.bash_profile
    echo 'export PATH=/usr/sbin:$PATH'>> /home/oracle/.bash_profile
    echo 'export PATH=$ORACLE_HOME/bin:$PATH'>> /home/oracle/.bash_profile
    echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib'>> /home/oracle/.bash_profile
    echo 'export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib'>> /home/oracle/.bash_profile
    echo "export LANG=en_US" >> /home/oracle/.bash_profile
    echo "export NLS_LANG=american_america.AL32UTF8" >> /home/oracle/.bash_profile
    echo "export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'" >> /home/oracle/.bash_profile
    mkdir -p /u01
    mkdir -p /u01/app
    mkdir -p /u01/app/oracle
    chown -R oracle:oinstall /u01
    chown -R oracle:oinstall /u01/app
    chown -R oracle:oinstall /u01/app/oracle
    cp /etc/security/limits.conf /etc/security/limits.conf.bak
    echo "oracle soft nproc 2047" >>/etc/security/limits.conf
    echo "oracle hard nproc 16384" >>/etc/security/limits.conf
    echo "oracle soft nofile 1024" >>/etc/security/limits.conf
    echo "oracle hard nofile 65536" >>/etc/security/limits.conf
    cp /etc/pam.d/login /etc/pam.d/login.bak
    echo "session required /lib/security/pam_limits.so" >>/etc/pam.d/login
    echo "session required pam_limits.so" >>/etc/pam.d/login
    cp /etc/profile /etc/profile.bak
    echo 'if [ $USER = "oracle" ]; then' >>  /etc/profile
    echo 'if [ $SHELL = "/bin/ksh" ]; then' >> /etc/profile
    echo 'ulimit -p 16384' >> /etc/profile
    echo 'ulimit -n 65536' >> /etc/profile
    echo 'else' >> /etc/profile
    echo 'ulimit -u 16384 -n 65536' >> /etc/profile
    echo 'fi' >> /etc/profile
    echo 'fi' >> /etc/profile
    cp /etc/sysctl.conf /etc/sysctl.conf.bak
    echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
    echo "fs.file-max = 6815744" >> /etc/sysctl.conf
    echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
    echo "kernel.shmmax = 4294967295" >> /etc/sysctl.conf
    echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
    echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
    echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
    echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
    echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
    echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
    echo "net.core.wmem_max = 1048586" >> /etc/sysctl.conf
    echo "net.ipv4.tcp_wmem = 262144 262144 262144" >> /etc/sysctl.conf
    echo "net.ipv4.tcp_rmem = 4194304 4194304 4194304" >> /etc/sysctl.conf
    sysctl -p
    ------------------------------------------------------------------------------------------------------------------------------------------------------------
    2、root用户下数据xhost +并回车,如下:
    [root@localhost mnt]# xhost +
    ------------------------------------------------------------------------------------------------------------------------------------------------------------
    3、切换到oracle用户下,并进入数据库安装软件目录,执行./runInstall命令,在出现图形界面后根据windows平台安装步骤执行即可(与windows平台安装oracle数据库唯一不同的地方是:最后要以root权限执行2个脚本),此处图形安装界面略。

    注意:先决条件检查步骤需要根据未通过条件进行先决条件处理。

  • 相关阅读:
    mysql视图定义以及创建视图
    前端页面调用spring mvc接口发生跨域问题解决方案
    亲测可用的ssm框架搭建
    python--pandas基本操作
    jieba中文处理 python
    爬虫 登录开心网,登录人人网
    Selenium&wevdriver
    django 中间件的一些基本操作
    写一个简单的登录客户端步骤
    个人对ADO连接池的理解
  • 原文地址:https://www.cnblogs.com/wcwen1990/p/6661686.html
Copyright © 2020-2023  润新知