设为首页 收藏本站
查看: 818|回复: 0

[经验分享] 基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

[复制链接]

尚未签到

发表于 2018-9-12 08:42:59 | 显示全部楼层 |阅读模式
4  安装Oracle前的准备
  4.1 基本配置
  4.1.1 关闭防火墙
  [root@oracle ~]# service iptables stop
  iptables: Setting chains to policy ACCEPT: filter [ OK ]
  iptables: Flushing firewall rules: [ OK ]
  iptables: Unloading modules: [ OK ]
  关闭iptables开机自启动功能
  [root@oracle ~]# chkconfig iptables off
  [root@oracle ~]# setup
  1)如下图所示,选择Firewall configuration,敲击回车键
DSC0000.jpg

  2)如下图所示,取消选中Enabled,选择OK,敲击回车键
DSC0001.jpg

  3)如下图所示,选择Yes,敲击回车键
DSC0002.jpg

  4)如下图所示,选择Quit,敲击回车键
DSC0003.jpg

  [root@oracle ~]# service iptables status
  iptables: Firewall is not running.
4.1.2 关闭selinux
  修改/etc/selinux/config文件如下内容:
  将SELINUX=enforcing更改成SELINUX=disabled
  [root@oracle ~]# vi /etc/selinux/config
  # This file controls the state of SELinux on the system.
  # SELINUX= can take one of these three values:
  # enforcing - SELinux security policy is enforced.
  # permissive - SELinux prints warnings instead of enforcing.
  # disabled - No SELinux policy is loaded.
  SELINUX=disabled
  # SELINUXTYPE= can take one of these two values:
  # targeted - Targeted processes are protected,
  # mls - Multi Level Security protection.
  SELINUXTYPE=targeted
  [root@oracle ~]# setenforce 0
  [root@oracle ~]# getenforce
  Permissive
  [root@oracle ~]# /usr/sbin/sestatus -v
  SELinux status: enabled
  SELinuxfs mount: /selinux
  Current mode: permissive
  Mode from config file: disabled
  Policy version: 24
  Policy from config file: targeted
  Process contexts:
  Current context: unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
  Init context: system_u:system_r:init_t:s0
  /sbin/mingetty system_u:system_r:getty_t:s0
  /usr/sbin/sshd system_u:system_r:sshd_t:s0-s0:c0.c1023
  File contexts:
  Controlling term: unconfined_u:object_r:user_devpts_t:s0
  /etc/passwd system_u:object_r:etc_t:s0
  /etc/shadow system_u:object_r:shadow_t:s0
  /bin/bash system_u:object_r:shell_exec_t:s0
  /bin/login system_u:object_r:login_exec_t:s0
  /bin/sh system_u:object_r:bin_t:s0 -> system_u:object_r:shell_exec_t:s0
  /sbin/agetty system_u:object_r:getty_exec_t:s0
  /sbin/init system_u:object_r:init_exec_t:s0
  /sbin/mingetty system_u:object_r:getty_exec_t:s0
  /usr/sbin/sshd system_u:object_r:sshd_exec_t:s0
  [root@oracle ~]# reboot
  Broadcast message from root@oracle.kely.com
  (/dev/pts/0) at 20:30 ...
  The system is going down for reboot NOW!
  [root@oracle ~]# getenforce
  Disabled
  [root@oracle ~]# /usr/sbin/sestatus -v
  SELinux status: disabled
4.1.3 配置hosts文件
  在/etc/hosts文件的最后一行添加如下内容:
  192.168.0.18 oracle oracle.kely.com
  [root@oracle ~]# vi /etc/hosts
  192.168.0.18 oracle oracle.kely.com
  [root@oracle ~]# ping oracle
  PING oracle (192.168.0.18) 56(84) bytes of data.
  64 bytes from oracle (192.168.0.18): icmp_seq=1 ttl=64 time=0.035 ms
  64 bytes from oracle (192.168.0.18): icmp_seq=2 ttl=64 time=0.020 ms
  ^C
  --- oracle ping statistics ---
  5 packets transmitted, 5 received, 0% packet loss, time 4587ms
  rtt min/avg/max/mdev = 0.020/0.034/0.039/0.008 ms
  [root@oracle ~]# ping oracle.kely.com
  PING oracle (192.168.0.18) 56(84) bytes of data.
  64 bytes from oracle (192.168.0.18): icmp_seq=1 ttl=64 time=0.011 ms
  64 bytes from oracle (192.168.0.18): icmp_seq=2 ttl=64 time=0.017 ms
  ^C
  --- oracle ping statistics ---
  2 packets transmitted, 2 received, 0% packet loss, time 1428ms
  rtt min/avg/max/mdev = 0.011/0.014/0.017/0.003 ms
4.2 创建Oracle用户群组
  [root@oracle ~]# groupadd oinstall
  [root@oracle ~]# groupadd dba
  [root@oracle ~]# useradd -g oinstall -G dba oracle
  将oracle用户的密码更改为1qaz@WSX
  [root@oracle ~]# passwd oracle
  Changing password for user oracle.
  New password:
  BAD PASSWORD: it is based on a dictionary word
  Retype new password:
  passwd: all authentication tokens updated successfully.
  [root@oracle ~]# id oracle
  uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
4.3 创建Logic Volume
  1)如下图所示,依次选择虚拟机 -- 编辑设置
DSC0004.jpg

  2)如下图所示,单击添加
DSC0005.jpg

  3)如下图所示,选择硬盘,单击下一步
DSC0006.jpg

  4)如下图所示,缺省选择,单击下一步
DSC0007.jpg

  5)如下图所示,修改容量(50G磁盘置备(Thin Provision,单击下一步
DSC0008.jpg

  6)如下图所示,缺省选择,单击下一步
DSC0009.jpg

  7)如下图所示,单击完成
DSC00010.jpg

  8)如下图所示,可以看到新添加的硬盘,单击确定
DSC00011.jpg

  9)如下图所示,在硬件设备中出现了硬盘2,说明新建的硬盘已经生效。
DSC00012.jpg

  查看新添加硬盘是否被系统正确加载。
  [root@oracle ~]# fdisk -l
  Disk /dev/sda: 21.5 GB, 21474836480 bytes
  64 heads, 32 sectors/track, 20480 cylinders
  Units = cylinders of 2048 * 512 = 1048576 bytes

  Sector>
  I/O>
  Disk>
  Device Boot Start End Blocks>  /dev/sda1 * 2 201 204800 83 Linux
  /dev/sda2 202 20480 20765696 8e Linux LVM
  Disk /dev/mapper/VolGroup-lv_root: 14.8 GB, 14818476032 bytes
  255 heads, 63 sectors/track, 1801 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes

  Sector>
  I/O>
  Disk>  Disk /dev/mapper/VolGroup-lv_swap: 6442 MB, 6442450944 bytes
  255 heads, 63 sectors/track, 783 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes

  Sector>
  I/O>
  Disk>  Disk /dev/sdb: 53.7 GB, 53687091200 bytes
  64 heads, 32 sectors/track, 51200 cylinders
  Units = cylinders of 2048 * 512 = 1048576 bytes
  Sector>
  I/O>
  Disk>
  将/dev/sdb创建成LVM设备。
  [root@oracle ~]# fdisk /dev/sdb
  Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

  Building a new DOS disklabel with disk>  Changes will remain in memory only, until you decide to write them.
  After that, of course, the previous content won't be recoverable.
  Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
  WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
  switch off the mode (command 'c') and change display units to
  sectors (command 'u').
  Command (m for help): n
  Command action
  e extended
  p primary partition (1-4)
  p
  Partition number (1-4): 1
  First cylinder (1-51200, default 1):
  Using default value 1
  Last cylinder, +cylinders or +size{K,M,G} (1-51200, default 51200):
  Using default value 51200
  Command (m for help): t
  Selected partition 1
  Hex code (type L to list codes): 8e
  Changed system type of partition 1 to 8e (Linux LVM)
  Command (m for help): p
  Disk /dev/sdb: 53.7 GB, 53687091200 bytes
  64 heads, 32 sectors/track, 51200 cylinders
  Units = cylinders of 2048 * 512 = 1048576 bytes

  Sector>
  I/O>
  Disk>
  Device Boot Start End Blocks>  /dev/sdb1 1 51200 52428784 8e Linux LVM
  Command (m for help): w

  The partition table has been>  Calling ioctl() to re-read partition table.
  Syncing disks.
  使分区表即可生效。
  [root@oracle ~]# partprobe
  将/dev/sdb1创建成Physical Volume。
  [root@oracle ~]# pvcreate /dev/sdb1
  Physical volume "/dev/sdb1" successfully created
  查看系统Volume Group信息。
  [root@oracle ~]# vgdisplay
  --- Volume group ---
  VG Name VolGroup

  System>  Format lvm2
  Metadata Areas 1
  Metadata Sequence No 3
  VG Access read/write
  VG Status resizable
  MAX LV 0
  Cur LV 2
  Open LV 2
  Max PV 0
  Cur PV 1
  Act PV 1
  VG>
  PE>
  Total PE 5069
  Alloc PE />
  Free PE />
  VG UUID rHlSfU-3A4e-pO0W-winf-O7qQ-NUyZ-bQkPcZ
  将/dev/sdb1添加到VolGroup中。
  [root@oracle ~]# vgextend VolGroup /dev/sdb1
  Volume group "VolGroup" successfully extended
  [root@oracle ~]# vgdisplay
  --- Volume group ---
  VG Name VolGroup

  System>  Format lvm2
  Metadata Areas 2
  Metadata Sequence No 4
  VG Access read/write
  VG Status resizable
  MAX LV 0
  Cur LV 2
  Open LV 2
  Max PV 0
  Cur PV 2
  Act PV 2
  VG>
  PE>
  Total PE 17868
  Alloc PE />
  Free PE />
  VG UUID rHlSfU-3A4e-pO0W-winf-O7qQ-NUyZ-bQkPcZ
  创建大小为20G的lv_u01,并归属于VolGroup
  [root@oracle ~]# lvcreate -L 20G -n lv_u01 VolGroup
  Logical volume "lv_u01" created
  将lv_u01格式化为ext4文件系统。
  [root@oracle ~]# mkfs -t ext4 /dev/VolGroup/lv_u01
  mke2fs 1.41.12 (17-May-2010)
  Filesystem label=
  OS type: Linux

  Block>
  Fragment>  Stride=0 blocks, Stripe  blocks
  1310720 inodes, 5242880 blocks
  262144 blocks (5.00%) reserved for the super user
  First data block=0
  Maximum filesystem blocks=4294967296
  160 block groups
  32768 blocks per group, 32768 fragments per group
  8192 inodes per group
  Superblock backups stored on blocks:
  32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
  4096000
  Writing inode tables: done
  Creating journal (32768 blocks): done
  Writing superblocks and filesystem accounting information: done
  This filesystem will be automatically checked every 36 mounts or
  180 days, whichever comes first. Use tune2fs -c or -i to override.
  [root@oracle ~]# mkdir /u01
  [root@oracle ~]# mount /dev/VolGroup/lv_u01 /u01/
  [root@oracle ~]# df -h

  Filesystem>  /dev/mapper/VolGroup-lv_root 14G 3.0G 10G 24% /
  tmpfs 2.0G 72K 2.0G 1% /dev/shm
  /dev/sda1 194M 35M 150M 19% /boot
  /dev/mapper/VolGroup-lv_u01 20G 172M 19G 1% /u01
  [root@oracle ~]# vi /etc/fstab
  #
  # /etc/fstab
  # Created by anaconda on Wed May 14 08:05:01 2014
  #
  # Accessible filesystems, by reference, are maintained under '/dev/disk'
  # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
  #
  /dev/mapper/VolGroup-lv_root / ext4 defaults 1 1
  UUID=a62aef67-7dbb-4d8b-9d9a-9e035806fe05 /boot ext4 defaults 1 2
  /dev/mapper/VolGroup-lv_swap swap swap defaults 0 0
  tmpfs /dev/shm tmpfs defaults 0 0
  devpts /dev/pts devpts gid=5,mode=620 0 0
  sysfs /sys sysfs defaults 0 0
  proc /proc proc defaults 0 0
  /dev/mapper/VolGroup-lv_u01 /u01 ext4 defaults 0 0
  [root@oracle ~]# lvcreate -L 15G -n lv_temp VolGroup
  Logical volume "lv_temp" created
  [root@oracle ~]# mkfs -t ext4 /dev/VolGroup/lv_temp
  mke2fs 1.41.12 (17-May-2010)
  Filesystem label=
  OS type: Linux

  Block>
  Fragment>  Stride=0 blocks, Stripe  blocks
  983040 inodes, 3932160 blocks
  196608 blocks (5.00%) reserved for the super user
  First data block=0
  Maximum filesystem blocks=4026531840
  120 block groups
  32768 blocks per group, 32768 fragments per group
  8192 inodes per group
  Superblock backups stored on blocks:
  32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208
  Writing inode tables: done
  Creating journal (32768 blocks): done
  Writing superblocks and filesystem accounting information: done
  This filesystem will be automatically checked every 24 mounts or
  180 days, whichever comes first. Use tune2fs -c or -i to override.
  [root@oracle ~]# mkdir /temp
  [root@oracle ~]# mount /dev/VolGroup/lv_temp /temp/
  [root@oracle ~]# df -h

  Filesystem>  /dev/mapper/VolGroup-lv_root 14G 3.0G 10G 24% /
  tmpfs 2.0G 72K 2.0G 1% /dev/shm
  /dev/sda1 194M 35M 150M 19% /boot
  /dev/mapper/VolGroup-lv_u01 20G 172M 19G 1% /u01
  /dev/mapper/VolGroup-lv_temp 15G 166M 14G 2% /temp
  [root@oracle ~]# vi /etc/fstab
  #
  # /etc/fstab
  # Created by anaconda on Wed May 14 08:05:01 2014
  #
  # Accessible filesystems, by reference, are maintained under '/dev/disk'
  # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
  #
  /dev/mapper/VolGroup-lv_root / ext4 defaults 1 1
  UUID=a62aef67-7dbb-4d8b-9d9a-9e035806fe05 /boot ext4 defaults 1 2
  /dev/mapper/VolGroup-lv_swap swap swap defaults 0 0
  tmpfs /dev/shm tmpfs defaults 0 0
  devpts /dev/pts devpts gid=5,mode=620 0 0
  sysfs /sys sysfs defaults 0 0
  proc /proc proc defaults 0 0
  /dev/mapper/VolGroup-lv_u01 /u01 ext4 defaults 0 0
  /dev/mapper/VolGroup-lv_temp /temp ext4 defaults 0 0
  [root@oracle ~]# chown -R oracle:oinstall /u01
  [root@oracle ~]# chmod -R 775 /u01/
  [root@oracle ~]# ls -l / | grep u01
  drwxrwxr-x 3 oracle oinstall 4096 May 14 22:19 u01
  [root@oracle ~]# chown -R oracle:oinstall /temp/
  [root@oracle ~]# chmod -R 775 /temp/
  [root@oracle ~]# ls -l / | grep temp
  drwxrwxr-x 4 oracle oinstall 4096 May 14 21:35 temp
4.4 安装必须的RPM包
  备注:
  The following or later version of packages for Oracle Linux 6, and Red Hat
  Enterprise Linux 6 must be installed:
  binutils-2.20.51.0.2-5.11.el6 (x86_64)
  compat-libcap1-1.10-1 (x86_64)
  compat-libstdc++-33-3.2.3-69.el6 (x86_64)
  compat-libstdc++-33-3.2.3-69.el6.i686
  gcc-4.4.4-13.el6 (x86_64)
  gcc-c++-4.4.4-13.el6 (x86_64)
  glibc-2.12-1.7.el6 (i686)
  glibc-2.12-1.7.el6 (x86_64)
  glibc-devel-2.12-1.7.el6 (x86_64)
  glibc-devel-2.12-1.7.el6.i686
  pdksh
  libgcc-4.4.4-13.el6 (i686)
  libgcc-4.4.4-13.el6 (x86_64)
  libstdc++-4.4.4-13.el6 (x86_64)
  libstdc++-4.4.4-13.el6.i686
  libstdc++-devel-4.4.4-13.el6 (x86_64)
  libstdc++-devel-4.4.4-13.el6.i686
  libaio-0.3.107-10.el6 (x86_64)
  libaio-0.3.107-10.el6.i686
  libaio-devel-0.3.107-10.el6 (x86_64)
  libaio-devel-0.3.107-10.el6.i686
  make-3.81-19.el6
  sysstat-9.0.4-11.el6 (x86_64)
  pdksh-5.2.14-37.el5_8.1.x86_64
  
  On Oracle Linux 6 and Red Hat Enterprise Linux 6:
  unixODBC-2.2.14-11.el6 (x86_64)or later
  unixODBC-2.2.14-11.el6.i686or later
  unixODBC-devel-2.2.14-11.el6 (x86_64)or later
  unixODBC-devel-2.2.14-11.el6.i686or later
4.4.1 配置本地YUM源
  [root@oracle ~]# mkdir /temp/yum
  [root@oracle ~]# mount /dev/cdrom /mnt/
  mount: block device /dev/sr0 is write-protected, mounting read-only
  [root@oracle ~]# ls /mnt/

  EFI Packages>
  EULA README>
  EULA_de>
  EULA_en>
  EULA_es>
  EULA_fr>
  EULA_it>
  EULA_ja>
  EULA_ko>
  EULA_pt>
  EULA_zh>
  GPL>
  HighAvailability>
  images>
  isolinux>
  LoadBalancer>
  media.repo>  [root@oracle ~]# cp -rfv /mnt/* /temp/yum/
  [root@oracle ~]# ls /temp/yum/

  EFI Packages>
  EULA README>
  EULA_de>
  EULA_en>
  EULA_es>
  EULA_fr>
  EULA_it>
  EULA_ja>
  EULA_ko>
  EULA_pt>
  EULA_zh>
  GPL>
  HighAvailability>
  images>
  isolinux>
  LoadBalancer>
  media.repo>  [root@oracle ~]# cp /etc/yum.repos.d/rhel-source.repo /etc/yum.repos.d/local-source.repo
  [root@oracle ~]# vi /etc/yum.repos.d/local-source.repo
  [local-source]
  name=Local-Source
  baseurl=file:///temp/yum/Server
  enabled=1
  gpgcheck=0
  gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
  [root@oracle ~]# yum list
  [root@oracle ~]# umount /dev/cdrom
  [root@oracle ~]# df -h

  Filesystem>  /dev/mapper/VolGroup-lv_root 14G 3.1G 9.9G 24% /
  tmpfs 2.0G 80K 2.0G 1% /dev/shm
  /dev/sda1 194M 35M 150M 19% /boot
  /dev/mapper/VolGroup-lv_u01 20G 172M 19G 1% /u01
  /dev/mapper/VolGroup-lv_temp 15G 3.8G 11G 27% /temp
  /dev/sr0 3.6G 3.6G 0 100% /media/RHEL_6.5 x86_64 Disc 1
  [root@oracle ~]# umount /dev/sr0
4.4.2 检查并安装RPM包
  [root@oracle ~]# rpm -qa | grep binutils
  binutils-2.20.51.0.2-5.36.el6.x86_64
  [root@oracle ~]# rpm -qa | grep compat-libcap1
  [root@oracle ~]# yum install compat-libcap1-1.10-1.x86_64 -y
  [root@oracle ~]# rpm -qa | grep compat-libstdc++
  [root@oracle ~]# yum install compat-libstdc++-33-3.2.3-69.el6.i686 -y
  [root@oracle ~]# yum install compat-libstdc++-33-3.2.3-69.el6.x86_64 -y
  [root@oracle ~]#rpm -qa | grep gcc
  libgcc-4.4.7-4.el6.x86_64
  [root@oracle ~]# yum install gcc-4.4.7-4.el6.x86_64 -y
  [root@oracle ~]# yum install gcc-c++-4.4.7-4.el6.x86_64 -y
  [root@oracle ~]# rpm -qa | grep glibc
  glibc-devel-2.12-1.132.el6.x86_64
  glibc-2.12-1.132.el6.x86_64
  glibc-common-2.12-1.132.el6.x86_64
  glibc-headers-2.12-1.132.el6.x86_64
  glibc-2.12-1.132.el6.i686
  [root@oracle ~]# yum install glibc-devel-2.12-1.132.el6.i686 -y
  [root@oracle ~]# rpm -qa | grep ksh
  [root@oracle ~]# rpm -qa | grep libgcc
  libgcc-4.4.7-4.el6.x86_64
  libgcc-4.4.7-4.el6.i686
  [root@oracle ~]# rpm -qa | grep libstdc++
  compat-libstdc++-33-3.2.3-69.el6.i686
  libstdc++-4.4.7-4.el6.x86_64
  compat-libstdc++-33-3.2.3-69.el6.x86_64
  libstdc++-devel-4.4.7-4.el6.x86_64
  [root@oracle ~]# yum install libstdc++-4.4.7-4.el6.i686 -y
  [root@oracle ~]# yum install libstdc++-devel-4.4.7-4.el6.i686 -y
  [root@oracle ~]# rpm -qa | grep libaio
  libaio-0.3.107-10.el6.x86_64
  [root@oracle ~]# yum install libaio-0.3.107-10.el6.i686 -y
  [root@oracle ~]# yum install libaio-devel-0.3.107-10.el6.i686 -y
  [root@oracle ~]# yum install libaio-devel-0.3.107-10.el6.x86_64 -y
  [root@oracle ~]# rpm -qa | grep make
  make-3.81-20.el6.x86_64
  [root@oracle ~]# rpm -qa | grep sysstat
  sysstat-9.0.4-22.el6.x86_64
  [root@oracle ~]# rpm -qa | grep unixODBC
  [root@oracle ~]# yum install unixODBC-2.2.14-12.el6_3.i686 -y
  [root@oracle ~]# yum install unixODBC-2.2.14-12.el6_3.x86_64 -y
  [root@oracle ~]# yum install unixODBC-devel-2.2.14-12.el6_3.i686 -y
  [root@oracle ~]# yum install unixODBC-devel-2.2.14-12.el6_3.x86_64 -y
  [root@oracle ~]# rpm -qa | grep pdksh
  [root@oracle ~]# cd /temp/
  [root@oracle temp]# ls
  lost+found pdksh-5.2.14-37.el5_8.1.x86_64.rpm yum
  [root@oracle temp]# rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm
  warning: pdksh-5.2.14-37.el5_8.1.x86_64.rpm: Header V3 DSA/SHA1 Signature, key>
  Preparing... ########################################### [100%]
  1:pdksh ########################################### [100%]
4.5 配置内核参数
  备注:
  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 = 1048576
  [root@oracle ~]# /sbin/sysctl -a | grep mem
  vm.overcommit_memory = 0
  vm.nr_hugepages_mempolicy = 0
  vm.lowmem_reserve_ratio = 256 256 32
  vm.memory_failure_early_kill = 0
  vm.memory_failure_recovery = 1
  net.core.wmem_max = 124928
  net.core.rmem_max = 124928
  net.core.wmem_default = 124928
  net.core.rmem_default = 124928
  net.core.optmem_max = 20480
  net.ipv4.igmp_max_memberships = 20
  net.ipv4.tcp_mem = 378336 504448 756672
  net.ipv4.tcp_wmem = 4096 16384 4194304
  net.ipv4.tcp_rmem = 4096 87380 4194304
  net.ipv4.udp_mem = 378336 504448 756672
  net.ipv4.udp_rmem_min = 4096
  net.ipv4.udp_wmem_min = 4096
  [root@oracle ~]# /sbin/sysctl -a | grep sem
  kernel.sem = 250 32000 32 128
  [root@oracle ~]# /sbin/sysctl -a | grep shm
  kernel.shmmax = 68719476736
  kernel.shmall = 4294967296
  kernel.shmmni = 4096
  kernel.shm_rmid_forced = 0
  vm.hugetlb_shm_group = 0
  [root@oracle ~]# /sbin/sysctl -a | grep file-max
  fs.file-max = 400512
  [root@oracle ~]# /sbin/sysctl -a | grep ip_local_port_range
  net.ipv4.ip_local_port_range = 32768 61000
  [root@oracle ~]# /sbin/sysctl -a | grep rmem_default
  net.core.rmem_default = 124928
  [root@oracle ~]# /sbin/sysctl -a | grep rmem_max
  net.core.rmem_max = 124928
  [root@oracle ~]# /sbin/sysctl -a | grep wmem_default
  net.core.wmem_default = 124928
  [root@oracle ~]# /sbin/sysctl -a | grep wmem_max
  net.core.wmem_max = 124928
  在/etc/sysctl.conf文件的最后添加如下内容:
  fs.aio-max-nr = 1048576
  fs.file-max = 6815744
  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 = 262144
  net.core.rmem_max = 4194304
  net.core.wmem_default = 262144
  net.core.wmem_max = 1048576
  [root@oracle ~]# vi /etc/sysctl.conf
  fs.aio-max-nr = 1048576
  fs.file-max = 6815744
  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 = 262144
  net.core.rmem_max = 4194304
  net.core.wmem_default = 262144
  net.core.wmem_max = 1048576
  [root@oracle ~]# sysctl -p
  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
  error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key
  error: "net.bridge.bridge-nf-call-iptables" is an unknown key
  error: "net.bridge.bridge-nf-call-arptables" is an unknown key
  kernel.msgmnb = 65536
  kernel.msgmax = 65536
  kernel.shmmax = 68719476736
  kernel.shmall = 4294967296
  fs.aio-max-nr = 1048576
  fs.file-max = 6815744
  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 = 262144
  net.core.rmem_max = 4194304
  net.core.wmem_default = 262144
  net.core.wmem_max = 1048576
4.6 配置oracle用户
  备注:
  oracle soft nproc 2047
  oracle hard nproc 16384
  oracle soft nofile 4096
  oracle hard nofile 65536
  oracle soft stack 10240
  在/etc/security/limits.conf文件最后添加如下内容:
  oracle soft nproc 2047
  oracle hard nproc 16384
  oracle soft nofile 4096
  oracle hard nofile 65536
  oracle soft stack 10240
  [root@oracle ~]# vi /etc/security/limits.conf
  oracle soft nproc 2047
  oracle hard nproc 16384
  oracle soft nofile 4096
  oracle hard nofile 65536
  oracle soft stack 10240
  在/etc/pam.d/login文件最后添加如下内容:
  session required /lib/security/pam_limits.so
  session required pam_limits.so
  [root@oracle ~]# vi /etc/pam.d/login
  session required /lib/security/pam_limits.so
  session required pam_limits.so
  在/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
  [root@oracle ~]# 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
  [root@oracle ~]# source /etc/profile
  在/home/oracle/.bash_profile文件最后添加如下内容:
  #Oracle Settings
  TMP=/tmp; export TMP
  TMPDIR=$TMP; export TMPDIR
  
  ORACLE_HOSTNAME=oracle.kely.com; export ORACLE_HOSTNAME
  ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
  ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
  ORACLE_SID=orcl; export ORACLE_SID
  
  PATH=/usr/sbin:$PATH; export PATH
  PATH=$ORACLE_HOME/bin:$PATH; export PATH
  
  LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
  CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export>
  [root@oracle ~]# vi /home/oracle/.bash_profile
  #Oracle Settings
  TMP=/tmp; export TMP
  TMPDIR=$TMP; export TMPDIR
  
  ORACLE_HOSTNAME=oracle.kely.com; export ORACLE_HOSTNAME
  ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
  ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
  ORACLE_SID=orcl; export ORACLE_SID
  
  PATH=/usr/sbin:$PATH; export PATH
  PATH=$ORACLE_HOME/bin:$PATH; export PATH
  
  LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
  CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export>
  [root@oracle ~]# source /home/oracle/.bash_profile
  [root@oracle ~]# su - oracle
  [oracle@oracle ~]$ env | grep ORA
  ORACLE_UNQNAME=orcl
  ORACLE_SID=orcl
  ORACLE_BASE=/u01/app/oracle
  ORACLE_HOSTNAME=oracle.kely.com
  ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1


运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.iyunv.com/thread-573130-1-1.html 上篇帖子: Oracle查看SQL执行计划的方式 下篇帖子: 基于RHEL 6.5安装Oracle 11g详细教程(5)——安装Oracle
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表