温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

发布时间:2020-07-29 10:26:44 来源:网络 阅读:2997 作者:kevin19851228 栏目:关系型数据库

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,敲击回车键

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

[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)如下图所示,依次选择虚拟机 -- 编辑设置

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

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

基于RHEL 6.5安装Oracle 11g详细教程(4)——安装Oracle前的准备

查看新添加硬盘是否被系统正确加载。

[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 size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00043aa4

Device Boot Start End Blocks Id System

/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 size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

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 size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

Disk /dev/sdb: 53.7 GB, 53687091200 bytes

64 heads, 32 sectors/track, 51200 cylinders

Units = cylinders of 2048 * 512 = 1048576 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

将/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 identifier 0x236668f6.

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 size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x236668f6

Device Boot Start End Blocks Id System

/dev/sdb1 1 51200 52428784 8e Linux LVM

Command (m for help): w

The partition table has been altered!

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 ID

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 Size 19.80 GiB

PE Size 4.00 MiB

Total PE 5069

Alloc PE / Size 5069 / 19.80 GiB

Free PE / Size 0 / 0

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 ID

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 Size 69.80 GiB

PE Size 4.00 MiB

Total PE 17868

Alloc PE / Size 5069 / 19.80 GiB

Free PE / Size 12799 / 50.00 GiB

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 size=4096 (log=2)

Fragment size=4096 (log=2)

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 Size Used Avail Use% Mounted on

/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 size=4096 (log=2)

Fragment size=4096 (log=2)

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 Size Used Avail Use% Mounted on

/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 RELEASE-NOTES-pa-IN.html

EULA README RELEASE-NOTES-pt-BR.html

EULA_de RELEASE-NOTES-as-IN.html RELEASE-NOTES-ru-RU.html

EULA_en RELEASE-NOTES-bn-IN.html RELEASE-NOTES-si-LK.html

EULA_es RELEASE-NOTES-de-DE.html RELEASE-NOTES-ta-IN.html

EULA_fr RELEASE-NOTES-en-US.html RELEASE-NOTES-te-IN.html

EULA_it RELEASE-NOTES-es-ES.html RELEASE-NOTES-zh-CN.html

EULA_ja RELEASE-NOTES-fr-FR.html RELEASE-NOTES-zh-TW.html

EULA_ko RELEASE-NOTES-gu-IN.html repodata

EULA_pt RELEASE-NOTES-hi-IN.html ResilientStorage

EULA_zh RELEASE-NOTES-it-IT.html RPM-GPG-KEY-redhat-beta

GPL RELEASE-NOTES-ja-JP.html RPM-GPG-KEY-redhat-release

HighAvailability RELEASE-NOTES-kn-IN.html ScalableFileSystem

images RELEASE-NOTES-ko-KR.html Server

isolinux RELEASE-NOTES-ml-IN.html TRANS.TBL

LoadBalancer RELEASE-NOTES-mr-IN.html

media.repo RELEASE-NOTES-or-IN.html

[root@oracle ~]# cp -rfv /mnt/* /temp/yum/

[root@oracle ~]# ls /temp/yum/

EFI Packages RELEASE-NOTES-pa-IN.html

EULA README RELEASE-NOTES-pt-BR.html

EULA_de RELEASE-NOTES-as-IN.html RELEASE-NOTES-ru-RU.html

EULA_en RELEASE-NOTES-bn-IN.html RELEASE-NOTES-si-LK.html

EULA_es RELEASE-NOTES-de-DE.html RELEASE-NOTES-ta-IN.html

EULA_fr RELEASE-NOTES-en-US.html RELEASE-NOTES-te-IN.html

EULA_it RELEASE-NOTES-es-ES.html RELEASE-NOTES-zh-CN.html

EULA_ja RELEASE-NOTES-fr-FR.html RELEASE-NOTES-zh-TW.html

EULA_ko RELEASE-NOTES-gu-IN.html repodata

EULA_pt RELEASE-NOTES-hi-IN.html ResilientStorage

EULA_zh RELEASE-NOTES-it-IT.html RPM-GPG-KEY-redhat-beta

GPL RELEASE-NOTES-ja-JP.html RPM-GPG-KEY-redhat-release

HighAvailability RELEASE-NOTES-kn-IN.html ScalableFileSystem

images RELEASE-NOTES-ko-KR.html Server

isolinux RELEASE-NOTES-ml-IN.html TRANS.TBL

LoadBalancer RELEASE-NOTES-mr-IN.html

media.repo RELEASE-NOTES-or-IN.html

[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 Size Used Avail Use% Mounted on

/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 ID e8562897: NOKEY

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 CLASSPATH

[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 CLASSPATH

[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

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI