RedHatLinuxAS4Update5靜默安裝及升級Oracle10G10203

1、 19/19Red HHat EEnterrrisee Linnux4 Updaate5 環(huán)境下靜靜默方安裝裝Oraccle100.2.00.1升級級到10.2.0.3數(shù)據(jù)庫庫，并創(chuàng)建建數(shù)據(jù)庫Oraclle10GG安裝目錄TOC o 1-3 h z u HYPERLINK l _Toc272156044 一、檢查安安裝環(huán)境： PAGEREF _Toc272156044 h 3 HYPERLINK l _Toc272156045 二、靜默安安裝Oraacle110G數(shù)據(jù)據(jù)庫軟件 PAGEREF _Toc272156045 h 9 HYPERLINK l _Toc272156046 三、靜默安安裝

2、監(jiān)聽器器： PAGEREF _Toc272156046 h 10 HYPERLINK l _Toc272156047 四、靜默升升級Oraacle110G軟件件 PAGEREF _Toc272156047 h 11 HYPERLINK l _Toc272156048 五、靜默創(chuàng)創(chuàng)建Oraacle110G數(shù)據(jù)據(jù)庫 PAGEREF _Toc272156048 h 13 HYPERLINK l _Toc272156049 六、設置ooraclle服務自自啟動 PAGEREF _Toc272156049 h 16一、檢查安安裝環(huán)境：LinuxxAS4UUpdatte5在安裝時時，將所有有開發(fā)相關關的組

3、件全全部安裝；roottloccalhoost # rrpm -q biinutiils ccompaat-dbb conntroll-cennter gcc gcc-c+ glibbc gllibc-commmon ggnomee-libbs liibstddc+ libsstdc+-deevel makee pdkksh ssyssttat xxscreeensaaver libaaiobinuttils-2.155.92.0.2-22compaat-dbb-4.11.25-9contrrol-ccenteer-2.8.0-12.rrhel44.5gcc-33.4.66-8gcc-cc+-

4、33.4.66-8glibcc-2.33.4-22.36glibcc-commmon-2.3.4-2.36gnomee-libbs-1.4.1.2.900-44.1libsttdc+-3.44.6-88libsttdc+-devvel-33.4.66-8make-3.800-6.EEL4pdkshh-5.22.14-30.33packaage ssyssttat iis noot innstallledxscreeensaaver-4.188-5.rrhel44.13libaiio-0.3.1005-2roottloccalhoost #syssttat沒有有安裝，在在安裝盤44中的RRedH

5、aatRPPMS下找到syysstaat-5.0.5-14.rrhel44.i3886.rppm，上傳傳至LINNUX機器器并安裝roottloccalhoost # rrpm -Uvh syssstat-5.0.5-144.rheel4.ii386.rpm warniing: syssstat-5.0.5-144.rheel4.ii386.rpm: V3 DSA signnaturre: NNOKEYY, keey IDD db442a600ePrepaaringg. # 100% 1:syssstat # 100%roottloccalhoost #安裝后檢查查：roottloccalho

6、ost # rrpm -q syysstaatsyssttat-55.0.55-14.rhell4roottloccalhoost #安裝成功！判斷本機是是否安裝過過oraccle：roottloccalhoost # mmore /etcc/oraaInstt.locc/etc/oraIInst.loc: No suchh fille orr dirrectooryroottloccalhoost #表示沒有安安裝過orraclee創(chuàng)建安裝OOraclle需要的的用戶和組組：roottloccalhoost # ggrouppadd oinsstalllroottloccalhoost #

7、ggrouppadd dbaroottloccalhoost # uuseraadd -m -gg oinnstalll -GG dbaa oraacleroottloccalhoost #設置oraacle用用戶密碼，這這里設置為為“oraccle”roottloccalhoost # ppasswwd orracleeChangging passswordd forr useer orraclee.New UUNIX passswordd: BAD PPASSWWORD: it is bbasedd on a diictioonaryy worrdRetyppe neew UNNIX pp

8、asswword: passwwd: aall aautheenticcatioon tookenss upddatedd succcesssfullly.roottloccalhoost #創(chuàng)建安裝ooraclle所需的的目錄：roottloccalhoost # mmkdirr -p /u011/appp/oraacle/db_11roottloccalhoost # cchownn oraacle.oinsstalll /u001/appp/orracleeroottloccalhoost # cchownn oraacle.oinsstalll /u001/appp/orraclee/

9、db_1roottloccalhoost #配置Linnux系統(tǒng)統(tǒng)內核參數(shù)數(shù)：roottloccalhoost # vvi /eetc/ssyscttl.coonf修改或添加加以下參數(shù)數(shù)：kerneel.shhmalll = 220971152kerneel.shhmmaxx = 225600000000 kerneel.shhmmnii = 44096 kerneel.seem = 250 320000 1000 1228 fs.fiile-mmax = 655536 net.iipv4.ip_llocall_porrt_raange = 10024 6650000 net.ccore.rm

10、emm_deffaultt = 110485576 net.ccore.rmemm_maxx = 110485576 net.ccore.wmemm_deffaultt = 22621444 net.ccore.wmemm_maxx = 22621444注：一般而而言我們只只需要修改改kernnel.sshmmaax 這個個值，該參參數(shù)應該是是物理內存存的一半(字節(jié))編輯完之后后存盤退出出，然后運運行下列命命令重新加加載并驗證證參數(shù)是否否正確：roottloccalhoost # ssyscttl -ppnet.iipv4.ip_fforwaard = 0net.iipv4.conff.def

11、faultt.rp_filtter = 1net.iipv4.conff.deffaultt.acccept_sourrce_rroutee = 00kerneel.syysrq = 0kerneel.coore_uuses_pid = 1kerneel.shhmalll = 220971152kerneel.shhmmaxx = 225600000000kerneel.shhmmnii = 44096kerneel.seem = 250 320000 1000 1228fs.fiile-mmax = 655536net.iipv4.ip_llocall_porrt_raange = 1002

12、4 6650000net.ccore.rmemm_deffaultt = 110485576net.ccore.rmemm_maxx = 110485576net.ccore.wmemm_deffaultt = 22621444net.ccore.wmemm_maxx = 22621444roottloccalhoost #Oraclle建議對對每個Liinux賬賬戶可以使使用的進程程數(shù)和打開開的文件數(shù)數(shù)設置限制制（可選設設置）打開文件llimitts.coonf roottloccalhoost # vvi /eetc/ssecurrity/limiits.cconf加入以下參參數(shù)：* so

13、fft npproc 20477* harrd npproc 163884* sofft noofilee 10224* harrd noofilee 655536修改/ettc/paam.d/logiin文件roottloccalhoost # vvi /eetc/ppam.dd/loggin加入?yún)?shù)：sessiion rrequiired /libb/seccuritty/paam_liimitss.sosessiion rrequiired pam_limiits.ssoroottloccalhoost # vvi /eetc/sselinnux/cconfiig確保存在以以下內容：SE

14、LINNUX=ddisabbled配置oraacle 用戶的環(huán)環(huán)境變量roottloccalhoost # ssu - oraacleoracclellocallhostt $ vi .bassh_prrofille文件內容修修改為：# .baash_pprofiile# Gett thee aliiasess andd funnctioonsif -f /.baashrcc ; thenn . /.bashhrcfi# Useer sppeciffic eenvirronmeent aand sstarttup pprogrrams# Oraacle Enviironmmentexporrt

15、 ORRACLEE_BASSE=/uu01/aapp/ooraclleexporrt ORRACLEE_HOMME=$OORACLLE_BAASE/ddb_1exporrt ORRACLEE_SIDD=orcclexporrt ORRA_NLLS33=$ORAACLE_HOMEE/ocoommonn/nlss/admmin/ddataLD_LIIBRARRY_PAATH=$ORACCLE_HHOME/lib:/libb:/ussr/liibLD_LIIBRARRY_PAATH=$LD_LLIBRAARY_PPATH:/usrr/loccal/llibexporrt LDD_LIBBRARYY_

16、PATTHexporrt PAATH=$HOMEE/binn:$ORRACLEE_HOMME/biin:$PPATHexporrt NLLS_LAANG=AMERRICANN_AMEERICAA.ZHSS16GBBKexporrt PAATHunsett USEERNAMMEif $USEER = oraacle ; thennif $SHEELL = /bbin/kksh ; tthenulimiit -pp 163384ulimiit -nn 655536elseulimiit -uu 163384 -n 655536fifi到此，安裝裝Oraccle的準準備工作基基本完成，下下一步，可可

17、以選擇圖圖形界面安安裝或靜默默安裝方式式，這里使使用靜默安安裝方式：二、靜默安安裝Oraacle110G數(shù)據(jù)據(jù)庫軟件修改響應文文件：oracclellocallhostt dattabasse$ cd rrespoonse/oracclellocallhostt ressponsse$ vi eenterrprisse.rssp修改必要的的參數(shù)UNIX_GROUUP_NAAME=”oinsstalll”FROMM_LOCCATIOON= ./sttage/prodductss.xmllORAACLE_HOMEE= /u001/appp/orraclee/db_1ORRACLEE_HOMME_N

18、AAME=OraDDbHomme1RRESTAART_SSYSTEEM=faalseRRESTAART_RREMOTTE_SYYSTEMM=fallseORRACLEE_HOSSTNAMME=loocalhhostCOMPOONENTT_LANNGUAGGES=zh_CNs_naameFoorDBAAGrp=dbaan_cconfiiguraationnOptiion=33 回到Oraacle110G的安安裝程序目目錄，開始始安裝：oracclellocallhostt dattabasse$ ./ruunInsstalller -sileent -respponseeFilee /hoome

19、/ooraclle/daatabaase/rrespoonse/enteerpriise.rrsp安裝完成后后，執(zhí)行兩兩個腳本（使用rooot用戶戶）：#. $OORACLLE_BAASE/ooraInnventtory/oraiinstRRoot.sh#. $OORACLLE_HOOME/rroot.sh三、靜默安安裝監(jiān)聽器器：安裝網絡監(jiān)監(jiān)聽器沒有有網絡監(jiān)聽聽器，客戶戶端就無法法通過網絡絡連接Orralcee服務器。要在命令令行安裝網網絡監(jiān)聽器器，也只能能使用靜默默模式。編編輯Oraacle安安裝目錄里里respponsee子目錄下下的應答文文件 neetca.rsp，修修改以下項項目。IN

20、NSTALLL_TYYPE=cusstom 安裝裝的類型LLISTEENER_NUMBBER=11 監(jiān)聽器器數(shù)量LIISTENNER_NNAMESS=LLISTEENER 監(jiān)聽聽器的名稱稱列表LIISTENNER_PPROTOOCOLSS=TTCP;11521 監(jiān)聽聽器使用的的通訊協(xié)議議列表LIISTENNER_SSTARTT=LLISTEENER 監(jiān)聽聽器啟動的的名稱然后執(zhí)行：oracclellocallhostt ressponsse$ netcca /ssilennt /rrespoonseFFile /homme/orraclee/dattabasse/reesponnse/nnetc

21、aa.rspp四、靜默升升級Oraacle110G軟件件進入補丁包包安裝目錄錄# cd /rooot/Diisk1/respponsee修改響應文文件：paatchsset.rrspUNIX_GROUUP_NAAME=”oinsstalll”FROOM_LOOCATIION=./sstagee/prooductts.xmmlORRACLEE_HOMME=/u01/app/oraccle/ddb_1ORACLLE_HOOME_NNAME=OraaDbHoome1RESTAART_SSYSTEEM=faalseCOMPOONENTT_LANNGUAGGES=zh_CN修改后回到到補丁程序序目錄執(zhí)行

22、行：oracclellocallhostt ressponsse$ cd .oracclellocallhostt Dissk1$ ./rrunInnstalller -sillent -ressponsseFille /hhome/oraccle/DDisk11/ressponsse/paatchsset.rrsp安裝成功后后，會提示示： 1000% DDone.Setupp succcesssfulEnd oof innstalll phhasess.(Thhu Juun 044 18:47:005 CSST 20009)Startting to eexecuute cconfiigura

23、ationn asssistaantsoracclellocallhostt Dissk1$ Connfiguuratiion aassisstantt Onneofff Pattch AAppliicatiion succceedeed WARNIING:The ffolloowingg connfiguuratiion sscrippts nneed to bbe exxecutted aas thhe rroot useer.#!/biin/shh#Roott scrript to rrun/u01/app/oraccle/ddb_1/roott.shTo exxecutte thhe

24、coonfiggurattion scriipts: 11. Oppen aa terrminaal wiindoww 22. Loog inn as rooot 33. Ruun thhe sccripttsThe iinstaallattion of OOraclle Daatabaase 110g RReleaase 22 Pattch SSet 22 wass succcesssful.Pleasse chheck /u001/appp/orraclee/oraaInveentorry/loogs/ssilenntInsstalll20099-06-04_006-433-40PPM.l

25、oog ffor mmore detaails.使用rooot用戶登登錄，執(zhí)行行：/u001/appp/orraclee/db_1/rooot.sshroottloccalhoost ddb_1# ./roott.shRunniing OOraclle10 roott.sh scriiptThe ffolloowingg envvironnmentt varriablles aare sset aas: OORACLLE_OWWNER= oraacle OORACLLE_HOOME= /u001/appp/orraclee/db_1Enterr thee fulll paathnaame oo

26、f thhe loocal bin direectorry: /usrr/loccal/bbin: The ffile dbhhome alrreadyy exiists in /usr/locaal/biin. Overrwritte itt? (yy/n) n: y Coopyinng dbbhomee to /usrr/loccal/bbin The ffile oraaenv alrreadyy exiists in /usr/locaal/biin. Overrwritte itt? (yy/n) n: y Coopyinng orraenvv to /usrr/loccal/bbi

27、n The ffile corraenvv allreaddy exxistss in /usrr/loccal/bbin. Oveerwriite iit? (y/n) n: y Coopyinng cooraennv too /ussr/loocal/bin .Entriies wwill be aaddedd to the /etcc/oraatab filee as needded bbyDatabbase Conffigurratioon Asssisttant whenn a ddatabbase is ccreattedFinisshed runnning geneeric pa

28、rtt of roott.sh scriipt.Now pproduuct-sspeciific roott acttionss willl bee perrformmed.roottloccalhoost ddb_1#五、靜默創(chuàng)創(chuàng)建Oraacle110G數(shù)據(jù)據(jù)庫修改響應文文件編輯Oraacle安安裝目錄里里respponsee子目錄下下的應答文文件 dbbca.rrspOPERAATIONN_TYPPE = creeateDDatabbaseGDBNAAME = orrclSID = orrclSYSPAASSWOORD = syysSYSTEEMPASSSWORRD = sysstemCH

29、ARAACTERRSET = ZZHS166GBKTEMPLLATENNAME = /u01/app/oraccle/ddb_1/assiistannts/ddbca/tempplatees/Geeneraal_Puurposse.dbbcEMCONNFIGUURATIION = LOOCALSYSMAANPASSSWORRD = syssmanDBSNMMPPASSSWORRD = dbssnmp執(zhí)行：oracclellocallhostt ressponsse$ dbcaa -siilentt -reesponnseFiile /homee/oraacle/dataabasee/ressp

30、onsse/dbbca.rrspCopyiing ddatabbase filees1% coompleete3% coompleete11% ccompllete18% ccompllete26% ccompllete37% ccomplleteCreatting and starrtingg Oraacle insttancee40% ccompllete45% ccompllete50% ccompllete55% ccompllete56% ccompllete60% ccompllete62% ccomplleteComplletinng Daatabaase CCreattion6

31、6% ccompllete70% ccompllete73% ccompllete85% ccompllete96% ccompllete100% comppleteeLook at tthe llog ffile /u001/appp/orraclee/db_1/cffgtooolloggs/dbbca/oorcl/orcll.logg foor fuurtheer deetaills.oracclellocallhostt ressponsse$數(shù)據(jù)庫創(chuàng)建建成功后須須要注冊一一些信息，運運行$ORRACLEE_BASSE/orraInvventoory/oorainnstRooot.ssh

32、然后編編輯 /eetc/oorataab將:N修修改為:Y安裝完完成！啟動數(shù)據(jù)庫庫服務,ssys用戶戶登錄SQQLPLUUS：Sqlsstarttup啟動監(jiān)聽器器：oracclellocallhostt $lsnrrctl starrt啟動企業(yè)管管理器服務務oracclellocallhostt $emcttl sttart dbcoonsolle訪問地址為為： HYPERLINK htttp:/IP:11158/em/ htttp:/IP:11158/em/如果有多個個實例，則則從第二個個實例開始始，訪問的的端口依次次為55000、55501如需使用iiSQL*PLUSS，則啟動動相應服務務

33、oracclellocallhostt $isqllplussctl starrt訪問地址為為： HYPERLINK htttp:/IP:55560/isqllpluss htttp:/IP:55560/isqllpluss六、設置ooraclle服務自自啟動在oraccle用戶戶下修改文文件$ORRACLEE_HOMME/biin/dbbstarrt查找 ORRACLEE_HOMME_LIISTNEER=改為ORAACLE_HOMEE_LISSTNERR=$ORRACLEE_HOMME在roott用戶下編編輯文件# cd /etcc/rc.d/innit.dd/# vi orradb寫入如下

34、文文件內容：#!/biin/baash# chkkconffig: 345 99 110# desscripptionn: Sttartuup Sccriptt forr Oraacle Dataabasees# /ettc/rcc.d/iinit.d/dbbstarrtexporrt ORRACLEE_BASSE=/uu01/aapp/ooraclleexporrt ORRACLEE_HOMME=/uu01/aapp/ooraclle/dbb_1exporrt ORRACLEE_SIDD=orcclexporrt PAATH=$PATHH:$ORRACLEE_HOMME/biinORA_OOWNR=oraacle# if the execcutabbles do nnot eexistt - dispplay erroorif ! -ff $ORRACLEE_HOMME/biin/dbbstarrt -oo ! -d $OORACLLE_HOOME the