Ungawafaka kanjani amathuluzi okuphatha ku-Oracle Database Express Edition?

I-Oracle Database Express Edition (I-Oracle XE) inguqulo yamahhala nelula ukuyifaka ye-Oracle Database, eyenzelwe onjiniyela nabafundi abafuna ukufunda nokuhlola i-Oracle. Enye yezinzuzo ze-Oracle XE yikhono layo lokusekela amathuluzi okuphatha, avumela abasebenzisi ukuphatha nokulawula database. Kulesi sihloko, sizofunda ukufaka kanjani Lawa mathuluzi okuphatha ku-Oracle Database Express Edition nokuthi zisetshenziswa kanjani ukuze kuthuthukiswe ukusebenza kwesizindalwazi.

1. Izimfuneko zokufaka amathuluzi okuphatha ku-Oracle Database Express Edition

Ngaphambi kokuthi uqale ukufaka amathuluzi okuphatha ku-Oracle Database Express Edition, kubalulekile ukuqinisekisa ukuthi uhlangabezana nezimfuneko ezithile. Okokuqala, kufanele ube nenguqulo esekelwe ye- uhlelo lokusebenza, njengeWindows, Linux, noma i-macOS. Ngaphezu kwalokho, kufanele ube nenguqulo ebuyekeziwe I-Oracle Database Express Edition, engalandwa mahhala ku- iwebhusayithi Isikhulu se-Oracle. Kubalulekile futhi ukuqinisekisa ukuthi unamalungelo adingekayo wokufaka nokuthi uyahlangabezana nezingxenyekazi zekhompuyutha nezidingo zesofthiwe ezisungulwe i-Oracle.

Uma izimfuneko sezifinyelelwe, ungaqhubeka nokufakwa kwamathuluzi okuphatha. I-Oracle inikezela ngamathuluzi ahlukahlukene asiza ukuphatha imininingwane egciniwe, njenge-Oracle SQL Developer kanye ne-Oracle Enterprise Manager Express. Lawa mathuluzi ahlinzeka ngesixhumi esibonakalayo esibonakalayo futhi akuvumela ukuthi wenze imisebenzi efana nokudala nokulungisa izinto zesizindalwazi, ukwenza imibuzo, nokunye.s I-SQL kanye nokuqapha ukusebenza kwesistimu.

Ukufaka lawa mathuluzi, kufanele ulande ifayela lokufaka elihambisanayo kuwebhusayithi ye-Oracle. Uma usulandiwe, ungaqhubeka nokufaka ulandela imiyalelo enikeziwe. Kubalulekile ukulandela isinyathelo ngasinye ngokucophelela futhi unikeze ulwazi oluceliwe, njengendawo yokufaka kanye nemininingwane yomqondisi wesizindalwazi. Ngemuva kokuthi ukufakwa sekuqediwe, ungafinyelela amathuluzi okuphatha kusukela kumenyu yokuqala noma ngokusebenzisa umyalo ohambisanayo kulayini womyalo.. Ngala mathuluzi afakiwe, uzokwazi ukuphatha kahle isizindalwazi se-Oracle Database Express Edition..

2. Landa futhi ufake i-Oracle Database Express Edition

Kulesi sihloko, sizochaza indlela yokulanda nokufaka i-Oracle Database Express Edition, inguqulo yamahhala, engasindi yesizindalwazi se-Oracle esidumile. I-Oracle Database Express Edition ilungele onjiniyela, izitshudeni, namabhizinisi amancane adinga isisombululo sesizindalwazi esinamandla kodwa esisebenziseka kalula.

Landa i-Oracle Database Express Edition

Ngaphambi kokuqala ukufakwa, kufanele ulande i-Oracle Database Express Edition kuwebhusayithi esemthethweni ye-Oracle. Ukuze wenze lokhu, yiya ekhasini lokulanda le-Oracle bese ubheka isigaba esihambisana nohlelo lwe-Oracle Database XE. Chofoza isixhumanisi sokulanda bese ukhetha uhlobo olufanele lwezidingo zakho. uhlelo lwakho lokusebenzaUma ukulanda sekuqediwe, qiniseka ukuthi unefayela lokufaka ekhompyutheni yakho futhi uqhubeke nenqubo yokufaka.

Ifaka i-Oracle Database Express Edition

Uma usulande i-Oracle Database Express Edition, isinyathelo esilandelayo ukuqala inqubo yokufaka. Vula ifayela lokufaka bese ulandela imiyalelo esesikrinini. Ngesikhathi sokufaka, uzocelwa ukuthi ukhethe ulimi lwakho nendawo yokufaka. Qiniseka ukuthi ukhetha izilungiselelo ezifanele futhi uqhubeke nokufaka.

Ngemva kokuqeda ukufaka, uzonikezwa ulwazi mayelana neseva yedathabhesi kanye nemininingwane yokungena. Qiniseka ukuthi ulondoloza lolu lwazi, njengoba uzoludinga ukuze ufinyelele futhi uphathe isizindalwazi sakho.

3. Ukucushwa Kwasekuqaleni kwe-Oracle Database Express Edition

La Kuyisinyathelo esibalulekile sokuqinisekisa ukusebenza kahle kwesizindalwazi. Kulesi sigaba, sizokukhombisa ukuthi uwafaka kanjani amathuluzi okuphatha adingekayo ukuze uphathe isizindalwazi sakho. ngendlela ephumelelayo.

Elinye lamathuluzi asetshenziswa kakhulu Unjiniyela we-Oracle SQL, indawo yokuthuthukisa ekuvumela ukuthi usebenzise Imibuzo ye-SQL futhi uphathe izinto zesizindalwazi. Ukuyifaka, mane ulande inguqulo ehambisana nohlelo lwakho lokusebenza kuwebhusayithi ye-Oracle bese ulandela imiyalelo yokufaka. Uma isifakiwe, uzokwazi ukuxhuma kusizindalwazi sakho bese uqala ukwenza imiyalo ye-SQL ngendlela enembile futhi kalula.

Elinye ithuluzi elibalulekile I-Oracle Enterprise Manager Express, isixhumi esibonakalayo sewebhu esikuvumela ukuthi uphathe futhi ugade isizindalwazi sakho kunoma yisiphi isiphequluli. Ukuze uyifinyelele, vele ufake i-URL enikeziwe ngesikhathi sokufakwa kwe-Oracle Express Edition. isiphequluli sakho sewebhu. Kusuka lapha, ungenza imisebenzi yokuphatha njengokudala abasebenzisi, ukulungisa ukuphepha, ukwenza amakhophi wokulondoloza futhi uqaphe ukusebenza kwesizindalwazi kalula futhi noma yikuphi.

4. Ukuhlonza Amathuluzi Okuphatha Alungile we-Oracle Database Express Edition

Ku-Oracle Database Express Edition (Oracle XE), kunamathuluzi amaningana okuphatha angenza ukuphatha nokuphatha imininingwane yakho egciniwe kube lula. Ukukhetha amathuluzi afanele Kubalulekile ukuqinisekisa ukusebenza kahle nokusebenza kwesistimu. Ngezansi ezinye izinketho ezinconyiwe:

1. Unjiniyela we-Oracle SQL: Kuyithuluzi lamahhala elinikezwe i-Oracle Corporation ukuze ixhumane nemininingwane ye-Oracle. Ikuvumela ukuthi usebenzise imibuzo, udale futhi uguqule izinto zesizindalwazi, usebenzise imibhalo ye-SQL, futhi uphathe abasebenzisi. Iphinde inikeze izici ezengeziwe ezifana nokulungisa iphutha kwekhodi ye-PL/SQL kanye nokwenza umbiko.

2. I-Oracle Application Express (APEX): Kuyinkundla yokuthuthukiswa kwesicelo sewebhu kanye nenkundla yokuthunyelwa ehlanganiswe ku-Oracle XE. Nge-APEX, kungenzeka dala izinhlelo zokusebenza gcwalisa izinhlelo zokusebenza zewebhu usebenzisa ubuchwepheshe obufana ne-SQL, PL/SQL, HTML, CSS, ne-JavaScript. Leli thuluzi linikeza isikhombimsebenzisi esisebenziseka kalula futhi likuvumela ukuthi uthuthukise izinhlelo zokusebenza ngokushesha ngaphandle kwesidingo solwazi oluthuthukisiwe lokuhlela.

3. I-Oracle Enterprise Manager Express (EM Express): Kuyisixhumi esibonakalayo esisekelwe kuwebhu esifakwe ne-Oracle XE futhi sinikeza indlela elula yokuphatha imininingwane yakho egciniwe. I-EM Express ikuvumela ukuthi wenze imisebenzi efana nokudala nokulungisa abasebenzisi, ukuphatha amatafula nezindawo zokugcina, nokuqapha ukusebenza kweseva. Iphinde inikeze amathuluzi okuxilonga ukukhomba izinkinga ezingaba khona kanye nokuthuthukisa ukusebenza kwesistimu.

Ngokukhetha amathuluzi alungile okuphatha i-Oracle Database Express Edition, ungaqinisekisa ukulawulwa kwesizindalwazi okusebenzayo nokuphumelelayo. Kubalulekile ukuhlola izidingo ezithile zendawo yakho futhi ucabangele izici ezinikezwa yithuluzi ngalinye. Kungakhathaliseki ukuthi usebenzisa i-Oracle SQL Developer, i-Oracle Application Express, noma i-Oracle Enterprise Manager Express, ungakwazi ukuthuthukisa ukusebenza futhi wandise amandla esizindalwazi sakho se-Oracle XE.

5. Ukufaka amathuluzi okuphatha usebenzisa i-Oracle SQL Developer

para faka amathuluzi okuphatha Ku-Oracle Database Express Edition, inketho ethandwayo ukusebenzisa Unjiniyela we-Oracle SQLLe softhiwe inikeza interface yomsebenzisi eyisithombe esikuvumela ukuthi uphathe kahle database. Kodwa-ke, ngaphambi kokuthi uqale ukufakwa, kubalulekile ukwenza isiqiniseko sokuthi unezidingo eziyisisekelo zesistimu, njenge uhlelo olusebenzayo isikhala sediski esihambisanayo nesanele.

Uma izidingo zesistimu seziqinisekisiwe, isinyathelo esilandelayo sithi landa i-Oracle SQL Developer kusuka kuwebhusayithi esemthethweni ye-Oracle. Kunconywa ukukhetha inguqulo yakamuva etholakalayo ukuze usebenzise ukuthuthukiswa kwakamuva nokulungiswa kweziphazamisi. Ngemva kokulanda, kufanele ukhiphe ifayela ifayela elicindezelwe endaweni efanele ohlelweni.

Uma ifayela selikhishiwe, kuyodingeka qala i-Oracle SQL Developer ngokusebenzisa ifayela le-sqldeveloper.exe. Lokhu kuzovula iwizadi yokusetha, ezoqondisa umsebenzisi enqubweni yokufaka. Ngesikhathi sokufakwa, umsebenzisi uzotshelwa ukuthi anikeze ngendawo ye-Java Development Kit (JDK), edingekayo ukuze kuqalise i-Oracle SQL Developer. Uma i-JDK ingafakiwe, ingalandwa futhi ifakwe kuwebhusayithi ye-Oracle.

6. Ukulungisa amathuluzi okuphatha ukuze kube lula ukuphatha i-Oracle Database Express Edition

I-Oracle Database Express Edition (Oracle XE) I-Oracle XE inguqulo yamahhala, engasindi yohlelo oludumile lokuphathwa kwesizindalwazi se-Oracle. Nakuba i-XE inikeza ingcebo yezici nokusebenza, ungase ukuthole kulula futhi kuwusizo kakhulu ukuphatha isizindalwazi sakho usebenzisa amathuluzi okuphatha azinikele. Kulesi sihloko, sizohlola ukuthi ungawafaka kanjani futhi uwalungise kanjani lawa mathuluzi ukuze uthole ukuphatha okuphumelelayo kwe-Oracle XE.

Ithuluzi lokuqala Unjiniyela we-Oracle SQL, ithuluzi elinamandla lesithombe elivumela umsebenzisi ukuthi ahlanganyele nesizindalwazi ngokubuka. Ukuyifaka, vele ulande iphakheji yokufaka kuwebhusayithi ye-Oracle bese usebenzisa ifayela le-.exe. Uma isifakiwe, ungamisa uxhumano lwesizindalwazi ngokunikeza igama lomethuleli, imbobo, igama lomsebenzisi, nephasiwedi. I-Oracle SQL Developer inikeza izici eziningi, ezifana nokwenziwa kombuzo we-SQL, idizayini ye-schema ebonakalayo, kanye nokuphathwa komsebenzisi nendima.

Elinye ithuluzi elibalulekile lokuphatha i-Oracle XE yi I-Oracle Enterprise Manager ExpressLeli thuluzi elisekelwe kuwebhu linikeza isikhombimsebenzisi esinembile sokuphatha nokuqapha isizindalwazi. Njengonjiniyela we-Oracle SQL, ukufaka i-Oracle Enterprise Manager Express kulula futhi kungenziwa kusetshenziswa iphakheji yokufaka elandwe kuwebhusayithi ye-Oracle. Uma selifakiwe, ithuluzi lingafinyelelwa ngesiphequluli sewebhu kusetshenziswa i-URL eshiwo ngesikhathi sokufakwa. Kusuka lapha, ungenza imisebenzi efana nokuphathwa kwendawo yetafula, ukuqapha ukusebenza, kanye nokuphathwa komsebenzisi kanye namalungelo.

Ngokufaka nokulungisa la mathuluzi okuphatha, abaphathi be-Oracle Database Express Edition bangenza lula futhi bahlele inqubo yokuphatha imininingwane egciniwe. Kokubili i-Oracle SQL Developer kanye ne-Oracle Enterprise Manager Express banikela ngezinhlobonhlobo zezici ezenza kube lula ukuphatha nokuqapha i-Oracle XE. indlela ephumelelayo futhi ngempumelelo. Ngamathuluzi afanele abanawo, abalawuli bangakhulisa amandla e-Oracle XE futhi basebenzise ngokugcwele le nguqulo yamahhala nenamandla yohlelo lokuphathwa kwesizindalwazi se-Oracle.

7. Ukusebenzisa amathuluzi okuphatha ukuze kuthuthukiswe ukusebenza kwe-Oracle Database Express Edition

Uma ufake i-Oracle Database Express Edition futhi ufuna ukuthuthukisa ukusebenza kwayo, kunconywa ukuthi usebenzise amathuluzi okuphatha athile. Kunezinketho ezimbalwa ezitholakalayo ezizokuvumela ukuthi ugade futhi uphathe imininingwane yakho egciniwe. Ngezansi amanye amathuluzi adumile ongase uthande ukuwacabangela:

I-RAT (Ukuhlolwa Kwesicelo Sangempela)Leli thuluzi likuvumela ukuthi uhlaziye futhi uqinisekise izinguquko kusizindalwazi sakho ngaphambi kokuzisebenzisa endaweni yokukhiqiza. Ungenza ukuhlolwa komthwalo nokucindezeleka ukuze uhlole umthelela wezinguquko futhi uvimbele izinkinga ezingaba khona. I-RAT iphinde inikeze amandla okwenza ukuhlola kokuhlehla nokuthwebula idatha yokukhiqiza ukuze isetshenziswe endaweni yokuhlola.

I-SQL Tuning AdvisorUma uhlangabezana nezinkinga zokusebenza ngemibuzo yakho ye-SQL, leli ithuluzi lakho. I-SQL Tuning Advisor ihlaziya ngokuzenzakalelayo ikhodi yakho ye-SQL futhi inikeze izincomo zokuthuthukisa ukusebenza. Ingaphakamisa izinguquko esakhiweni sombuzo, idale izinkomba ezengeziwe, noma isebenzise amaphrofayili wokwenza.

I-Oracle Enterprise Manager ExpressLeli thuluzi elisekelwe kuwebhu linikeza isixhumi esibonakalayo esinesithombe sokuphatha i-Oracle Database Express Edition. Ikuvumela ukuthi uqaphe futhi ushune ukusebenza kwesizindalwazi, ulungiselele ukuphepha, wenze izipele nokuthola kabusha, nokuningi. I-Oracle Enterprise Manager Express kulula ukuyisebenzisa futhi ilungele abaphathi besizindalwazi abakhetha isixhumi esibonakalayo sokuphatha imininingwane yabo yolwazi.

8. Izincomo ezibalulekile zokufaka amathuluzi okuphatha ku-Oracle Database Express Edition

Uma usebenzisa i-Oracle Database Express Edition (XE) futhi udinga ukufaka amathuluzi okuphatha engeziwe, nanka amanye awo: izincomo ezibalulekile ukwenza lolu hlelo ngempumelelo.

1. Hlola ukuhambisana: Ngaphambi kokufaka noma yiliphi ithuluzi lokuphatha ku-Oracle Database XE, kubalulekile ukuthi uqinisekise Compatibilidad ngalokhu kukhululwa. Qiniseka ukuthi ithuluzi liklanyelwe ngokuqondile ukusebenza ne-Oracle XE futhi liyahambisana nenguqulo oyisebenzisayo. Lokhu kuzogwema ukuhambisana nokungahambelani okungaba khona.

2. Landela imiyalelo yokufaka: Ithuluzi ngalinye lokuphatha lingase libe nezidingo ezithile kanye nezinqubo zokufaka. Funda ngokucophelela imiyalelo yokufaka enikezwe umkhiqizi wamathuluzi noma umthuthukisi kanye balandele encwadiniLokhu kuhlanganisa ukulungiselelwa kwangaphambili okudingekayo, njengokufaka okuncikile nokusetha izimvume zomsebenzisi. Ukweqa noma yiziphi izinyathelo kungase kubangele amaphutha noma ukungasebenzi kahle kwethuluzi.

3. Yenza izivivinyo nezipele: Ngaphambi kokusebenzisa ithuluzi lokuphatha ekukhiqizeni, kuhle ukwenza ukuhlola okubanzi endaweni yokuthuthuka noma yokuhlola. Lokhu kuzokuvumela ukuthi ubone izinkinga ezingaba khona futhi wenze izinguquko ngaphambi kokuzifaka ekukhiqizeni. Ngaphezu kwalokho, yenza ikhophi yasenqolobaneni kusizindalwazi sakho ngaphambi kokufaka noma yiliphi ithuluzi ukugwema ukulahleka kwedatha uma kwenzeka kuba nokwehluleka phakathi nenqubo yokufaka.