欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Oracle 11g RAC 在 CentOS 5.5 的安装日志

程序员文章站 2022-06-06 18:37:10
...

Oracle 11g RAC 在 CentOS 5.5 的安装日志

服务器
DELL R410 2台
CPU INTER E5620 .4GHz 12M4C
MEM 64G
DISK 300G

存储器
DS3512
DISK 600G*12 RAID5

(因为JS以次充好,在服务器光纤卡上,搞了一个月,,才把问题解决掉。

出现问题:
1.服务器时不时找不到存储器;
2.在存储器设置端,找不到光纤卡接口。
3.服务器重启后,找不到存储器,要存储器重启后才可找到


最后还是用一块4GB的当了8GB给了我们。速度肯定是打折了。
那个气呀。使用不同的硬件产品,就是麻烦)



软件环境:
CentOS 5.5 64bit
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0(64位)


1、服务器本地磁盘分区:

Disk /dev/sda: 300.0 GB, 300000000000 bytes
255 heads, 63 sectors/track, 36472 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 25 200781 83 Linux
/dev/sda2 26 36472 292760527+ 8e Linux LVM


使用了LVM 分区,后使用卷。
关于LVM 资料如下:


2、IP规划

[root@rac2 app]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6


#public ip
192.168.18.101 rac1
192.168.18.103 rac2

#priv ip
192.168.0.101 rac1-private
192.168.0.103 rac2-private

#vip ip
192.168.18.121 rac1-vip
192.168.18.123 rac2-vip

#scan ip
192.168.18.100 rac-scan

(注意:All host names must conform to the RFC 952 standard,
which permits alphanumeric characters, Host name using underscores(“_”)
are not allowed.HOSTS 文件中不支持“_” 字符)

3、用户/组

/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
/usr/sbin/groupadd -g 503 oper
/usr/sbin/groupadd -g 504 asmadmin
/usr/sbin/groupadd -g 505 asmoper
/usr/sbin/groupadd -g 506 asmdba
/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle
/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

[root@ora1 ~]# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
[root@ora1 ~]# id grid
uid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)


mkdir -p /opt/app/oraInventory
chown -R grid:oinstall /opt/app/oraInventory
chmod -R 775 /opt/app/oraInventory

mkdir -p /opt/app/grid
mkdir -p /opt/app/oracle
chown -R grid:oinstall /opt/app/grid
chown -R oracle:oinstall /opt/app/oracle
chmod -R 775 /opt/app/oracle
chmod -R 775 /opt/app/grid

passwd grid
passwd oracle

4、修改系统参数:
vi /etc/security/limits.conf

#ORACLE SETTING
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536


vi /etc/pam.d/login

#ORACLE SETTING
session required pam_limits.so

# vi /etc/sysctl.conf

#ORACLE SETTING
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


5、gird时间同步所需要的设置(11gR2新增检查项)

#Network Time Protocol Setting
/sbin/service ntpd stop
chkconfig ntpd off
#rm /etc/ntp.conf
mv /etc/ntp.conf /etc/ntp.conf.org


选择是开启还是关闭SELINUX的工作模式(修改这一项后最好重启一下操作系统)

[root@oracle ~]# vi /etc/selinux/config

# 设置SELINUX为disabled

SELINUX=disabled

6、操作系统版本:

[root@rac1 ~]# lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description: CentOS release 5.5 (Final)
Release: 5.5
Codename: Final

[root@rac1 ~]# uname -a

Linux solr03 2.6.18-194.11.4.el5 #1 SMP Tue Sep 21 05:04:09 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[root@rac1 ~]#

7、修改系统的发行版本

[root@oracle ~]# vi /etc/RedHat-release

将CentOS release 5 (Final) 修改成
#CentOS release 5 (Final)
Red Hat Enterprise Linux AS release 5 (Nahant Update 5)

(因为oracle公司没推出CentOS版本的oracle)

Oracle 11g RAC 在 CentOS 5.5 的安装日志