• Oracle检查与安装操作内容


    Oracle 安装:
    
    检查安装包
    rpm -q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat
    
    
    vi /etc/sysctl.conf
    添加参数
    
    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 = 1048586 
    
    改变当前系统内核参数值(让/etc/sysctl.conf立即生效)  
    # sysctl -p  
    
    
    创建用户与组
    groupadd -g 505 dba
    groupadd -g 506 oinstall
    useradd -g oinstall -G dba -s /bin/bash -u 555 oracle
    
    passwd oracle
    
    
    
    
    vi /etc/selinux/config
    SELINUX=disabled
    
    
    
    
    修改/etc/security/limits.conf文件  
    vim /etc/security/limits.conf  
    在打开的文件底部添加下面内容  
    oracle soft nproc 20470  
    oracle hard nproc 16384  
    oracle soft nofile 10240  
    oracle hard nofile 65536  
    oracle soft stack 10240  
    
    
    
    
    mkdir -p /oracle/app/oracle/product/11.2/db_1
    chown -R oracle:oinstall /oracle
    
    
    
    vi .bash_profile 
    export PATH
    export EDITOR=vi
    export ORACLE_SID=redhat
    export ORACLE_BASH=/oracle/app/oracle
    export ORACLE_HOME=$ORACLE_BASH/product/11.2/db_1
    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
    
    
    --------------》
    解压Oracle 安装包
    
    
    Xshell登录Linux 
    
    
    
    测试   xclock
    
    
    
    --------------------------------------
    
    [roacle$redhat #]netca 配置Oracle
    
    sqlplus / as sysdba;
    select * from cat;
    select status from v$instance;
    解锁示库数据库
    alter user hr identified by hr account unlock;
    
    
    启动监听  lsnrctl start
    
    startup 启动数据库实例
    shutdown
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    

  • 相关阅读:
    Flex随笔
    Flex中实现类似Javascript的confirm box
    正则表达式
    MySQL存储过程
    cvc-complex-type.2.4.a: Invalid content was found starting with element
    Spket在Eclipse/MyEclipse下的安装和配置(图文教程)
    关于安装linux时要怎么分区的考虑的參考方式?
    BZOJ 1975 SDOI2010 魔法猪学院 A*k短路
    使用scipy进行聚类
    Android 下拉刷新上拉载入效果功能
  • 原文地址:https://www.cnblogs.com/raphael5200/p/5114811.html
Copyright © 2020-2023  润新知