rac安装后总结.docx
- 文档编号:10305764
- 上传时间:2023-02-10
- 格式:DOCX
- 页数:12
- 大小:18.90KB
rac安装后总结.docx
《rac安装后总结.docx》由会员分享,可在线阅读,更多相关《rac安装后总结.docx(12页珍藏版)》请在冰豆网上搜索。
rac安装后总结
5.4 linux安装 oracle总结:
Redhat5.4x64安装ORACLE10G
修改/etc/xinetd.d/wu-ftpd中的disable=yes为disable=no,保存
执行servicexinetdrestart开启FTP
1.首先安装以下包:
rpm-qglibcglibc-commonglibc-devellibXpbinutilsbinutilscompat-dbcontrol-entergccgcc-c++libstdc++libstdc++-develmakekshsysstatgnome-screensaverlibaio-devellibaioopenmotif22
用以下命令检查是否全部成功:
$rpm-qa|grepglibc-2
glibc-2.3.4-2.13
compat-glibc-2.3.2-95.30
compat-glibc-2.3.2-95.30
glibc-2.3.4-2.13
$rpm-qa|grepglibc-devel
glibc-devel-2.3.4-2.13
glibc-devel-2.3.4-2.1332(32位)
rpm-qa--queryformat"%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n"|grep终极
查看法
2.以root用户身份执行,在两节点上做如下配置。
编辑/etc/sysctl.conf文件
#vi/etc/sysctl.conf
在文件尾部添加下述内容
kernel.shmall=2097152
kernel.shmmax=4294967297//物理内存的一半
kernel.shmmni=4096
kernel.sem=25032000100128
vm.min_free_kbytes=409600
vm.vfs_cache_pressure=200
vm.swappiness=40
fs.file-max=101365
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=1048576//256K
net.core.rmem_max=1048576//1M
net.core.wmem_default=262144
net.core.wmem_max=1048576
Sysctl-p生效
3.为oracle用户设置Shell限制.
Oracle建议对每个Linux帐户可以使用的进程数和打开的文件数设置限制,ROOT登录.(
/etc/profilefile(orthefileonSUSEsystems)/etc/profile.local:
if[$USER="oracle"];then
if[$SHELL="/bin/ksh"];then
ulimit-p16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
fi
■FortheCshell(cshortcsh),addthefollowinglinestothe
/etc/csh.loginfile(orthefileonSUSE
systems)/etc/csh.login.local:
if($USER=="oracle")then
limitmaxproc16384
limitdescriptors65536
endif
Addthefollowinglinestothe/etc/security/limits.conffile:
oraclesoftnproc2047
oraclehardnproc16384
oraclesoftnofile1024
oraclehardnofile65536
修改/etc/pam.d/login,增加以下内容
sessionrequired/lib/security/pam_limits.so
配置hangcheck-timer内核模块
以root用户身份执行,在两节点上做如下配置。
查看模块是否存在
#find/lib/modules-name"hangcheck-timer.ko"
编辑/etc/modprobe.conf
#vi/etc/modprobe.conf
在文件的末尾加入一行
optionshangcheck-timerhangcheck_tick=30hangcheck_margin=180
配置为自启动
vi/etc/rc.d/rc.local
在文件的末尾加入一行
/sbin/modprobehangcheck_timer
启动hangcheck
#modprobehangcheck_timer
检查hangcheck是否成功启动
#grephangcheck/var/log/messages|tail-2
如果显示下述信息说明已经成功启动hangcheck
Mar1612:
52:
32node2kernel:
Hangcheck:
startinghangchecktimer0.5.0(tickis180seconds,marginis60seconds).
4.创建ORACLE用户及文件夹权限等
新增组和用户:
groupaddoinstall
groupadddba
useradd-goinstall-Gdbaoracle
passwdoracle
创建Oracle的安装目录,并把权限付给oracle用户:
mkdiroracle
chown-Roracle:
oinstall/oracle
解压database
修改database目录权限,用户和用户组
chown-Roracle:
oinstalldatabase/
chmod-R775database/
5.修改/etc/hosts文件及oracle用户里的.bash_profile文件
#Getthealiasesandfunctions
if[-f~/.bashrc];then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms
PATH=$PATH:
$HOME/bin:
/usr/bin:
/etc:
/usr/sbin:
/usr/ucb:
$HOME/bin:
/usr/bin/X11:
/sbin
exportPATH
unsetUSERNAME
ORA_CRS_BASE=/oracle/crs
ORA_CRS_HOME=$ORA_CRS_BASE/product/10.2.0/crs_1
ORACLE_BASE=/oracle/app
#ORACLE_BASE=$ORA_CRS_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
#ORACLE_HOME=$ORA_CRS_HOME
ORACLE_SID=oradb1
PATH=$ORACLE_HOME/bin:
$ORA_CRS_HOME/bin:
/usr/local/bin:
$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
$ORACLE_HOME/lib32:
$ORA_CRS_HOME/lib:
$ORA_CRS_HOME/lib32
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
exportORA_CRS_BASEORA_CRS_HOMEPATHNLS_LANGORACLE_BASEORACLE_HOMEORACLE_SIDLD_LIBRARY_PATH
6.安装一些RAC_的必要包
compat-binutils215-2.15.92.0.2-24.i386.rpm
oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpm
oracleasm-2.6.18-164.el5debug-2.0.5-1.el5.x86_64.rpm
oracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.x86_64.rpm
oracleasm-2.6.18-164.el5xen-2.0.5-1.el5.x86_64.rpm
oracleasmlib-2.0.4-1.el5.x86_64.rpm
oracleasm-support-2.1.3-1.el5.x86_64.rpm
7.配置SSH
用ORACLE用户执行
分别在2台机上运行
mkdir~/.ssh
chmod700~/.ssh
cd.ssh
/usr/bin/ssh-keygen-trsa(回车就OK)
#/usr/bin/ssh-keygen-tdsa(回车就OK)这可以不做
在RAC1机上运行
ssh name1cat/home/oracle/.ssh/id_rsa.pub>>authorized_keys
#sshname1cat/home/oracle/.ssh/id_dsa.pub>>authorized_keys这可以不做
sshname2cat/home/oracle/.ssh/id_rsa.pub>>authorized_keys
#sshname2cat/home/oracle/.ssh/id_dsa.pub>>authorized_keys这可以不做
把authorized_keyscp到RAC2中/home/oracle/.ssh/
scpauthorized_keysrac2:
/home/oracle/.ssh/
(分别在2台机上运行)
chmod600authorized_keys
sshrac2date
exec/usr/bin/ssh-agent$SHELL
/usr/bin/ssh-add
确定ForwardX11置为no
编辑或创建$vi~oracle/.ssh/config
内容如下:
Host*
ForwardX11no
8.Ntpdate....IP时间同步
Vi/etc/ntp.conf
服务端
restrict0.0.0.0mask0.0.0.0nomodify
server127.127.1.0
fudge127.127.1.0stratum10
driftfile/var/lib/ntp/drift
broadcastdelay0.008
authenticateno
keys/etc/ntp/keys
运行chkconfigntpon/etc/init.d/ntpdrestart
客务端
restrict0.0.0.0mask0.0.0.0nomodify
server127.127.1.0
Server..ip
fudge127.127.1.0stratum10
driftfile/var/lib/ntp/drift
broadcastdelay0.008
authenticateno
keys/etc/ntp/keys
运行ntpdatedb1出现信息调整的信息表示成功,一般要5分钟走左右
如果是把内核时间更新到当前时间,就用下面的命令:
hwclock--hctosys
检查ntp的版本,如果你使用的是ntp4.2(包括4.2)之后的版本,在restrict的定义中使用了notrust的话,会导致以上错误。
使用以下命令检查ntp的版本:
ntpd-cversion
如何去掉notrust?
9.磁盘分区
10.配置裸设备
vi/etc/udev/rules.d/60-raw.rules
ACTION=="add",KERNEL=="sddlmac1",RUN+="/bin/raw/dev/raw/raw1%N"
ACTION=="add",KERNEL=="sddlmac2",RUN+="/bin/raw/dev/raw/raw2%N"
ACTION=="add",KERNEL=="sddlmac5",RUN+="/bin/raw/dev/raw/raw3%N"
ACTION=="add",KERNEL=="sddlmac6",RUN+="/bin/raw/dev/raw/raw4%N"
ACTION=="add",KERNEL=="sddlmac7",RUN+="/bin/raw/dev/raw/raw5%N"
KERNEL=="raw[1-5]",OWNER="oracle",GROUP="oinstall",MODE="640"
用 RAW-QA查看裸设备情况
11.配置asm
注意:
必须以root身份进行
首先在node1执行:
[root@node1~]#/etc/init.d/oracleasmconfigure
ConfiguringtheOracleASMlibrarydriver.
Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary
driver.Thefollowingquestionswilldeterminewhetherthedriveris
loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues
willbeshowninbrackets('[]').Hitting
answerwillkeepthatcurrentvalue.Ctrl-Cwillabort.
Defaultusertoownthedriverinterface[]:
oracle
Defaultgrouptoownthedriverinterface[]:
dba
StartOracleASMlibrarydriveronboot(y/n)[n]:
y
FixpermissionsofOracleASMdisksonboot(y/n)[y]:
y
WritingOracleASMlibrarydriverconfiguration:
[OK]
Loadingmodule"oracleasm":
[OK]
MountingASMlibdriverfilesystem:
[OK]
ScanningsystemforASMdisks:
[OK]
提示:
如果本步执行出错(可能出错机率最高的是在ScanningsystemforASM),不妨将转换一下命令行
[三思笔记]-手把手教你用VMware在linux下安装Oracle10gRACQQ:
5454589君三思群:
59666289
的执行方式,改成:
[root@node1~]#sh/etc/init.d/oracleasmconfigure
有可能解决你的问题!
然后切换至node2执行
[root@node2~]#/etc/init.d/oracleasmconfigure
ConfiguringtheOracleASMlibrarydriver.
Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary
driver.Thefollowingquestionswilldeterminewhetherthedriveris
loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues
willbeshowninbrackets('[]').Hitting
answerwillkeepthatcurrentvalue.Ctrl-Cwillabort.
Defaultusertoownthedriverinterface[]:
oracle
Defaultgrouptoownthedriverinterface[]:
dba
StartOracleASMlibrarydriveronboot(y/n)[n]:
y
FixpermissionsofOracleASMdisksonboot(y/n)[y]:
y
WritingOracleASMlibrarydriverconfiguration:
[OK]
Loadingmodule"oracleasm":
[OK]
MountingASMlibdriverfilesystem:
[OK]
ScanningsystemforASMdisks:
[OK]
再切换回node1执行
[root@node1~]#/etc/init.d/oracleasmcreatediskVOL1/dev/sdd1
Markingdisk"/dev/sdd1"asanASMdisk:
[OK]
[root@node1~]#/etc/init.d/oracleasmcreatediskVOL2/dev/sde1
Markingdisk"/dev/sde1"asanASMdisk:
[OK]
[root@node1linux-patch]#/etc/init.d/oracleasmscandisks
ScanningsystemforASMdisks:
[OK]
查看一下当前的磁盘组:
ScanningsystemforASMdisks:
[OK]
[root@node1~]#/etc/init.d/oracleasmlistdisks
VOL1
VOL2
Node2上也查看一下当前磁盘组:
[root@node2~]#/etc/init.d/oracleasmscandisks
ScanningsystemforASMdisks:
[OK]
[root@node2~]#/etc/init.d/oracleasmlistdisks
VOL1
VOL2
[三思笔记]-手把手教你用VMware在linux下安装Oracle10gRACQQ:
5454589君三思群:
59666289
Ok,配置完成,准备进入到crs的安装阶段
一些命令
Etc/grub.conf修改内核enforcing=0
---------------------------------
--------------------
Xhost+
Xclock 确认介面
ExportDISPLAY=:
0.0
ExportLNAG=en_US 调整语言
在oracel用户下查看 crs_stat-t 则显示集群状态
打补丁前要 Crs_stop-all停止集群.
Netca
创建数据库dbca
当未成功时完全卸载RAC
rm-f/etc/init.d/init.cssd
rm-f/etc/init.d/init.crs
rm-f/etc/init.d/init.crsd
rm-f/etc/init.d/init.evmd
rm-f/etc/rc2.d/K96init.crs
rm-f/etc/rc2.d/S96init.crs
rm-f/etc/rc3.d/K96init.crs
rm-f/etc/rc3.d/S96init.crs
rm-f/etc/rc5.d/K96init.crs
rm-f/etc/rc5.d/S96init.crs
rm-Rf/etc/oracle/scls_scr
rm-f/etc/inittab.crs
cp/etc/inittab.orig/etc/inittab
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- rac 安装 总结
![提示](https://static.bdocx.com/images/bang_tan.gif)