Ku-Windows. Hlola inani lokungena le-Inst_loc okuzoba indawo efakwe isofthiwe. Ungasebenzisa umyalo womyalo noma ungazulazula/uhlole uye endaweni yasekhaya ye-oracle bese u-cd to bin directory ukuze uvule i-sqlplus ezokunikeza ulwazi lwenguqulo yeklayenti.
Ngazi kanjani ukuthi iklayenti le-Oracle lifakiwe Windows 10?
Landela lezi zinyathelo:
- Kumenyu yokuqala, khetha Zonke Izinhlelo, bese kuba i-Oracle – HOMENAME, bese kuba Imikhiqizo Yokufaka i-Oracle, bese kuba Isifaki Sezinto Zonke.
- Ewindini Lokwamukela, chofoza Imikhiqizo Efakiwe ukuze ubonise ibhokisi lengxoxo le-Inventory.
- Ukuze uhlole okuqukethwe okufakiwe, thola umkhiqizo we-Oracle Database ohlwini.
Ngiyithola kanjani inguqulo yami ye-Oracle?
Ungahlola inguqulo ye-Oracle ngokusebenzisa umbuzo ovela kumyalo womyalo. Ulwazi lwenguqulo lugcinwe kuthebula elibizwa ngokuthi i-v$version. Kuleli thebula ungathola imininingwane yenguqulo ye-Oracle, PL/SQL, njll.
Ngazi kanjani uma i-Oracle isebenza ku-Windows?
Ihlola ukuthi i-Oracle Listener iyasebenza ku-Windows
- Vula iwindi lomyalo.
- Thayipha lsnrctl.
- Uzothola ukwaziswa kokufundwa kwe-LSNRCTL>
- Thayipha isimo.
- Uma ubona abalaleli be-xe* kokuthi READY database yakho iyasebenza futhi.
Ngazi kanjani ukuthi i-Oracle Instant Client ifakiwe?
Iya kuhlu lwemibhalo oluhlukile kunalolo ofake kulo Iklayenti Elisheshayo le-Oracle bese ufaka umyalo olandelayo: sqlplus scott@bigdb/tiger khetha umsebenzisi kokubili; Uma lokhu kuhlolwa kuphumelele, usukulungele ukusebenzisa isikhathi sokusebenza.
Ngiyithola kanjani indlela yeKlayenti le-Oracle kuWindows?
Chofoza u-Rt kuKhompyutha -> Izakhiwo -> Izilungiselelo zesistimu ezithuthukisiwe -> Ithebhu Ethuthukisiwe -> Okuguquguqukayo Kwendawo -> bese ubheka Indlela Yokukhetha Eziguquguqukayo Zesistimu ukuze ubone iklayenti le-Oracle HOME dir.
Ithini inguqulo yakamuva ye-Oracle?
Sethula Isizindalwazi se-Oracle 21c
Ukukhishwa kwakamuva Kwe-Innovation kwe-Oracle Database 21c, isizindalwazi esidume kakhulu emhlabeni, manje sekuyatholakala “ifu kuqala” ku-Oracle Cloud Database Service Virtual Machine (ye-RAC kanye nesenzakalo esisodwa) kanye ne-Bare Metal Service (isibonelo esisodwa).
Ingabe i-Oracle 19c iyafana ne-12c?
I-Oracle 19c empeleni iyi-Oracle 12c Ukukhishwa 2 (12.2. 0.3). Ngakho-ke, uma ucabangela ukuthunyelwa kwe-Oracle 12.2 Database, kufanele ucabangele ukuthuthukela ekukhishweni kwakamuva kwe-12.2, okuphumela ekubeni yi-Oracle 19c.
Yiziphi izinguqulo ze-Oracle?
Ukukhishwa nezinguqulo
| Inguqulo ye-Oracle Database | Inguqulo Yokukhishwa Yokuqala | Idethi ye-Patchset yetheminali |
|---|---|---|
| I-Oracle Database 10g Ukukhishwa okungu-2 | 10.2.0.1 | April 2010 |
| I-Oracle Database 11g Ukukhishwa okungu-1 | 11.1.0.6 | September 2008 |
| I-Oracle Database 11g Ukukhishwa okungu-2 | 11.2.0.1 | August 2013 |
| I-Oracle Database 12c Ukukhishwa 1 | 12.1.0.1 | July 2014 |
Iyiphi inguqulo ye-Oracle enginayo umugqa womyalo weWindows?
Indlela elula ukusebenzisa i-command prompt bese uthayipha i-sqlplus izokukhombisa inguqulo ye-oracle ngaphandle kokungena kuyo ngempela.
Ngixhuma kanjani kusizindalwazi se-Oracle?
Ixhuma ku-Oracle Database kusuka ku-SQL*Plus
- Uma ukusistimu ye-Windows, bonisa umyalo womyalo we-Windows.
- Emyalweni womyalo, thayipha sqlplus bese ucindezela ukhiye u-Enter. I-SQL*Plus iqala futhi ikutshele igama lakho lomsebenzisi.
- Thayipha igama lakho lomsebenzisi bese ucindezela u-Enter. …
- Thayipha iphasiwedi yakho bese ucindezela u-Enter.
Ngisihlola kanjani isimo sami se-Lsnrctl?
Ngingabheka Kanjani Ukuthi Umlaleli We-Oracle Uqalile
- Ngena ngemvume ku-SUSE Linux njenge-oracle yomsebenzisi.
- Ku-command line interface (CLI), sebenzisa umyalo olandelayo ukuze ubuke isimo somlaleli we-Oracle: > Isimo se-lsnrctl Igama lomlaleli.
Ngazi kanjani ukuthi iklayenti le-Oracle liyasebenza?
Khetha igama lesevisi yenethiwekhi noma isevisi yesizindalwazi. Khetha i-Command, bese ukhetha i-Test Net Service. Ukuhlola kuthatha ukuthi isilaleli kanye nesizindalwazi kuyasebenza. Uma zingenjalo, bheka okuthi “Ukuqala I-Oracle Net Listener kanye ne-Oracle Database Server” ukuze uqale izingxenye.
Ingabe i-Oracle Instant Client imahhala?
Amathuluzi amahhala, anesisindo esincane, futhi afakwe kalula e-Oracle Database, imitapo yolwazi nama-SDK. I-Oracle Instant Client inika amandla ukuthuthukiswa nokuphakelwa kwezinhlelo zokusebenza ezixhumeka kusizindalwazi se-Oracle, kungaba endaweni noma Kumafu.
Ngixhuma kanjani ku-Oracle Instant Client?
1 Ukuxhuma Iklayenti Elisheshayo noma Ukukhanya Kweklayenti Elisheshayo Kusizindalwazi Se-Oracle. Setha okuguquguqukayo kwemvelo ye-TNS_ADMIN ukuze ucacise indawo yama-tnsnames. ora bese usho igama lesevisi kulelo fayela. Setha i-TNS_ADMIN kanye TWO_TASK okuguquguqukayo kwemvelo ukuze ucacise igama lesevisi kuma-tnsnames.