Cov txheej txheem:

Kuv yuav paub li cas yog Oracle khiav ntawm Windows?
Kuv yuav paub li cas yog Oracle khiav ntawm Windows?

Video: Kuv yuav paub li cas yog Oracle khiav ntawm Windows?

Video: Kuv yuav paub li cas yog Oracle khiav ntawm Windows?
Video: 3.1-VERB Introduction- Hais qhia ua lus hmoob 2024, Kaum ib hlis
Anonim

Tshawb xyuas yog Oracle Listener khiav ntawm Windows

  1. Qhib cov lus txib qhov rai .
  2. Ntaus lsnrctl.
  3. Koj yuav tau txais ib tsab ntawv nyeem LSNRCTL>
  4. Hom xwm txheej.
  5. Yog koj saib cov xe* mloog hauv READY koj cov ntaub ntawv tau nce thiab khiav .

Ib yam li ntawd, kuv tuaj yeem qhia tau li cas yog Oracle khiav?

Tshawb xyuas Database Instance Status

  1. Nkag mus rau hauv lub database server raws li tus neeg siv oracle (Oracle 11g server installation user).
  2. Khiav lub sqlplus "/as sysdba" hais kom txuas mus rau lub database.
  3. Khiav qhov xaiv INSTANCE_NAME, STATUS los ntawm v$ piv txwv; hais kom kuaj xyuas cov xwm txheej ntawm cov xwm txheej database.

Kuj Paub, Kuv yuav pib Oracle tus neeg siv khoom ntawm Windows li cas? Txhawm rau pib Oracle Database cov kev pabcuam los ntawm Oracle Administration Assistant rau Windows:

  1. Los ntawm Start menu, xaiv Programs, ces xaiv Oracle - HOME_NAME, ces xaiv Configuration thiab Migration Tools thiab ces xaiv Administration Assistant rau Windows.
  2. Right-click SID.
  3. Nyem Start Service.

Ib yam li ntawd ib tug yuav nug, dab tsi version ntawm Oracle kuv muaj Windows?

Hauv Qhov rai . Tshawb xyuas Inst_loc nkag tus nqi uas yuav yog qhov chaw nruab software. Koj tuaj yeem siv cov lus hais kom ua lossis koj tuaj yeem taw qhia / tshawb xyuas rau oracle qhov chaw hauv tsev thiab tom qab ntawd cd rau hauv phau ntawv teev npe rau lauch sqlplus uas yuav muab rau koj tus neeg siv khoom version cov ntaub ntawv.

Yuav ua li cas koj xyuas seb database yog nce los yog tsis?

Xyuas seb qhov piv txwv zoo li cas thiab cov ntaub ntawv tuaj yeem nkag mus

  1. Xyuas seb qhov txheej txheem Oracle khiav lossis tsis #> ps -ef | pom grep.
  2. Txheeb xyuas qhov xwm txheej xwm txheej SQL> xaiv instance_name, xwm txheej los ntawm v$ piv txwv;
  3. Xyuas seb lub database puas tuaj yeem nyeem lossis sau SQL> xaiv lub npe, qhib_mode los ntawm v$database;

Pom zoo: