Oracle11gR2數(shù)據(jù)庫(kù)安裝指南

OraclellgR2數(shù)據(jù)庫(kù)安裝指南

文檔作者:王銳

創(chuàng)建日期:

確認(rèn)日期:

控制編碼:

1.概述錯(cuò)誤!未定義書簽。

2.系統(tǒng)環(huán)境配置錯(cuò)誤!未定義書簽。

2.1.硬件環(huán)境檢查及配置錯(cuò)誤!未定義書簽。

2.2.軟件環(huán)境檢查及配置錯(cuò)誤!未定義書簽。

3.安裝Gridinfrastructure錯(cuò)誤!未定義書簽。

4.安裝Database軟件錯(cuò)誤!未定義書簽。

5.創(chuàng)建數(shù)據(jù)庫(kù)實(shí)例錯(cuò)誤!未定義書簽。

6.驗(yàn)證數(shù)據(jù)庫(kù)狀態(tài)錯(cuò)誤!未定義書簽。

1.概述

本文檔的目的是為了給出Oracle1lgR2數(shù)據(jù)庫(kù)在ECSSSD上的安裝配置示例。便于用戶在阿里

云環(huán)境部署Oracle數(shù)據(jù)庫(kù)支撐環(huán)境。本次安裝所采用的系統(tǒng)平臺(tái)OS：CentOS6.5,ORACLE數(shù)據(jù)庫(kù)為

llgR2數(shù)據(jù)庫(kù)。

2.系統(tǒng)環(huán)境配置

硬件：ECS高級(jí)配置，16核、64GB內(nèi)存、20GB本地存儲(chǔ)、4塊SSD存儲(chǔ)（100GB1塊，200GB3

塊）

軟件：阿里云CentOS6.5,Oracle11gR2（grid+database+ASM,建議11gR2最新版本

）

2.1.硬件環(huán)境檢查及配置

1.檢查內(nèi)存和SWAP

檢查內(nèi)存：最少2GB,實(shí)際上OS自身就需要1GB多，數(shù)據(jù)庫(kù)本身需要2GB以上，所以實(shí)際內(nèi)存至

少4GB以上。

#grepMemTotal/proc/meminfo

#grepSwapTotal/proc/meminfo

配置SWAP：ECS缺省SWAP沒(méi)有配置。

AvailableRAMSwapSpaceRequired

Between1GBand2GB1.5timesthesizeoftheRAM

Between2GBand16GBEqualtothesizeoftheRAM

Morethan16GB16GB

由于ECS只提供20GB本地盤，所以建議掛載一塊SATA磁盤作為軟件安裝和SWAP空間。建議磁盤

大小為25GB以上(SWAP16GB,Orac為5GB,Grid3.5GB)0可以參考：

ttfdisk-1

[root@iz23pbxddnmz?]#fdisk-1

Disk/dev/xvda:21.5GB,21474836480bytes

255heads,63sectors/track,2610cylinders

Units=cylindersof16065*512=8225280bytes

Sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:0x00078f9c

Id

DeviceBootstartEndBlocks83system

/dev/xvdal*1261120970496Linux

Disk/dev/xvdb:214.7GB,214748364800bytes

255heads,63sectors/track,26108cylinders

Units=cylindersof16065*512=8225280bytes

Sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:0x00000000

Disk/dev/xvdc:214.7GB,214748364800bytes

255heads,63sectors/track,26108cylinders

units=cylindersof16065*512=8225280bytes

Sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:0x00000000

Disk/dev/xvdd:214.7GBV214748364800bytes

255heads,63sectors/track,26108cylinders

units=cylindersof16065*512=8225280bytes

sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:0x00000000

Disk/dev/xvde:107.4GB,107374182400bytes

255heads,63sectors/track,13054cylinders

Units=cylindersof16065*512=8225280bytes

Sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:0x00000000

Sfdisk/dev/xvde

[root@iz23pbxddnmz?]#fdisk/dev/xvde

DevicecontainsneitheravalidDOSpartitiontabie,norsun,SGIorOSFdiskiabel

BuildinganewDOSdiskiabelwithdiskidentifier0x4c0436c3.

Changeswillremaininmemoryonly,unti1youdecidetowritethem.

Afterthat,ofcourse,thepreviouscontentwon*tberecoverable.

warning:invalidflagOxOOOOofpartitiontabie4willbecorrectedbyw(rite)

WARNING：DOS-compatiblemodeisdeprecated.It*sstronglyrecommendedto

switchoffthemode(command'c')andchangedisplayunitsto

sectors(commandru').

Command(mforhelp):n

commandaction

eextended

pprimaryparririon(1-4)

P

partitionnumber(1-4):1

Firstcyl1nder(1-13054,default1):

usingdefaultvalue1

Lastcylinder,+cylindersor+size{K,M,G1(1-13054,default13054):

Usingdefaulrvalue13054

command(mforhelp):wq

Thepartitiontabiehasbeenaltered!

Callingioctl()tore-readpartitiontable,

syncingdisks.

[root@iZ23pbxddnmz|

#fdisk-1

Disk/dev/xvde:107.4GB,107374182400bytes

255heads,63sectors/track,13054cylinders

Units=cylindersof16065*512=8225280bytes

sectorsize(logical/physical):512bytes/512bytes

I/Osize(minimum/optimal):512bytes/512bytes

Diskidentifier:Ox4cO436c3

Id

DeviceBoorstartEndBlocks83system

/dev/xvdel113054104856223+Linux

[root@iz23pbxddnmz?]#I

#4/dev/xvdel

格式化為exl3或者ext4

[root@iZ23pbxddnmz?]#mkfs.ext4/dev/xvdel

mke2fs1.41.12(17-May-2O1O)

Filesystemlabel=

ostype:Linux

Blocksize=4096(loq=2)

Fragmentsize=4096(log=2)

Stride=0blocks,Stripewidth=0blocks

6553600inodes,26214055blocks

1310702blocks(5.00%)reservedforthesuperuser

Firstdatablock=0

Maximumfilesystemblocks=4294967296

800blockgroups

32768blockspergroup,32768fragmentspergroup

8192inodespergroup

superblockbackupsstoredonblocks:

32768,98304,163840,229376,294912,819200,884736,1605632,2654208,

4096000,7962624,11239424,20480000,23887872

writinginodetables:done

Creatingjournal(32768blocks):done

writingsuperblocksandfilesystemaccountinginformation:done

Thisfilesystemwillbeautomaticallycheckedevery32mountsor

180days,whichevercomesfirst,usetune2fs-cor-itooverride.

[root@iz23pbxddnmz?]#I

使用"echo'/dev/xvdel/uOlext4defaults00'>>/etc/fstab”（不含引號(hào)）命

令寫入新分區(qū)信息。

然后使用“cat/etc/fstab”命令查看，出現(xiàn)以下信息就表示寫入成功。

#echo'/dev/xvdel/uOlext4defaults00'?/etc/fstab

；root@iz23pbxddnmz?]#echo'/dev/xvdel/mntext4defaults00*?/etc/fstab

；root@iz23pbxddnmzcat/etc/fstab

#

#/etc/fstab

#CreatedbyanacondaonThuAug1421:16:422014

#

#Accessiblefilesystems,byreference,aremaintainedunder'/dev/disk'

#seemanpagesfstab(5),findfs(8),mount(8)and/orblkid(8)formoreinfo

#

UUID=94e4e384-0ace-437f-bc96-057dd64f42ee/ext4defaults,barrier=011

tmpfs/dev/shmtmpfsdefaults00

devpts/dev/ptsdevptsid=5,mode=62000

sysrs/syssysfs3efaults00

proc/procprocdefaults00

none/proc/xenxenfsdefaults00

/dev/xvdel/mntext4defaults00

[root@iZ23pbxddnmz?]#I

創(chuàng)建磁盤掛載目錄:

ttmkdir/uOl

掛載磁盤:

mount-a

I[root@iz23pbxddnmz/]#df-h1

FilesystemSizeusedAvailuse%Mountedon

/dev/xvdal20G19G274M99%/

tmpfs32G8.OK32G1%/dev/shm

/dev/xvdel99G188M94G1%/uOl

配置SWAP,和內(nèi)存一樣大--16GB

#grepMemTotal/proc/meminfo

#ddif=/dev/zeroof=/u01/swapbs=1024Mcount=16

#/sbin/mkswap/uOl/swap

#/sbin/swapon/uOl/swap

#vi/etc/fstab

/uOl/swapswapswapdefaults00

free-m

[root@iz23pbxddnmz?]#free-m

totalusedfreesharedbufferscached

Mem:644113308531325039130491

-/+buffers/cache:220362208

swap：16383016383

2.設(shè)置共享內(nèi)存

Oracle的SGA+PGA內(nèi)存大小受限于linux的共享內(nèi)存大小，最佳實(shí)踐通常SGA+PGA設(shè)置為物理內(nèi)

存的60-70%,所以根據(jù)物理內(nèi)存的70%設(shè)定為64GB*0.7=45GB左右。

#df-h

cp/etc/fstab/etc/

vi/etc/fstab

mount-oremount/dev/shm

df-h

#

#/etc/fstab

CreatedbyanacondaonThuAug1421:16:422014

#

*Accessiblefilesystems,byreference,aremaintainedunder'/dev/disk,

Seemanpagesfstab(5),findfs(8),mount(8)and/orblkid(8)formoreinfo

UUlD=94e4e384-0ace-437f-bc96-057dd64f42ee/ext4defaults,barrier=O11

tmpfs/dev/shmtmpfsdefaults,size=45875M00

devpts/dev/ptsdevptsqid=5,mode=62000

sysfs/syssysfsdefaults00

proc/procprocdefaults00

none/proc/xenxenfsdefaults00

/dev/xvdel/uOlext4defaults00

一

u?---■一--r-ih--

rrotz23e#t

LOapbdhmou-oremount/dev/sh(n

也h

LrrOotz23pbde#

i1eu?1

Fsystzee1

/dev/xVd24G7Guse%Mountedon

tmpfs48oK45G13%

/de/d?1%/dev/shm

/VxV917G78G

rt.18%/uOl

Lroo@1z

3.設(shè)置臨時(shí)文件夾空間

要求大于1GB,高配置ECS缺省滿足條件

.?

[rtT

Fioos23pmzzedf-h

/d/ems2loGusedAvailuse%Mountedon

leal

tms45G9.8G8.8G53%/

zdev24G22G53%/dev/shm

99。

pf24G70G26%/uOl

ev

2.2.軟件環(huán)境檢查及配置

1.關(guān)閉防火墻

ECS缺省關(guān)閉可以忽略。

#sed-i〃s/SELINUX=enforcing/SELINUX=disabled/"/etc/seiinux/config

ttsetenforce0

2.安裝依賴包

確定操作系統(tǒng)版本：

#uname-r

2.6.32-431.233.el6.x86_64

在LinuxX86_64操作系統(tǒng)上Oracle需要以下軟件包：

binutils-2.20.51.0.2-5.11.el6(x86_64)

compat-libcapl-1.10-l(x86_64)

compat-1ibstdc++-33~3.2.6(x86_64)

compat-1ibstdc++-33-3.2.6.i686

gcc-4.4.6(x86_64)

gcc-c++-4.4.6(x86_64)

glibc-2.12-1.7.el6(i686)

glibc-2.12-1.7.el6(x86_64)

glibc-devel-2.12-1.7.el6(x86_64)

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.6(i686)

libgcc-4.4.6(x86_64)

libstdc++-4.4.6(x86_64)

libstdc++-4.4.6.i686

libstdc++-devel-4.4.6(x86_64)

1ibstdc++-devel_4.4.6.i686

libaio-0.3.6(x86_64)

libaio-0.3.6.1686

libaio-devel-0.3.6(x86_64)

libaio-devel-0.3.6.1686

make-3.6

sysstat-9.0.6(x86_64)

如果使用IL2.0.2以上版本，只需要除gcc-32bit-4.3以外的64位包，32位包不需要。

#rpm-qbinutilscompat-libcaplcompat-libstdc++gccgcc-c++glibcglibc-devel

kshlibgcclibstdc++libstdc++-devellibaiolibaio-develmakesysstatunixODBC*

根據(jù)需要安裝以下包：

#yuminstallcompat-libcapl*compat-libstdc++*glibc*libgcc*libstdc++*

libaio*elfutils-libelf*unixODBC*pdksh*ksh*glibc-devel.i686Iibstdc++.i686

Iibstdc++-devel.i686Iibaio.i686libaio-devel.i686

[root@iz23pbxddnmzhome]#rpm-qbinutilscompat-libcaplcompat-1ibstdc++gccgcc-c++glibcglibc-deve

1kshlibgcclibstdc++1ibstdc++-devellibaiolibaio-develmakesysstat

binutils-2.-5.36.el6.x86_64

compat-1ibcapl-1.10-1.x86_64

packagecompat-1ibstdc++isnotinstalled

gcc-4.4.7-11.el6.X86.64

gcc-c++-4.4.7-11.el6.x86__64

glibc-2.12-1.149.e!6.x86_64

glibc-2.12-l.149.el6.1686

glibc-devel-2.12-1.149.el6.x86_64

glibc-devel-2.12-1.149.el6.1686

ksh-20120801-21.e16.1.x86_64

libgcc-4.4.7-11.el6.x86_64

libgcc-4.4.7-11.el6.1686

libstdc++-4.4.7-11.el6.x86_64

1ibstdc++-4.4.7-11.el6.i686

1ibstdc++-devel-4.4.7-11.el6.x86_64

libstdc++-devel-4.4.7-11.el6.1686

libaio-0.3.107-10.el6.x86_64

libaio-0.3.107-10.el6.i686

11baio-devel-O.3.107-10.el6.x86_64

libaio-devel-O.3.107-10.el6.1686

make-3.81-20.el6.x86_64

sysstat-9.0.4-22.el6.x86_64

[root@iz23pbxddnmzhome]#|

3.禁止transparent_hugepage參數(shù)

ECS缺省關(guān)閉，可忽略

如需修改請(qǐng)?zhí)砑右韵聝?nèi)容到/etc/file:

transparent_hugepage=never

然后重啟系統(tǒng)

4.創(chuàng)建用戶及用戶組

#groupaddoinstall

#groupadddba

#useradd-goinstall-Gdbaoracle

#passwdoracle

#idoracle

將oracle用戶加入到sudo群組

#vi/etc/sudoers

找到rootALL=(ALL)ALL這行，并且在底下再加入oracleALL=(ALL)ALL

5.修改Oracle用戶資源限制

目前ECS缺省值為：

$ulimit-Sn

65535

$ulimit-Hn

65535

$ulimit-Su

1024

$ulimit-Hu

515130

$ulimit-Ss

10240

$ulimit-Hs

unlimited

修改#vi/etc/security/

oraclesoftnofile1024

oraclehardnofile65536

oraclesoftnproc2047

#oraclehardnproc16384

oraclesoftstack10240

oraclehardstack32768

#如果使用ASM

gridsoftnofile1024

gridhardnofile65536

gridsoftnproc2047

gridhardnproc16384

gridsoftstack10240

gridhardstack32768

6.編輯/etc/pam.d/login

#vi/etc/pam.d/login

添加以下兩行

sessionrequired/lib64/security/pam_

sessionrequiredpam_

7.配置系統(tǒng)內(nèi)核參數(shù)

#vim/etc/

fs.aio-max-nr=

fs.file-max=

1=

x=#一半物理內(nèi)存

i=4096

=25032000100128

4.ip_local_port_range=900065500

.rmem_default=262144

.rmem_max=

.wmem_default=262144

.wmem_max=

vm.hugetlb_shm_group=501

#oracle用戶組dbaid為501,以徹底解決ORA-27125錯(cuò)誤。

修改完成后執(zhí)行使之生效

itsysctl-p

8.修改/etc/profile

#vi/etc/profile

將以下代碼新增到profile檔案中

if[$USER="oracle"];then

if[$SHELL="/bin/ksh"];then

ulimit-p16384

ulimit-n65536

else

ulimit-u16384-n65536

fi

umask022

fi

9.oracle用戶環(huán)境變量配置

#suoracle

$vim.bash_profile

#添加下面內(nèi)容

exportORACLE_BASE=/uOl/app/oracle

exportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_l

exportORACLE_SID=orcl

exportPATH=$ORACLE_HOME/bin:$PATH

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

$source/home/oracle/.bash_profile

$env

10.創(chuàng)建安裝目錄并賦權(quán)

#mkdir-p/u01/app/orac1e

#chown-Roracle:oinstall/uOl

#chmod-R775/uOl

11.上傳Oracle軟件

3.安裝Gridinfrastructure

1.1.安裝ASMlib

1.2.創(chuàng)建grid用戶

#groupaddasmadmin

#groupaddasmdba

#groupaddasmoper

#useradd-d/home/grid-goinstall-Gasmadmin,asmdba,asmoper,dbagrid

#passwdgrid

#idgrid

添力Uasmdba給Oracle用戶

#usermod-goinstall-Gdba,asmdbaoracle

#idoracle

1.3.創(chuàng)建grid用戶安裝目錄并賦權(quán)

#mkdir-p/uOl/app/grid

#mkdir-p/u01/app/ll.2.O/grid

#chown-Rgrid:oinstall/uOl

#chown-Roracle:oinstall/uO1/app/orac1e

1.4.安裝ASMLib

#yuminstallkmod-oracleasm

#yuminstalloracleasmlib-2.0.6.x86_64.rpm

#yuminstalloracleasm-support-2.1.6.x86_64.rpm

linuxi72ipbxddnmZ?.6.32-431.?3.3.e16.x86_64*1SMPThuJul3117:2O:S1UTC2014x86_6dx86_64x86_64GNU,Linux

[root@iz23pbxddnmzoracle]#yuminstallkmod-oracleasm

Loadedplugins:refresh-packagekit,security

Repositorybaseislistedmorethanonceintheconfiguration

Repositoryupdatesislistedmorethanonceintheconfiguration

RepositoryextrasislistedmorethanonceinTheconfiguration

Repositorycentosplusislistedmorethanonceintheconfiguration

Repositorycontribislistedmorethanonceintheconfiguration

base

epel

epel/primary_db

extras

updates

SettingupinsxallProcess

ResolvingDependencies

-->Runningtransactioncheck

-->Packageknod-oracleastn.x86_640:2.0.8-4.el6_6willbeinstalled

-->ProcessingDependency:kernel(get_user_paqes_fast)=Oxa2046a95forpackage:knK)d-oracleasm-?.0.8-4.el6_6.x86_64

-->ProcessingDependency:kernel>-2.6.32-504.e16forpackage:kmod-oracleasm-2.0.8-4.el6_6.x86.64

-->Runningtransactioncheck

—>packagekernel.x86_640:2.6.32-504.3.3.el6willbeinstalled

一>ProcessingDependency:kernel-firmware>=2.6.32-504.3.3.el6forpackage:kernel-2.6.32-504.3.3.el6.x86_64

-->Runningtransactioncheck

—>Packagekernel-firmware.noarch0:2.6.32-431.23.3.el6wi11beupdated

—>Packagekernel-firnwrare.noarch0:2.6,32-504.3.3.el6willbeanupdate

-->FinishedDependencyResolution

DependenciesResolved

packageArchversionRepositorySize

installing:

kmod-oracleasmx86_642.0.8-4.el6_6updates

Installingfordependencies:

kernelx86_642.6.32-504.3.3.el6updates

updatingfordependencies:

kernel-firmwarenoarch2.6.32-504.3.3.el6updates

Transactionsunmary

install2Package(s)

Upgrade1package(s)

Totaldownloadsize:44M

ISthisok[y/N]:y

DownloadingPackages:

(1/3):kernel-2.6.32-504.3.3.el6.x86?64.rpm29MB00:02

(2/3J:kernel-firnwuare-2.6.32-504.3.3.el6.noarch.rpm14MB00:01

(3/3):knod-oracleasin-2.0.8-4.el6_6.x86_64.rpm35k800:00

Total9.4MB/S|44M8

Runningrpm_check,.debug

RunningTransactionTest

TransactionTestSucceeded

RunningTransaction

warning:RPMDBalteredoutsideofyum.

Updating:kernel-firmware-2.6.32-504.3.3.el6.noarch1/4

Installing:kernel-2.6.32-504.3.3.el6.x86_642/4

installIng:kmod-oracleasm-2.0.8-4.el6_6.x86_643/4

cleanup:kernel-firmware-2.6.32-431.23.3.el6.noarch4/4

unabletoconnecttodbus

verifying:kernel-firmware-2.6.32-504.3.3.e16.noarch1/4

verifying:kernel-2.6.32-504,3.3.el6.x86_642/4

verifying:kmod-oracleasm-2.0.8-4.el6_6.x86_643/4

verifying:kernel-f1rmware-2.6.32-431.23.3.el6.noarch4/4

Installed:

kmod-oracleasn.x86_640:2.0.8-4.el6_6

Dependencyinstalled:

kernel.x86_640:2.6.32-504.3.3.el6

Dependencyupdated:

kernel-firmware.noarch0:2.6.32-504.3.3.el6

complete!

[root0lz23pbxddnmzoracle]#I

設(shè)置ASM驅(qū)動(dòng)

#/usr/sbin/oracleasmconfigure-i

#使用oracle/dba或者grid/asmdba作為參數(shù)

#/etc/init.d/oracleasmenable

[root@iz23pbxddnmzoracle]#/usr/sbin/oracleasmconfigure-i

ConfiguringtheOracleASMlibrarydriver.

Thiswillconfiguretheon-bootpropertiesoftheoracleASMlibrary

driver.Thefollowingquestionswilldeterminewhetherthedriveris

loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues

willbeshowninbrackets('口').Hitting<ENTER>withouttypingan

answerwillkeepthatcurrentvalue.Ctr1-cwillabort.

Defaultusertoownthedriverinterface[]:grid

Defaultgrouptoownthedriverinterface[]:asmadmin

StartoracleASMlibrarydriveronboot(y/n)[n]:y

scanforOracleASMdisksonboot(y/n)[y]:y

writingoracleASMlibrarydriverconfiguration:done

[root@iZ23pbxddnmzoraclej#|

2.準(zhǔn)備ASM使用存儲(chǔ)

#fdisk/dev/xvdb

#/usr/sbin/orac1easmcreatediskDATA1/dev/xvdbl

Writingdiskheader:done

Instantiatingdisk:done

#/usr/sbin/oracleasmcreatediskDATA2/dev/xvdcl

Writingdiskheader:done

Instantiatingdisk:done

#/usr/sbin/orac1easmcreatediskDATA3/dev/xvddl

Writingdiskheader:done

Instantiatingdisk:done

#/etc/init.d/oracleasmena