1、Oracle數(shù)據(jù)庫(kù)日常管理_項(xiàng)目現(xiàn)場(chǎng)篇修改：2010/2/8A. 查看所有的實(shí)例及其后臺(tái)進(jìn)程是否正常確認(rèn)所有的的insstannce工工作正常常，登陸陸到所有有的數(shù)據(jù)據(jù)庫(kù)或iinsttancce上，檢檢測(cè)orraclle后臺(tái)臺(tái)進(jìn)程GDDB44-/eexpoort/homme/ooraccle ennv | grrep SIDDORACLLE_SSID=UWNNMS33GDDB44-/eexpoort/homme/ooraccle pss -eef|ggrepp UWWNMSS3 | grrep -v greep | grrep oraa oraaclee 2551199 11 00 Junn

2、244 ? 0:04 oraa_dbbw4_UWNNMS33 oraaclee 2551100 11 00 Junn 244 ? 3:20 oraa_dbbw1_UWNNMS33 oraaclee 2551466 11 00 Junn 244 ? 0:00 oraa_reeco_UWNNMS33 oraaclee 2551255 11 00 Junn 244 ? 0:09 oraa_dbbw5_UWNNMS33 oraaclee 2551422 11 00 Junn 244 ? 5:41 oraa_smmon_UWNNMS33 oraaclee 2551555 11 00 Junn 244 ?

3、 1:17 oraa_mmmon_UWNNMS33 oraaclee 2551522 11 00 Junn 244 ? 1011:322 orra_ccjq00_UWWNMSS3 oraaclee 2551022 11 00 Junn 244 ? 0:02 oraa_mmman_UWNNMS33 oraaclee 2551088 11 00 Junn 244 ? 7:37 oraa_dbbw0_UWNNMS33 oraaclee 2554788 11 00 Junn 244 ? 0:45 oraa_arrc1_UWNNMS33 oraaclee 2554700 11 00 Junn 244 ?

4、 0:47 oraa_arrc0_UWNNMS33 oraaclee 2551599 11 00 Junn 244 ? 84:02 oraa_mmmnl_UWNNMS33 oraaclee 2550944 11 00 Junn 244 ? 17:30 oraa_pmmon_UWNNMS33 oraaclee 2551177 11 00 Junn 244 ? 0:41 oraa_dbbw3_UWNNMS33 oraaclee 2551311 11 00 Junn 244 ? 13:12 oraa_lggwr_UWNNMS33 oraaclee 2001755 11 00 188:277:255

5、? 0:00 oraa_j0000_UWNNMS33 oraaclee 2551000 11 00 Junn 244 ? 1:10 oraa_pssp0_UWNNMS33 oraaclee 2551133 11 00 Junn 244 ? 0:14 oraa_dbbw2_UWNNMS33 oraaclee 2551355 11 00 Junn 244 ? 23:50 oraa_ckkpt_UWNNMS33B檢查文文件系統(tǒng)統(tǒng)的使用用情況如果文件系系統(tǒng)的剩剩余空間間小于110，則則需要?jiǎng)h刪除不必必要的文文件以釋釋放空間間。GDDB44-/eexpoort/homme/ooraccle dff -h

6、hFilessysttem sizze ussed avvaill caapaccityy MMounntedd onn/dev/md/dskk/d00 200G 117G 33.1GG 855% /procc 00K 0K 0KK 00% /proocmnttaab 00K 0K 0KK 00% /etcc/mnnttaabfd 00K 0K 0KK 00% /devv/fddswap 855G 1992K 85GG 11% /varr/ruundmpfss 855G 0K 85GG 00% /devv/vxx/dmmpdmpfss 855G 0K 85GG 00% /devv/vxx/rd

7、dmpswap 855G 2113M 85G 11% /tmpp/dev/vx/dskk/daata110dgg/Orra_FFilee_Vool011 3944G 2992G 98GG 755% /datta055/dev/vx/dskk/daata11dg/volla01131 4433G 1556G 2283GG 366% /arcchivveloog注意：需要要特別關(guān)關(guān)注根目目錄，數(shù)數(shù)據(jù)庫(kù)軟軟件和數(shù)數(shù)據(jù)庫(kù)備備份所在在目錄的剩剩余空間間情況！備注：數(shù)據(jù)據(jù)庫(kù)運(yùn)行行日志的的及時(shí)清清除1). 可可清除bbdummp,ccdummp,uudummp下的的相關(guān)日日志$ cd bduump$ ls

8、-ltotall 1774-rwxrrwxrrwx 11 orraclle dbba 590047 Jull 300 222:022 allertt_UWWNMSS1.llog-rwxrrwxrrwx 11 orraclle dbba 10000 Jull 144 222:000 uwwnmss1_jj0000_1881288.trrc-rw-rr- 1 oraaclee dbaa 10000 JJul 22 22:00 uwnnms11_j0001_53669.ttrc-rwxrrwxrrwx 11 orraclle dbba 6695 Jull 144 199:122 uwwnmss1_l

9、lgwrr_1881000.trrc-rwxrrwxrrwx 11 orraclle dbba 26668 Jull 300 222:022 uwwnmss1_llgwrr_1996611.trrc-rwxrrwxrrwx 11 orraclle dbba 9983 Jull 144 177:366 uwwnmss1_llgwrr_78816.trcc-rwxrrwxrrwx 11 orraclle dbba 9955 Jull 144 199:111 uwwnmss1_llgwrr_78883.trcc-rwxrrwxrrwx 11 orraclle dbba 8803 Jull 144 1

10、77:311 uwwnmss1_pp0000_77714.trcc-rwxrrwxrrwx 11 orraclle dbba 8801 Jull 144 177:311 uwwnmss1_pp0011_77716.trcc$ cp /deev/nnulll allertt_UWWNMSS1.llog$ rm *.ttrc$ cd ./cduump$ ls -ltotall 4drwxrr-x- 22 orraclle dbba 5512 Jull 255 144:122 coore_180095drwxrr-x- 22 orraclle dbba 5512 Jull 255 199:177 c

11、oore_259934$ cd ./uduump$ ls -ltotall 2000422-rw-rr- 11 orraclle dbba 5505 Jull 166 166:333 uwwnmss1_oora_147771.trcc-rw-rr- 11 orraclle dbba 455161169 Jull 255 144:122 uwwnmss1_oora_180095.trcc-rwxrrwxrrwx 11 orraclle dbba 6644 Jull 144 199:122 uwwnmss1_oora_181119.trcc-rw-rr- 11 orraclle dbba 5505

12、 Jull 300 155:111 uwwnmss1_oora_188820.trcc-rwxrrwxrrwx 11 orraclle dbba 7774 Jull 155 100:233 uwwnmss1_oora_195573.trcc-rwxrrwxrrwx 11 orraclle dbba 5587 Jull 155 100:233 uwwnmss1_oora_196645.trcc-rwxrrwxrrwx 11 orraclle dbba 6644 Jull 155 100:233 uwwnmss1_oora_196680.trcc-rw-rr- 11 orraclle dbba 7

13、7209942 Jull 155 166:288 uwwnmss1_oora_247759.trcc-rw-rr- 11 orraclle dbba 499515562 Jull 255 199:177 uwwnmss1_oora_259934.trcc-rw-rr- 11 orraclle dbba 5505 Jull 155 177:211 uwwnmss1_oora_273326.trcc-rw-rr- 11 orraclle dbba 5503 Jull 300 166:544 uwwnmss1_oora_66112.ttrc-rwxrrwxrrwx 11 orraclle dbba

14、5585 Jull 144 177:122 uwwnmss1_oora_75223.ttrc-rwxrrwxrrwx 11 orraclle dbba 7767 Jull 144 177:300 uwwnmss1_oora_75666.ttrc2). 可可清除ooraccle的的監(jiān)聽(tīng)日日志$ cd $ORRACLLE_HHOMEE/neetwoork/logg$ ls -ltotall 53330772-rwxrrwxrrwx 11 oraaclee dbaa 272250778511 Juul 331 111:228 llistteneer.llog-rw-rr-rr- 1 oraaclee

15、 dbaa 25578776 JJul 31 08:48 sqllnett.loog$ cp /deev/nnulll liisteenerr.loogC查找警警告日志志文件1. 聯(lián)接接每一個(gè)個(gè)操作管管理系統(tǒng)統(tǒng)2. 使用用TEELNEET或或是可比比較程序序3. 對(duì)每每一個(gè)管管理實(shí)例例，經(jīng)常常的執(zhí)行行$ORRACLLE_BBASEE/bddumpp 操作作，并使使其能回回退到控控制數(shù)據(jù)據(jù)庫(kù)的SSID。4. 在提提示下，使使用UNNIX 中的TAIIL命命令查看看aleert_.logg，或是是用其他他方式檢檢查文件件中最近近時(shí)期的的警告日日志5. 如果果發(fā)現(xiàn)任何何ORAA_ERRRORRS (

16、ORRA-XXXX) 的錯(cuò)誤誤，將它它記錄并并且仔細(xì)細(xì)的研究究它們，或反饋給DB組如何確定警警告日志志文件的的路徑？ 通過(guò)參看起起始參數(shù)數(shù)文件 iniit.orra，而而起始參參數(shù)文件件一般存存儲(chǔ)在$ORAACLEE_HOOME/dbss下$ cd $ORRACLLE_HHOMEE/dbbs$ catt innitUUWNMMS1.oraa*.bacckgrrounnd_ddumpp_deest=/oopt/oraaclee/prroduuct/10gg/addminn/UWWNMSS1/bbdummp*.corre_ddumpp_deest=/oopt/oraaclee/prroduuct/

17、10gg/addminn/UWWNMSS1/ccdummp*.useer_ddumpp_deest=/oopt/oraaclee/prroduuct/10gg/addminn/UWWNMSS1/uudummpD檢查數(shù)數(shù)據(jù)庫(kù)備備份是否否成功對(duì)RMAAN備份份方式:檢查第三方方備份工工具的備備份日志志以確定定備份是是否成功功如果具備恢恢復(fù)目錄錄的，可可直接登陸陸到rmman環(huán)環(huán)境下，發(fā)發(fā)命令llistt baackuup查看看具體備備份集合合的情況況； GDDB44-/ rmman tarrgett=syys/xxxxuwnnms33 caatallog=rmaan/rrmannuwwnmss3R

18、ecovveryy Maanagger: Reeleaase 10.2.00.3.0 - Prroduuctiion on Thuu Juul 331 111:339:337 220088Copyrrighht (c) 19882, 20005, Oraaclee. Alll riightts rreseerveed.conneecteed tto ttargget dattabaase: UWWNMSS3 (DBIID=22229978554411)conneecteed tto rrecooverry ccataalogg daatabbaseeRMAN liist bacckupp; L

19、ist of Bacckupp Seets=BS Keey Typpe LLV SSizee Deevicce TTypee Ellapssed Timme CCompplettionn Tiime - - - - - - -4226224 Inccr 00 112.559M DIISK 000:000:077 220088-077-288 033:155:211 BP Keyy: 44226631 SStattus: AVVAILLABLLE Commpreesseed: YESS TTag: BKK0 Pieece Namme: /exxporrt/hhomee/orraclle/rrma

20、nn3/bbk0_UWNNMS33_20008007288_23393 Lisst oof DDataafilles in bacckupp seet 44226624 Fille LLV TTypee Ckkp SSCN Ckpp Tiime NNamee - - - - - - 2 00 IIncrr 35532110966 20008-007-228 003:115:114 /arcchivveloog/ooraddataa/UWWNMSS3/uundoo01.dbff 5 00 IIncrr 35532110966 20008-007-228 003:115:114 /arcchivv

21、eloog/ooraddataa/UWWNMSS3/ssysttem22.dbbf對(duì)EXPPORTT，EXXPDPP邏輯備份份方式:檢查expp，exxpdpp日志文文件以確確定備份份是否成成功對(duì)其他備備份方式式:檢查相應(yīng)的的日志文文件E檢查表表空間的的使用情情況1. 檢查查在表空空間中有有沒(méi)有剩剩余空間間。對(duì)每一個(gè)實(shí)實(shí)例來(lái)說(shuō)說(shuō)，檢查查在表空空間中是是否存在在有剩余余空間來(lái)來(lái)滿足當(dāng)當(dāng)天的預(yù)預(yù)期的需需要。當(dāng)當(dāng)數(shù)據(jù)庫(kù)庫(kù)中已有有的數(shù)據(jù)據(jù)是穩(wěn)定定的，數(shù)數(shù)據(jù)日增增長(zhǎng)的平平均數(shù)也也是可以以計(jì)算出出來(lái)，最最小的剩剩余空間間至少要要能滿足足每天數(shù)數(shù)據(jù)的增增長(zhǎng)。腳本：selecct tt.taableespaa

22、ce_namme, tottal, frree, rooundd(1000*(1-(freee/ttotaal),3)|% as已使使用的空空間比例例from (seelecct ttabllesppacee_naame, suum(bbytees)/10224/110244 tootall frrom dbaa_daata_filles grooup by ttabllesppacee_naame) t,(seelecct ttabllesppacee_naame, suum(bbytees)/10224/110244 frree froom ddba_freee_sspacce ggrou

23、up by ttabllesppacee_naame) f wheree t.tabblesspacce_nnamee=f.tabblesspacce_nnamee(+)andd t.tabblesspacce_nnamee noot in (DRRSYSS,ORDDIM,SSPATTIALL,USEERS,TTOOLLS,XDDB)orderr by rrounnd(1100*(1-(frree/tottal),33) ddescc;2. 識(shí)別別出表空空間下一一些過(guò)分分的對(duì)象象空間增增長(zhǎng)查看數(shù)據(jù)庫(kù)庫(kù)中超出出資源或或是增長(zhǎng)長(zhǎng)速度過(guò)過(guò)大的段段，具體體分析看看是否需需要調(diào)整整。selecct oo

24、wneer,ssegmmentt_naame,parrtittionn_naame,byttes/10224/110244 frrom dbaa_seegmeentss whheree taableespaace_namme = NNRMTTBS orrderr by bbytees ddescc根據(jù)實(shí)際情情況，先先清除臨臨時(shí)無(wú)用用的數(shù)據(jù)據(jù)庫(kù)對(duì)象象；或回回收部分分頻繁ddml操操作的庫(kù)庫(kù)表空間間Oraclle 110g下下的一些些處理：- 庫(kù)表表：alterr tabble prddb.MMLOGG$_FFACTT_AGGG2BBSC_BASSE_PPI mmovee注意：moove后后建立于

25、于數(shù)據(jù)庫(kù)庫(kù)對(duì)象上上的索引引會(huì)失效效，記住住一定要要重新編編譯！/* - 以下下腳本用用于檢查查失效的的索引selecct * frrom dbaa_inndexxes wheere staatuss noot in (VAALIDD,N/AA)SELECCT iindeex_nnamee,PAARTIITIOON_NNAMEE,TAABLEESPAACE_NAMME FFROMM USSER_INDD_PAARTIITIOONS WHEERE staatuss = UNNUSAABLEE OORDEER BY PPARTTITIION_NAMME;*/- 索引引：alterr inddex N

26、PMMDB.UQ_TPAA_SAAE_SSUM rebbuilld tabblesspacce iidxddbs onliine nollogggingg paaralllell 4 ;alterr inddex NPPMDBB.UQQ_TPPA_SSAE_SUMM nooparralllel;3. 表空空間管理理- 創(chuàng)建建表空間間CREATTE ttabllesppacee appmdbbs1 ddataafille /ddev/vx/rdssk/ddataa1dgg/voola001011 ssizee 40095MM exxtennt mmanaagemmentt loocall see

27、gmeent spaace mannageemennt aautoo;注： 添加加裸設(shè)備備上的數(shù)數(shù)據(jù)文件件請(qǐng)注意意路徑/dev/rdssk/cc0t00d0ss0 裸設(shè)備備/dev/dskk/c00t0dd0s00 塊設(shè)備備它們鏈接的的是同一一塊物理理設(shè)備，具具體區(qū)別別是在訪訪問(wèn)方式式上。裸設(shè)備是假假設(shè)硬盤(pán)盤(pán)上沒(méi)有有文件系系統(tǒng)時(shí)的的訪問(wèn)方方式。裸裸設(shè)備是是按順序序訪問(wèn)，塊塊設(shè)備是是按文件件系統(tǒng)和和i節(jié)點(diǎn)“隨機(jī)”訪問(wèn)。二二者的使使用場(chǎng)合合也不同同。在做做newwfs之之前，因因?yàn)闆](méi)有有文件系系統(tǒng)，只只能訪問(wèn)問(wèn)裸設(shè)備備；做了了newwfs，進(jìn)進(jìn)行掛接接時(shí)，因因?yàn)樾枰L問(wèn)磁磁盤(pán)上的的文件系系統(tǒng)，所

28、所以只能能用塊設(shè)設(shè)備- 增加加數(shù)據(jù)文文件，擴(kuò)擴(kuò)充表空空間ALTERR TAABLEESPAACE PRTTBS119 AADD DATTAFIILE /ddev/vx/rdssk/ddataa2dgg/voolb000822 SSIZEE 40095MM AUUTOEEXTEEND OFFF;ASM下：Uwnmss1：alterr tabblesspacce NRMMTBSS addd dattafiile +DDISKKGROOUP11 siize 81992M auttoexxtennd offfUwnmss2：alterr tabblesspacce PPRTBBS aadd datta

29、fiile +DDISKKGROOUP22 sizze 81992M auttoexxtennd offf- 增加加臨時(shí)文文件，擴(kuò)擴(kuò)充臨時(shí)時(shí)表空間間ALTERR taableespaace TEMMP AADD temmpfiile /ddev/vx/rdssk/ddataa2dgg/teemp002 sizze 440955M rreusse;- 數(shù)據(jù)據(jù)文件收收縮，針針對(duì)文件件系統(tǒng)上上的數(shù)據(jù)據(jù)文件alterr daatabbasee daataffilee $HOMME/DDATAA/DIISK55/daata002.ddbf reesizze 115000k;ASM下：Selecct fi

30、lle_nnamee,taableespaace_namme,bbytees/110244/10224|M,allterr daatabbasee daataffilee |fille_nnamee| ressizee 2225288M; from dbaa_daata_filles wheere tabblesspacce_nnamee = IIDXDDBS alterr dattabaase dattafiile +DDISKKGROOUP22/uwwnmss2/ddataafille/nnpmddbs.5322.699428874447 ressizee 153360MM;F檢查數(shù)數(shù)據(jù)文

31、件件的狀態(tài)態(tài)檢查數(shù)據(jù)文文件的狀狀態(tài)記錄錄狀態(tài)不不是“oonliine”的數(shù)據(jù)文件，并及時(shí)聯(lián)系DB組跟進(jìn)。SQL sett liinessizee 2000SQL sett paagessizee 2000SQL Sellectt fiile_namme ffromm dbba_ddataa_fiiless whheree sttatuus=OFFFLINNE;no roows sellecttedG檢查數(shù)數(shù)據(jù)庫(kù)會(huì)會(huì)話分?jǐn)?shù)據(jù)庫(kù)用用戶統(tǒng)計(jì)計(jì)數(shù)據(jù)庫(kù)庫(kù)會(huì)話的的情況：selecct sscheemannamee,coountt(1) frrom v$ssesssionn grroupp by ssche

32、emannamee分?jǐn)?shù)據(jù)庫(kù)用用戶，模模塊統(tǒng)計(jì)計(jì)數(shù)據(jù)庫(kù)庫(kù)會(huì)話的的情況：selecct sscheemannamee,prrogrram,couunt(1) froom vv$seessiion wheere schhemaanamme SYSS ggrouup by sscheemannamee,prrogrram殺掉異常的的會(huì)話或或會(huì)話對(duì)對(duì)應(yīng)的進(jìn)進(jìn)程：（以具具有DBBA權(quán)限限的用戶戶來(lái)清除除會(huì)話）selecct ssid,serriall# ffromm v$sesssioon wheere sidd = $siidselecct spiid froom v$pproccesss whhere

33、e adddr in ( seelecct ppadddr ffromm v$sesssioon wwherre ssid = $sidd )alterr syysteem kkilll seessiion ,如果執(zhí)行上上述命令令后，仍仍然沒(méi)有有能及時(shí)時(shí)釋放會(huì)會(huì)話，可可直接殺殺掉會(huì)話話對(duì)應(yīng)的的服務(wù)器器進(jìn)程kill -9 H檢查數(shù)數(shù)據(jù)庫(kù)主主機(jī)的性性能情況況檢查數(shù)據(jù)庫(kù)庫(kù)所在主主機(jī)的性能，記記錄數(shù)據(jù)據(jù)庫(kù)的ccpu使使用、IIO、buffferr命中率率等等，使用vmmstaat,iiosttat,topp等命令令Vmstaat: 關(guān)注ccpu的的idlleIostaat：關(guān)關(guān)注磁盤(pán)盤(pán)IO的的繁忙程程

34、度(%b)Top: 關(guān)注消消耗cppu多的的相關(guān)進(jìn)進(jìn)程O(píng)raclle 110g EM監(jiān)監(jiān)控：I. 數(shù)據(jù)據(jù)庫(kù)的正正常啟動(dòng)動(dòng)與關(guān)閉閉- 關(guān)閉閉步驟：1停止監(jiān)監(jiān)聽(tīng)GDDB44-/eexpoort/homme/ooraccle lssnrcctl stoop2停止實(shí)實(shí)例使用sqll*pllus工工具，以以具有DDBA權(quán)權(quán)限的數(shù)數(shù)據(jù)庫(kù)用用戶登陸陸到具體體實(shí)例上上操作GDDB44-/eexpoort/homme/ooraccle seetennv OORACCLE_SIDD UWWNMSS3 GDDB44-/eexpoort/homme/ooraccle sqqlpllus /noologg SQL*PP

35、luss: RReleeasee 100.2.0.33.0 - PProdducttionn onn Thhu JJul 31 15:06:23 20008Copyrrighht (c) 19882, 20006, Oraaclee. Alll Riightts RReseerveed.SQL connn ssys/xxxxxxxx ass syysdbbaConneecteed.SQL shuutdoown immmediiatee3. 檢查查實(shí)例相相關(guān)進(jìn)程程GDDB44-/eexpoort/homme/ooraccle pss -eef|ggrepp UWWNMSS3 oraaclee 2

36、551199 11 00 Junn 244 ? 0:04 oraa_dbbw4_UWNNMS33 oraaclee 2551100 11 00 Junn 244 ? 3:23 oraa_dbbw1_UWNNMS33 oraaclee 2551466 11 00 Junn 244 ? 0:00 oraa_reeco_UWNNMS33 oraaclee 2551255 11 00 Junn 244 ? 0:09 oraa_dbbw5_UWNNMS33 oraaclee 2551422 11 00 Junn 244 ? 5:49 oraa_smmon_UWNNMS33 oraaclee 255155

37、5 11 00 Junn 244 ? 1:19 oraa_mmmon_UWNNMS33 oraaclee 2551522 11 00 Junn 244 ? 1033:588 orra_ccjq00_UWWNMSS3 oraaclee 2551022 11 00 Junn 244 ? 0:02 oraa_mmman_UWNNMS33 oraaclee 2551088 11 00 Junn 244 ? 7:49 oraa_dbbw0_UWNNMS33 oraaclee 2554788 11 00 Junn 244 ? 0:46 oraa_arrc1_UWNNMS33 oraaclee 255470

38、0 11 00 Junn 244 ? 0:49 oraa_arrc0_UWNNMS33 oraaclee 777700 11 00 155:066:422 ? 0:00 oraa_j0000_UWNNMS33 oraaclee 2551599 11 00 Junn 244 ? 86:03 oraa_mmmnl_UWNNMS33 oraaclee 2550944 11 00 Junn 244 ? 17:55 oraa_pmmon_UWNNMS33 oraaclee 2551177 11 00 Junn 244 ? 0:42 oraa_dbbw3_UWNNMS33 oraaclee 2551311

39、 11 00 Junn 244 ? 13:32 oraa_lggwr_UWNNMS33 oraaclee 2551000 11 00 Junn 244 ? 1:11 oraa_pssp0_UWNNMS33 oraaclee 2551133 11 00 Junn 244 ? 0:15 oraa_dbbw2_UWNNMS33 oraaclee 2551355 11 00 Junn 244 ? 24:23 oraa_ckkpt_UWNNMS33 oraaclee 1886733 11 00 Junn 111 ? 47:45 oraacleeUWNNMS33 (LLOCAAL=NNO) oraacle

40、e 1442999 11 00 155:000:066 ? 0:00 oraacleeUWNNMS33 (LLOCAAL=NNO) oraaclee 2883911 11 00 111:233:555 ? 0:12 oraacleeUWNNMS33 (LLOCAAL=NNO) oraaclee 1000044 11 11 155:088:022 ? 0:17 oraacleeUWNNMS33 (LLOCAAL=NNO)緊急情況下下，可手手工直接接殺掉帶帶LOCCAL標(biāo)標(biāo)識(shí)的進(jìn)進(jìn)程，加加快數(shù)據(jù)據(jù)庫(kù)的關(guān)關(guān)閉操作作；但ooraccle的的相關(guān)后后臺(tái)進(jìn)程程請(qǐng)不要要隨便KKILLL掉。- 啟動(dòng)動(dòng)步驟：1

41、啟動(dòng)實(shí)實(shí)例使用sqll*pllus工工具，以以具有DDBA權(quán)權(quán)限的數(shù)數(shù)據(jù)庫(kù)用用戶登陸陸到具體體實(shí)例上上操作GDDB44-/eexpoort/homme/ooraccle seetennv OORACCLE_SIDD UWWNMSS3 GDDB44-/eexpoort/homme/ooraccle sqqlpllus /noologg SQL*PPluss: RReleeasee 100.2.0.33.0 - PProdducttionn onn Thhu JJul 31 15:06:23 20008Copyrrighht (c) 19882, 20006, Oraaclee. Alll Rii

42、ghtts RReseerveed.SQL connn ssys/xxxxxxxx ass syysdbbaConneecteed.SQL staartuup2啟動(dòng)監(jiān)監(jiān)聽(tīng)GDDB44-/eexpoort/homme/ooraccle lssnrcctl staart3. 檢查查實(shí)例相相關(guān)進(jìn)程程GDDB44-/eexpoort/homme/ooraccle pss -eef|ggrepp UWWNMSS3 oraaclee 2551199 11 00 Junn 244 ? 0:04 oraa_dbbw4_UWNNMS33 oraaclee 2551100 11 00 Junn 244 ? 3:23 oraa_dbbw1_UWNNMS33 oraaclee 2551466 11 00 Junn 244 ? 0:00 oraa_reeco_UWNNMS33 oraaclee 2551255 11 00 Junn 244 ? 0:09 oraa_dbbw5_UWNNMS33 oraaclee 2551422 11 00 Junn 244 ? 5:49 oraa_smmon_UWNNMS33 oraaclee 25515