Oracle Linux 71 安装Oracle 12C RAC.docx

资源描述

Oracle Linux 71 安装Oracle 12C RAC.docx

《Oracle Linux 71 安装Oracle 12C RAC.docx》由会员分享，可在线阅读，更多相关《Oracle Linux 71 安装Oracle 12C RAC.docx（13页珍藏版）》请在冰点文库上搜索。

Oracle Linux 71 安装Oracle 12C RAC.docx

OracleLinux71安装Oracle12CRAC

OracleLinux7.1安装Oracle12CRAC

OS环境：

[root@rac12c1~]#uname-a

Linuxrac12c13.8.13-55.1.6.el7uek.x86_64#2SMPWedFeb1114:

18:

22PST2015x86_64x86_64x86_64GNU/Linux

IP规划：

[root@rac12c1~]#cat/etc/hosts

127.0.0.1 localhostlocalhost.localdomainlocalhost4localhost4.localdomain4

1 localhostlocalhost.localdomainlocalhost6localhost6.localdomain6

#PublicIPfor Oracle 12CRAC

172.16.30.221 rac12c1.localdomain rac12c1

172.16.30.222 rac12c2.localdomain rac12c2

#PrivateIPforOracle12CRAC

192.168.30.221 rac12c1pri.localdomainrac12c1pri

192.168.30.222 rac12c1pri.localdomainrac12c2pri

#VirtualIPforOracle12CRAC

172.16.30.223 rac12c1vip.localdomainrac12c1vip

172.16.30.224 rac12c2vip.localdomainrac12c2vip

#SCAN

172.16.30.225rac12c-scan.localdomainrac12c-scan

禁用Selinux：

[root@rac12c1~]#cat/etc/selinux/config

#ThisfilecontrolsthestateofSELinuxonthesystem.

#SELINUX=cantakeoneofthesethreevalues:

# enforcing-SELinuxsecuritypolicyisenforced.

# permissive-SELinuxprintswarningsinsteadofenforcing.

# disabled-NoSELinuxpolicyisloaded.

SELINUX=disabled

#SELINUXTYPE=cantakeoneofthreetwovalues:

# targeted-Targetedprocessesareprotected,

# minimum-Modificationoftargetedpolicy.Onlyselectedprocessesareprotected.

# mls-MultiLevelSecurityprotection.

SELINUXTYPE=targeted

[root@rac12c1~]#setenforce0

修改/dev/shm大小为8G

tmpfs /dev/shm tmpfs rw,exec,size=2048M00

[root@rac12c1~]#mount-oremount/dev/shm/

禁用防火墙：

[root@rac12c1~]#systemctlstartfirewalld.service

[root@rac12c1~]#systemctlstopfirewalld.service

[root@rac12c1~]#]#systemctldisablefirewalld.service

rm'/etc/systemd/system/basic.target.wants/firewalld.service'

rm'/etc/systemd/system/dbus-org.Fedoraproject.FirewallD1.service'

重启各个节点操作系统，检查各个节点网络连通性：

[root@rac12c1~]#pingrac12c2pri

[root@rac12c1~]#pingrac12c2

，，，

配置YUM:

[root@rac12c1~]#cat/etc/yum.repos.d/base.repo

[ol7_latest]

name=OracleLinux$releaseverLatest（$basearch）

baseurl=file:

///mnt

gpgkey=file:

///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=0

enabled=1

安装oracle相关的依赖包：

[root@rac12c1~]#yuminstalloracle-rdbms-server-12cR1-preinstall–y

创建用户组和用户，上步操作依据创建了oinstall54321dba54322用户组）和用户oracle（54321），所以执行如下操作创建相关的用户组和用户

添加组

[root@rac12c1~]#groupadd-g54323oper

[root@rac12c1~]# groupadd-g54325asmdba

[root@rac12c1~]#groupadd-g54328asmadmin

[root@rac12c1~]#groupadd-g54329asmoper

添加grid用户

[[root@rac12c1~]#useradd-u54322-goinstall-Gdba,asmdba,asmadmin,asmopergrid

为oracle和grid用户设置密码

[[root@rac12c1~]#passwdoracle

[root@rac12c1~]#passwdgrid

确保oracle是oper，asmdba组成员

[root@rac12c1~]# usermod -goinstall-Gdba,oper,asmdbaoracle

修改用户资源限制:

gridsoftnofile1024

gridhardnofile65536

gridsoftnproc16384

gridhardnproc16384

gridsoftstack10240

gridhardstack32768

gridhardmemlock134217728

gridsoftmemlock134217728

##Oracleuser

oraclesoftnofile1024

oraclehardnofile65536

oraclesoftnproc16384

oraclehardnproc16384

oraclesoftstack10240

oraclehardstack32768

oraclehardmemlock13217728

oraclesoftmemlock134217728

#Endoffile

修改内核参数，

fs.file-max=6815744

kernel.sem=25032000100128

kernel.shmmni=4096

kernel.shmall=1073741824

kernel.shmmax=4398046511104

kernel.panic_on_oops=1

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048576

fs.aio-max-nr=1048576

net.ipv4.ip_local_port_range=900065500

[root@rac12c1~]#/sbin/sysctl-p

安装oracleasm-supportandoracleasmlib，配置共享磁盘。

[root@rac12c1~]#rpm-qa|greporacleasm

kmod-oracleasm-2.0.8-8.el7.x86_64

oracleasm-support-2.1.8-3.el7.x86_64

oracleasmlib-2.0.8-2.el7.x86_64

下载ASMLIB包。

[root@rac12c1~]#/etc/init.d/oracleasmconfigure-i

ConfiguringtheOracleASMlibrarydriver.

Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary

driver. Thefollowingquestionswilldeterminewhetherthedriveris

loadedonbootandwhatpermissionsitwillhave. Thecurrentvalues

willbeshowninbrackets（'[]'）. Hittingwithouttypingan

answerwillkeepthatcurrentvalue. Ctrl-Cwillabort.

Defaultusertoownthedriverinterface[grid]:

grid

Defaultgrouptoownthedriverinterface[asmadmin]:

asmadmin

ScanforOracleASMdisksonboot（y/n）[y]:

WritingOracleASMlibrarydriverconfiguration:

done

InitializingtheOracleASMLibdriver:

[ OK ]

ScanningthesystemforOracleASMLibdisks:

[ OK ]

[root@rac12c1~]#/usr/sbin/oracleasmconfigure

ORACLEASM_UID=grid

ORACLEASM_GID=asmadmin

ORACLEASM_SCANBOOT=true

ORACLEASM_SCANORDER=""

ORACLEASM_SCANEXCLUDE=""

ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

[root@rac12c1~]#tail-2/etc/pam.d/login

sessionrequired/lib64/security/pam_limits.so

sessionrequiredpam_limits.so

配置DNS:

[root@rac12c1~]#vim/etc/resolv.conf

#GeneratedbyNetworkManager

searchlocaldomain

禁用NTP服务：

[root@rac12c1~]#/sbin/servicentpdstop

[root@rac12c1~]#chkconfigntpdoff

[root@rac12c1~]#mv/etc/ntp.conf/etc/ntp.conf.org

[root@rac12c1~]#rm/var/run/ntpd.pid

建立安装目录：

[root@rac12c1~]#mkdir-p/u01/app/12.1.0/grid

[root@rac12c1~]#mkdir-p/u01/app/grid

[root@rac12c1~]#mkdir-p/u01/app/oracle

[root@rac12c1~]#mkdir-p/u01/app/oracle/product/12.1.0/db_1[root@rac12c1~]#chown-Rgrid:

oinstall/u01

[root@rac12c1~]#chownoracle:

oinstall/u01/app/oracle

[root@rac12c1~]##chmod-R775/u01/

分区，配置共享磁盘：

[oracle@rac12c1~]$ls-l/dev/sd*

brw-rw----1rootdisk8, 0Aug2118:

33/dev/sda

brw-rw----1rootdisk8, 1Aug2118:

33/dev/sda1

brw-rw----1rootdisk8, 2Aug2118:

33/dev/sda2

brw-rw----1rootdisk8, 3Aug2118:

33/dev/sda3

brw-rw----1rootdisk8,16Aug2220:

27/dev/sdb

brw-rw----1rootdisk8,17Aug2220:

27/dev/sdb1

brw-rw----1rootdisk8,32Aug2122:

47/dev/sdc

brw-rw----1rootdisk8,33Aug2122:

47/dev/sdc1

brw-rw----1rootdisk8,48Aug2122:

47/dev/sdd

brw-rw----1rootdisk8,49Aug2122:

47/dev/sdd1

brw-rw----1rootdisk8,64Aug2122:

47/dev/sde

brw-rw----1rootdisk8,65Aug2122:

47/dev/sde1

[oracle@rac12c1~]$/etc/init.d/oracleasmcreatediskCRS/dev/sdc1

[oracle@rac12c1~]$/etc/init.d/oracleasmcreatediskDATA1/dev/sd1

[oracle@rac12c1~]$/etc/init.d/oracleasmcreatediskDATA2/dev/sde1

[root@rac12c1~]#/etc/init.d/oracleasmscandisks

ScanningthesystemforOracleASMLibdisks:

[ OK ]

[root@rac12c1~]#/etc/init.d/oracleasmlistdisks

CRS

DATA1

DATA2

另外一个节点，扫描共享磁盘。

配置用户环境变量：

[root@rac12c1~]#cat/home/grid/.bash_profile

#.bash_profile

#Getthealiasesandfunctions

if[-f~/.bashrc];then

.~/.bashrc

#Userspecificenvironmentandstartupprograms

PATH=$PATH:

$HOME/.local/bin:

$HOME/bin

exportPATH

exportORACLE_BASE=/u01/app/grid

exportORACLE_HOME=/u01/app/12.1.0/grid

exportORACLE_SID=+ASM1

exportPATH=$ORACLE_HOME/bin:

$PATH

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:

/lib:

/usr/lib

exportCLASSPATH=$ORACLE_HOME/JRE:

$ORACLE_HOME/jlib:

$ORACLE_HOME/rdbms/jlib

exportDISPLAY=:

0.0

umask=022

aliasasmcmd='rlwrapasmcmd'

[root@rac12c1~]#cat/home/oracle/.bash_profile

#.bash_profile

#Getthealiasesandfunctions

if[-f~/.bashrc];then

.~/.bashrc

#Userspecificenvironmentandstartupprograms

PATH=$PATH:

$HOME/.local/bin:

$HOME/bin

exportPATH

PATH=$PATH:

$HOME/bin

exportORACLE_BASE=/u01/app/oracle

exportORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1

exportORACLE_SID=crmdb1

exportPATH=$ORACLE_HOME/bin:

$PATH

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:

/lib:

/usr/lib

exportCLASSPATH=$ORACLE_HOME/JRE:

$ORACLE_HOME/jlib:

$ORACLE_HOME/rdbms/jlib

exportDISPLAY=:

0.0

umask=022

exportPATH

aliassqlplus='rlwrapsqlplus'

aliasrman='rlwraprman'

安装cvuqdisk软件包

[root@rac12c1~]#rpm-ivhcvuqdisk-1.0.9-1.rpm

开始安装GRID=》安装数据软件=>安装数据库。

[grid@rac12c1rpm]$crsctlstatres-t

--------------------------------------------------------------------------------

Name Target State Server Statedetails

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.CRS.dg

ONLINE ONLINE rac12c1 STABLE

ONLINE ONLINE rac12c2 STABLE

ora.DATA.dg

ONLINE ONLINE rac12c1 STABLE

ONLINE ONLINE rac12c2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE rac12c1 STABLE

ONLINE ONLINE rac12c2 STABLE

ora.asm

ONLINE ONLINE rac12c1 Started,STABLE

ONLINE ONLINE rac12c2 Started,STABLE

work

ONLINE ONLINE rac12c1 STABLE

ONLINE ONLINE rac12c2 STABLE

ora.ons

ONLINE ONLINE rac12c1 STABLE

ONLINE ONLINE rac12c2 STABLE

--------------------------------------------------------------------------------

ClusterResources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac12c1 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE rac12c1 169.254.109.21819

展开阅读全文