RHEL6(x86_x64)安裝oracle11gr2案例

1、RHEL 6 (x86_x64) 安裝 oracle 11g r2-編寫整理作者 :藍(lán)創(chuàng)星空希望本文能給你提供一點(diǎn)點(diǎn)的幫助 ,如果有問題，你可以在我的百度空間留言，地址： 我在RHEL6 64位上安裝。使用 GNOME圖形界面，安裝的時(shí)候把 Development Tools里 的開發(fā)包都安裝上，或者快速安裝后搭建本地 yum 源再利用群組安裝也可。值得注意的是 swap要求至少3G,我的機(jī)器為2G物理內(nèi)存。安裝過程分為兩步，一是修改系統(tǒng)參數(shù)，二是軟件及數(shù)據(jù)庫安裝。修改系統(tǒng)參數(shù)step1: vi /etc/sysctl.conf,添加如下參數(shù)：fs.aio-max-nr = 1048576fs

2、.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 1073741824kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.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保存并使之生效/sbin/sysctl -p

3、如果有如下提示錯(cuò)誤，忽略，因?yàn)榧词刮葱薷膮?shù)也提示有這個(gè)錯(cuò)誤 error： "net.bridge.bridge-nf-call-ip6tables" is an unknown key error： "net.bridge.bridge-nf-call-iptables" is an unknown key error： "net.bridge.bridge-nf-call-arptables" is an unknown key注意：kernel.shmmax's的值是物理內(nèi)存的一半。我的是2G內(nèi)存，所以是10737418

4、24step2: vi /etc/security/limits.co nf,添力卩oraclesoftnproc 2047oraclehardnproc 16384oraclesoftnofile 1024oraclehardnofile 65536step3: vi /etc/pam.d/login添加參數(shù)： session required pam_limits.sostep4:vi /etc/profile:if $USER = "oracle" ; thenif $SHELL = "/bin/ksh" ; then ulimit -p 1638

5、4 ulimit -n 65536elseulimit -u 16384 -n 65536fifi step4: vi /etc/csh.login: if( $USER = "oracle" ) then limit maxproc 16384 limit descriptors 65536 umask 022endif step5: vi /etc/redhat-release修改為如下值，成功安裝數(shù)據(jù)庫后在修改回來 Red Hat Enterprise Linux Server release 5.0 (Tikanga) step6:添加相關(guān)用戶及用戶組：/usr/s

6、bin/groupadd oinstall/usr/sbin/groupadd dba/usr/sbin/useradd -m -g oinstall -G dba oracleecho "oracle"|passwd -stdin oracle (我比較懶，管道命令修改 oracle密碼)Step 6: 創(chuàng)建安裝路徑及修改權(quán)限 :mkdir -p /opt/11g/oraclechown -R oracle:oinstall /opt/11g/oracle chmod -R 775 /opt/11g/oraclemkdir -p /opt/11g/oraInventory

7、chown -R oracle:oinstall /opt/11g/oraInventory chmod -R 775 /opt/11g/oraInventoryStep 7: vi /home/oracle/.bash_profile,其中 ORACLE_SID 的值可以自己定，我的設(shè)為 orciTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/opt/11g/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export

8、ORACLE_HOMEORACLE_SID=orcl; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if $USER = &

9、quot;oracle" ; thenif $SHELL = "/bin/ksh" ; then ulimit -p 16384 ulimit -n 65536elseulimit -u 16384 -n 65536fifi umask 022使環(huán)境變量生效：source /.bash_profilestep 8:切換到oracle解壓11G的安裝包，這樣就不用再修改權(quán)限了step 9:重啟后以oracle登錄安裝。以下是安裝過程oraclelocalhost database$ ./runInstaller Starting Oracle Universal I

10、nstaller.Checking Temp space: must be greater than 120 MB. Actual 8288 MB PassedChecking swap space: must be greater than 150 MB. Actual 4095 MB PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/

11、OraInstall2011-04-28_07-44-59AM.Please wait .oraclelocalhost database$ You can find the log of this install session at: /opt/11g/oraInventory/logs/installActions2011-04-28_07-44-59AM.log 出現(xiàn)圖形界面后選擇默認(rèn)即可。當(dāng)檢查依賴包是可能會(huì)出現(xiàn)如下下提示w conTiQtis Security jpoai w InsioJlatmOionkj Ty p ir§j in Il io n； f' Sf

12、fliC IflMEHlflEfp iPiRsrcqiaisilE <Jieck>丫 Sumfflar/7 InslaI ProdL4ctIU FlHK-hSon* f of the n InIm urn requlftrneffiS for InjtallailOr are nol COm pitied. Review and fix tile issues listed in ih» folloijvngr&ll k.na r*ch«ck th* cyfc«fflS,hcck. Again| Show Failed Ignored IITh

13、 I ? is aprenqusirte cDncunomto tesi dretrierthe package "unixdOfsc-z ZJl'1 araitabit on ire system, meira cktaj 卻Expcdcd ViIjc : unlxODeC- 2.2.11(iB8£)晶 diuAHWLi ffiisfiingHelp< |a匚k.CanceHelpNext >CancelHelpNext >Cancel我查看了這些包，都安裝了，只是版本比較新，可能是這個(gè)原因?qū)е碌摹：雎运^續(xù)安裝即 可。下圖為安裝ORACLE軟件

14、：Oracle Database llg Release 2 Installer Installiny database - Step 8 of 9Install PruduictORACU6'aJItion Orn Ci aspikal Inreaie In-reInsloll IVoductProgriiffI丁紙Settino ud 'Oracle DataLife ! 1J. 'n Si ai U ic* Prepare Copv files» Lnlt binariesSue匚1-|亍門 Suzceedltd Slirceedled S

15、utteedledHelpNext >CancelPc ding rendunaConCdllEla EdCompres-s ControlCaicci0rac i亡 Omb5e rorifirationExec utt Root Sc r pis for OraLClc Database install anonHelpNext >CancelHelpNext >Cancel創(chuàng)建數(shù)據(jù)庫:HelpNext >Cancelnoracle Database llg Release 2 installer installing database - step 8 of 9平

16、Typical InrH Create Invtp Fr(requi$iiQ' Kstdll I¥o2 FinishIdeal Platform forGrid ComputinaLow cost ond storogoHighest ovailobilHyBest scehbilrtY# Copying Udiatxse riles匚eat ng and starting Oracle instanceConipltling Det abase Cr<fd：iunClone daiabdie creailon In prugrES5Log Tiles ror (he

17、current cperanon are locaied at: /op(/llg/oraclQ/cfgtoollogs/dbca/orcljcceecedicceeced jcceeded progress jcceftded Progress indingGrid Computing.(stop)ite on Fast.RMbble, and ScalableLow-Cost GridsOracle Database llg Release 2 installer installing database - Step 8 of 9Install Pro dietORZKCLeCir ccl

18、Oracle Database llg Release 2 installer - installing database step a of 9Install ProducDatabase Configuration AssistantsironfiDatabase creation complete. Fcr details check tne logfiles at: /opt/llc/orade/cfotoollcas/doca/ordnsralktiDn:vaerr Clj Typica) In歹ii*n m& Install PtoDatabase Informal cn:

19、Global Database Name: System dentifierCJID): 5e wr Fdia n-ter File narne.orciorci /opt/llg/orade/product/11.2. C/db ome.ldbs/spfieorcL ora|ThA Databasp Comrol URI is hrnsV/loralhnst 1158/pmManagement Keposrory has Deen placed n secrm rroae wreren Enterprise Manaqer caia wi | be en:n/pted. The encryp

20、t on key has bear 卩l(xiāng)aced in the fila:/opt/1 lgoracie/produci/11.2 O/dbhome.L/localhosi.ord/sysman/configjemkey oraPlea;e ensure this file i« backed up the encrpied data Mil become unusable if this f ie if lost.Note: AJl database azcourxs except SYS,STEM, D3SNMP, and SYSMaK are locked. Seled the

21、 Password Maiagement buton to view a ccmple e list of locked ec匚ountj or to manage the database accounts (except D8SMMP and SfSMAN) From ihe Passv/ord Manacement wndovi； unlock enythe accounts ou wi I use. Grade Corporation strongb/ recctvme*ids changing the default oas$v<o'os immed ateiy alt

22、er unlocking the accountFassword Managemem.Xd Lcceeded Ljccedf d jcceeaea ucceeded i Progress ucceeded i Progress 2nd ng)to,aad Scalable加【GkbHelpNext >Cancel可以在上面解鎖一些帳號(hào)和修改密碼，點(diǎn)擊上面的 0K后，出現(xiàn)如下:切換到root，命令完成最后安裝。oraclelocalhost $ su -Password:rootlocalhost 11g# sh /opt/11g/oral nven tory/orai nstRoot.s

23、h Changing permissi ons of /opt/11g/ora Inven tory.Addi ng read,write permissi ons for group.Removing read,write,execute permissions for world.Changing group name of /opt/11g/ora Inven tory to oin stall.The executi on of the script is complete.rootlocalhost 11g# sh /opt/11g/oracle/product/11.2.0/dbh

24、ome_1/root.sh Running Oracle 11g root.sh script.The follow ing en vir onment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /opt/11g/oracle/product/11.2.0/dbhome_1En ter the full path name of the local bin directory: /usr/local/b in:Copy ing dbhome to /usr/local/b in Copy ing orae nv to /usr/

25、local/b in Copy ing corae nv to /usr/local/b in .Creat ing /etc/oratab file.En tries will be added to the /etc/oratab file as n eeded byHelpNext >CancelrifnMiThe i h At q.1 -al icvri uf Oil -3. _ le L -aX abjucle j U>LNote.登陸OEM瀏覽器查看:https NH QCIh'St 1 lS/rrm.itGirirsoIc.lDgo* 卜坯 | Oracle

26、tntt*rp*1seORdZLJE CmtirirprlM MAhOf Or 11 gCnnirol* U&W憶®裾CWWOt AgDatabase Con figuratio n Assista nt whe n a database is created Fini shed running gen eric part of root.sh script.Now product-specific root actions will be performed.Fini shed product-specific root acti ons.rootlocalhost 11g

27、#附：如果曾經(jīng)安裝過得話，提示框會(huì)和上面不太一樣，只要你 sh /opt/11g/oral nven tory/orai nstRoot.sh!卩可。EnierEr"i£ Mridger p峯誣電$毛匚pnirQii URL - CQrcl> . hnp&si： 1DtkWDtkWZoFTigi-E c2COS, Dracte XU r>ql-c re-aeri.' J- I 1rt !“ 仁 si. I|n j h . M R -i- r r1r|r-.r. f,| >r-| .pWk- Stl I. - 1!> !, . -f &

28、gt; t| qi|L> F t -ji'i Ffh' ': ：I«-W I IFIirU -1：8 從-> I jifF F >T £ *II.-1f'*"、DTiMhari 邁M 4KH3| dHCihUHDtkWD X注意，此時(shí)數(shù)據(jù)庫并沒有設(shè)置為隨機(jī)啟動(dòng)，在windows下是以服務(wù)方式隨機(jī)啟動(dòng)的。手動(dòng)方式如下：啟動(dòng)監(jiān)聽程序：Isn rctl start啟動(dòng) OEM： emctl start dbconsole附：下面是一些你可能用的到的東西。1使用系統(tǒng)鏡像，搭建本地yum源，即使以后能用上CentOS 6.0

29、（不知道還要等多久！），我覺得還是優(yōu)先用系統(tǒng)鏡像。rootlocalhost #m ount -o loop rhel-server-6.0-x86_64-dvd.iso /mediarootlocalhost #vi /etc/yum.repos.d/localyum.repo輸入如下：basen ame=localyumbaseurl=file:/media/Serveren abled=1gpgcheck=1 gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release 保存退出。刷新yum緩存，我比較喜歡刷新兩次。rootlocalho

30、st # yum makecacheLoaded plug ins: refresh-packagekitbase| 3.7 kB 00:00 .base/filelists_db| 3.6 MB 00:00 .base/primary_db| 2.9 MB 00:00 .base/other_db| 1.3 MB 00:00 .base/group_gz| 191 kB00:00 .Metadata Cache Createdrootlocalhost # yum makecacheLoaded plug ins: refresh-packagekitbase| 3.7 kB 00:00 .

31、Metadata Cache Created看一下成功與否：rootlocalhost #yum in stall httpd群組安裝功能，很方便！rootlocalhost #yum group in stall“ Developme nt Tools ”還有圖形界面也很方便：系統(tǒng)”-管理”-添加/刪除軟件”看到下面這個(gè)界面，是不是想起了安裝系統(tǒng)時(shí)選擇軟件包的界面呢？D XBi&e SysternServersuwb services.樂匕幫助凹 Mfl13 s=6兒I訕處*System ManagementVirtualizationDesktopsApflLdtlDrib Deve'opnieTtEelip«»/Bab#l language pack For Hebreweel ipse-nls-tiS.O.vJO 040620