alibabamama 发表于 2018-9-14 07:13:23

oracle install_guide

  vi /etc/security/limits.conf
  oracle soft nproc 2047
  oracle hard nproc 16384
  oracle soft nofile1024
  oracle hard nofile 65536
  vi /etc/pam.d/login
  session required /lib/security/pam_limits.so
  session required pam_limits.so
  vi /etc/sysctl.conf
  net.ipv4.ip_forward = 0
  net.ipv4.conf.default.rp_filter = 1
  net.ipv4.conf.default.accept_source_route = 0
  kernel.sysrq = 0
  kernel.core_uses_pid = 1
  net.ipv4.tcp_syncookies = 1
  # Disable netfilter on bridges.
  #net.bridge.bridge-nf-call-ip6tables = 0
  #net.bridge.bridge-nf-call-iptables = 0
  #net.bridge.bridge-nf-call-arptables = 0
  kernel.msgmnb = 65536
  kernel.msgmax = 65536
  kernel.shmmax = 68719476736
  #kernel.shmall = 4294967296i
  fs.file-max = 6815744
  fs.aio-max-nr = 1048576
  kernel.shmall = 2097152
  #kernel.shmmax = 2147483648
  kernel.shmmni = 4096
  kernel.sem = 250 32000 100 128
  net.ipv4.ip_local_port_range = 9000 65500
  net.core.rmem_default = 4194304
  net.core.rmem_max = 4194304
  net.core.wmem_default = 262144
  net.core.wmem_max = 1048576
  sysctl –p
  vi /etc/profile
  if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
  ulimit -p 16384
  ulimit -n 65536
  else
  ulimit -u 16384 -n 65536
  fi
  fi
  groupadd oinstall
  groupadd dba
  useradd -g oinstall -g dba -m oracle
  passwd oracle
  mkdir /data/oracle/app
  mkdir /data/oracle/app/oracle
  mkdir /data/oracle/app/oradata
  mkdir /data/oracle/app/oracle/product
  chown -R oracle:oinstall /data/oracle
  su – oracle
  vi .bash_profile
  umask 022
  export ORACLE_BASE=/data/oracle/app
  export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
  export ORACLE_SID=orcl
  export ORACLE_UNQNAME=$ORACLE_SID
  export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
  source .bash_profile
  cd /data/oracle11.2.0.3/database/
  ./runInstaller
  按提示修改路径,以及最后的环境检查可跳过也可yum install软件包。
  dbca
  过程需注意添加sys dba账号时需选择高级,不然后期配置em会有一些奇奇怪怪的问题):
  netca设置监听。

页: [1]
查看完整版本: oracle install_guide