oracle 11g 单实例+ASM 配置

最新推荐文章于 2022-06-06 17:53:05 发布

转载最新推荐文章于 2022-06-06 17:53:05 发布 · 485 阅读

文章标签：

#数据库

本文详细记录了在Red Hat Enterprise Linux Server 5.4环境下安装Oracle 11g RAC的过程，包括环境搭建、依赖包安装、用户及权限配置、磁盘配置、安装步骤等关键环节。

一、运行环境

Vbox 4.3.8

Red hat enterprise linux server release 5.4 x86

linux_11gR2_database_1of2
linux_11gR2_database_2of2
linux_11gR2_grid

二、安装准备

1、安装vbox，步骤略
dO*aI2fqBgAA&bo=KgLUAQAAAAABANo!

2、安装red hat 5.4，步骤略

3、创建用户、用户组、相关目录

[root@payne yum.repos.d]# groupadd -g 5000 asmadmin

[root@payne yum.repos.d]# groupadd -g 5001 asmdba

[root@payne yum.repos.d]# groupadd -g 5002 asmoper

[root@payne yum.repos.d]# groupadd -g 6000 oinstall

[root@payne yum.repos.d]# groupadd -g 6001 dba

[root@payne yum.repos.d]# groupadd -g 6002 oper

[root@payne yum.repos.d]# useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid

[root@payne yum.repos.d]# useradd -g oinstall -G dba,asmdba oracle

[root@payne yum.repos.d]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@payne yum.repos.d]# passwd grid

Changing password for user grid.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@payne yum.repos.d]# mkdir /s01

[root@payne yum.repos.d]# mkdir /g01

[root@payne yum.repos.d]# chown oracle:oinstall /s01

[root@payne yum.repos.d]# chown grid:oinstall /g01

4、下载oracle-validated-1.0.0-18.el5.i386.rpm包并安装报错，缺少依赖包

[root@payne tmp]# rpm -ivh oracle-validated-1.0.0-18.el5.i386.rpm

warning: oracle-validated-1.0.0-18.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

error: Failed dependencies:

compat-db is needed by oracle-validated-1.0.0-18.el5.i386

compat-gcc-34 is needed by oracle-validated-1.0.0-18.el5.i386

compat-gcc-34-c++ is needed by oracle-validated-1.0.0-18.el5.i386

libXp is needed by oracle-validated-1.0.0-18.el5.i386

libaio-devel is needed by oracle-validated-1.0.0-18.el5.i386

sysstat is needed by oracle-validated-1.0.0-18.el5.i386

unixODBC is needed by oracle-validated-1.0.0-18.el5.i386

unixODBC-devel is needed by oracle-validated-1.0.0-18.el5.i386

配置本地yum

[root@payne tmp]# cd /etc/yum.repos.d

[root@payne yum.repos.d]# ls

rhel-debuginfo.repo

[root@payne yum.repos.d]# touch pakg-inst.repo

[root@payne yum.repos.d]# vi pakg-inst.repo

[oel5]

name = Enterprise Linux 5.4 DVD

baseurl=file:///media/Server/

gpgcheck=0

enabled=1

[root@payne yum.repos.d]# mount /dev/cdrom /media

mount: block device /dev/cdrom is write-protected, mounting read-only

安装以上缺少的依赖包

[root@payne yum.repos.d]# yum -y install compat-db

[root@payne yum.repos.d]# yum -y install compat-gcc-34

[root@payne yum.repos.d]# yum -y install compat-gcc-34-c++

[root@payne yum.repos.d]# yum -y install libXp

[root@payne yum.repos.d]# yum -y install libaio-devel

[root@payne yum.repos.d]# yum -y install sysstat

[root@payne yum.repos.d]# yum -y install unixODBC

[root@payne yum.repos.d]# yum -y install unixODBC-devel
再安装oracle-validated包

[root@payne tmp]# rpm -ivh oracle-validated-1.0.0-18.el5.i386.rpm

warning: oracle-validated-1.0.0-18.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracle-validated ########################################### [100%]

[root@payne tmp]# vi /etc/security/limits.conf

oracle soft nofile 131072

oracle hard nofile 131072

oracle soft nproc 131072

oracle hard nproc 131072

oracle soft core unlimited

oracle hard core unlimited

oracle soft memlock 3500000

oracle hard memlock 3500000

将如上的oracle用户改为grid后添加在后面：

oracle soft nofile 131072

oracle hard nofile 131072

oracle soft nproc 131072

oracle hard nproc 131072

oracle soft core unlimited

oracle hard core unlimited

oracle soft memlock 3500000

oracle hard memlock 3500000

grid soft nofile 131072

grid hard nofile 131072

grid soft nproc 131072

grid hard nproc 131072

grid soft core unlimited

grid hard core unlimited

grid soft memlock 3500000

grid hard memlock 3500000

5、关闭系统添加配置磁盘

[root@payne tmp]# shutdown -h now

在VBOX上点击设置
dETO.GWVBwAA&bo=VQA3AAAAAAABAEU!

点击添加虚拟硬盘（添加了4块）
dH6sW2WRIQAA&bo=KgJpAQAAAAABAGc!
dHWeWGVYIAAA&bo=KgJlAQAAAAABAGs!

5、启动系统配置磁盘
查看磁盘情况

[root@payne ~]# fdisk -l

Disk /dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders