oracle数据库RAC实验V10Word文档下载推荐.docx
- 文档编号:16895749
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:43
- 大小:1.59MB
oracle数据库RAC实验V10Word文档下载推荐.docx
《oracle数据库RAC实验V10Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《oracle数据库RAC实验V10Word文档下载推荐.docx(43页珍藏版)》请在冰豆网上搜索。
按照
http:
//oracle-
注意:
问题一:
要多加个rpm-UvhunixODBC-2.*i386.rpm
问题二:
要配置swap到4G
问题三:
注意SID要和环境变量中设置完全一致
问题四:
配置DNS解析SCAN或者在hosts中指配置一个SCAN
七、具体安装步骤
1.安装linux操作系统
2.下载数据库软件安装包
OTN:
OracleDatabase11gRelease2(11.2.0.1)Software(64-bit)
MOS:
OracleDatabase11gRelease2(11.2.0.2or11.2.0.3)Software(64-bit)
#11.2.0.1
unziplinux.x64_11gR2_database_1of2.zip
unziplinux.x64_11gR2_database_2of2.zip
#11.2.0.2
unzipp10098816_112020_Linux-x86-64_1of7.zip
unzipp10098816_112020_Linux-x86-64_2of7.zip
#11.2.0.3
unzipp10404530_112030_Linux-x86-64_1of7.zip
unzipp10404530_112030_Linux-x86-64_2of7.zip
#11.2.0.4
unzipp13390677_112040_Linux-x86-64_1of7.zip
unzipp13390677_112040_Linux-x86-64_2of7.zip
3.安装操作系统(两台)(安装时包的选择如下)
DesktopEnvironments>
GNOMEDesktopEnvironment
Applications>
Editors
GraphicalInternet
Development>
DevelopmentLibraries
DevelopmentTools
Servers>
ServerConfigurationTools
BaseSystem>
AdministrationTools
Base
SystemTools
XWindowSystem
关闭防火墙设置
关闭Selinux设置
4.设置hosts文件(scan最多3个,最少1个)
public绑定eth0
private绑定eth1
127.0.0.1localhost.localdomainlocalhost
#public
192.168.56.104rac1.localdomainrac1
192.168.56.105rac2.localdomainrac2
#private
192.168.0.104rac1-priv.localdomainrac1-priv
192.168.0.105rac2-priv.localdomainrac2-priv
#virtual
192.168.56.106rac1-vip.localdomainrac1-vip
192.168.56.107rac2-vip.localdomainrac2-vip
#scan
192.168.56.108scan.localdomainscan
192.168.56.109scan.localdomainscan
192.168.56.110scan.localdomainscan
5.增加swap到4G
ddif=/dev/zeroof=/swapfilebs=1024count=2048000#创建2Gswap文件
mkswap/swapfile
swapon/swapfile
#vi/etc/fstab
/swapfileswapswapdefaults00
6.配置网络yum源
OracleLinux5
#cd/etc/yum.repos.d
#wgethttp:
//public-
RedHatEnterpriseLinux5orCompatible
//public--O/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
#gpg--quiet--with-fingerprint/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
pub1024D/1E5E01592007-05-18OracleOSSgroup(OpenSourceSoftwaregroup)
Keyfingerprint=99FD276628EEDECB5E5AF5F866CED3DE1E5E0159
sub1024g/D303656F2007-05-18[expires:
2015-05-16]
#yumlist
7.关闭防火墙和selinux
#serviceiptablesstop
#chkconfigiptablesoff
#vi/etc/selinux/config
SELINUX=permissive
8.配置NTP服务同步RAC服务器时间
此步骤可选,若不配置RAC的CTSS(集群时间同步服务)会根据主节点同步其它节点的时间。
servicentpdstop
vi/etc/sysconfig/ntpd
OPTIONS="
-x-untp:
ntp-p/var/run/ntpd.pid"
Servicentpdstart
9.设置内核参数
方法一:
使用root用户(一条命令操作完成所有需要的参数设置)
#yuminstalloracle-validated
方法二:
使用root用户
#vi/etc/sysctl.conf
fs.aio-max-nr=1048576
fs.file-max=6815744
kernel.shmall=2097152
kernel.shmmax=1054504960
kernel.shmmni=4096
#semaphores:
semmsl,semmns,semopm,semmni
kernel.sem=25032000100128
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
#/sbin/sysctl-p
#vi/etc/security/limits.conf
oraclesoftnproc2047
oraclehardnproc16384
oraclesoftnofile1024
oraclehardnofile65536
#vi/etc/pam.d/login
sessionrequiredpam_limits.so
10.挂载好光盘安装所需的软件包(使用root用户)
#mount/dev/cdrom/media
#cd/media/Server
rpm-Uvhbinutils-2.*
rpm-Uvhcompat-libstdc++-33*
rpm-Uvhcompat-libstdc++-33*.i386.rpm
rpm-Uvhelfutils-libelf*
rpm-Uvhgcc-4.*
rpm-Uvhgcc-c++-4.*
rpm-Uvhglibc-2.*
rpm-Uvhglibc-common-2.*
rpm-Uvhglibc-devel-2.*
rpm-Uvhglibc-headers-2.*
rpm-Uvhksh*
rpm-Uvhlibaio-0.*
rpm-Uvhlibaio-devel-0.*
rpm-Uvhlibgomp-4.*
rpm-Uvhlibgcc-4.*
rpm-Uvhlibstdc++-4.*
rpm-Uvhlibstdc++-devel-4.*
rpm-Uvhmake-3.*
rpm-Uvhsysstat-7.*
rpm-UvhunixODBC-2.*
rpm-UvhunixODBC-devel-2.*
rpm-UvhunixODBC-2.*.i386.rpm
rpm-Uvhnumactl-devel-*
cd
umount/dev/cdrom
eject
11.创建组和用户(使用root用户)
groupadd-g1000oinstall
groupadd-g1200dba
groupadd-g1300oper
useradd-u1100-goinstall-Gdba,operoracle
passwdoracle
12.创建所需的目录(使用root用户)
mkdir-p/u01/app/11.2.0/grid
mkdir-p/u01/app/oracle/product/11.2.0/db_1
chown-Roracle:
oinstall/u01
chmod-R775/u01/
13.设置oracle用户的环境变量(使用oracle用户)
#vi~/.bash_profile
#OracleSettings
TMP=/tmp;
exportTMP
TMPDIR=$TMP;
exportTMPDIR
#rac2
ORACLE_HOSTNAME=rac1.localdomain;
exportORACLE_HOSTNAME
ORACLE_UNQNAME=rac;
exportORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle;
exportORACLE_BASE
GRID_HOME=/u01/app/11.2.0/grid;
exportGRID_HOME
DB_HOME=$ORACLE_BASE/product/11.2.0/db_1;
exportDB_HOME
ORACLE_HOME=$DB_HOME;
exportORACLE_HOME
ORACLE_SID=rac1;
exportORACLE_SID
ORACLE_TERM=xterm;
exportORACLE_TERM
BASE_PATH=/usr/sbin:
$PATH;
exportBASE_PATH
PATH=$ORACLE_HOME/bin:
$BASE_PATH;
exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib;
exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib;
exportCLASSPATH
if[$USER="
oracle"
];
then
if[$SHELL="
/bin/ksh"
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
fi
aliasgrid_env='
./home/oracle/grid_env'
aliasdb_env='
./home/oracle/db_env'
#.~/.bash_profile或source~/.bash_profile
14.创建/home/oracle/grid_env脚本(切换环境变量)
ORACLE_SID=+ASM;
ORACLE_HOME=$GRID_HOME;
chmod+xgrid_env
15.创建/home/oracle/db_env脚本(切换环境变量)
chmod+xdb_env
16.选择一台服务器创建dns服务器解析SCN地址
选择rac2机器进行配置dns
rpm-ivhbind*.rpm--nodeps--force
cd/var/named/chroot/etc/
vinamed.conf
//
//named.confforRedHatcaching-nameserver
options{
directory"
/var/named"
;
dump-file"
/var/named/data/cache_dump.db"
statistics-file"
/var/named/data/named_stats.txt"
/*
*Ifthereisafirewallbetweenyouandnameserversyouwant
*totalkto,youmightneedtouncommentthequery-source
*directivebelow.PreviousversionsofBINDalwaysasked
*questionsusingport53,butBIND8.1usesanunprivileged
*portbydefault.
*/
//query-sourceaddress*port53;
};
//acachingonlynameserverconfig
controls{
inet127.0.0.1allow{localhost;
}keys{rndckey;
};
zone"
."
IN{
typehint;
file"
named.ca"
localdomain"
typemaster;
localdomain.zone"
allow-update{none;
#zone"
localhost"
#typemaster;
#file"
localhost.zone"
#allow-update{none;
#};
0.0.127.in-addr.arpa"
named.local"
######################################
#ADDfororacleRACSCAN,
#STARTFROMHERE
56.168.192.in-addr.arpa"
56.168.192.in-addr.local"
0.168.192.in-addr.arpa"
0.168.192.in-addr.local"
#####################################
#ENDFROMHERE
cd/var/named/chroot/var/named
vi56.168.192.in-addr.local
$TTL86400
@INSOAlocalhost.root.localhost.(
1997022700;
Serial
28800;
Refresh
14400;
Retry
3600000;
Expire
86400);
Minimum
INNSlocaldomain.
104INPTRrac1.localdomain.
105INPTRrac2.localdomain.
106INPTRrac1-vip.localdomain.
107INPTRrac2-vip.localdomain.
108INPTRscan.localdomain.
109INPTRscan.localdomain.
110INPTRscan.localdomain.
vi0.168.192.in-addr.local
104INPTRrac1-priv.localdomain.
105INPTRrac2-priv.localdomain.
vilocaldomain.zone
@INSOAlocalhostroot(
42;
serial(d.adams)
3H;
refresh
15M;
retry
1W;
expiry
1D);
minimum
rac1INA192.168.56.104
rac2INA192.168.56.105
rac1-privINA192.168.0.104
rac2-privINA192.168.0.105
scanINA192.168.56.108
scanINA192.168.56.109
scanINA192.168.56.110
rac1-vipINA192.168.56.106
rac2-vipINA192.168.56.107
ln-s/var/named/chroot/etc/named.conf/etc/named.conf
cd/var/run
chmod777named
servicenamedstop
servicenamedstart
#将两台都配置
vi/etc/resolv.conf
searchlocaldomain
nameserver192.168.56.105
nslookupscan.localdomain
17.安装配置另一台服务器
安装和配置的方法如上第一台操作,注意一些参数的改变。
18.创建ASM磁盘,并将磁盘挂在到两个系统上
使用裸设备
通过virtualbox创建虚拟磁盘,并将磁盘设置为共享,进入系统,将磁盘进行分区(注意磁盘的大小要固定)
如下图进行设置磁盘共享:
第二台机器添加上共享的磁盘。
后面两台机器都如下操作。
fdisk–l
fdisk/dev/sdb
分好区执行下面操作:
vi/etc/udev/rules.d/60-raw.rules
ACTION=="
add"
KERNEL=="
sdb1"
RUN+="
/bin/raw/dev/raw/raw1%N"
KERN
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle 数据库 RAC 实验 V10