Cov txheej txheem:

Kuv yuav import TNS cov ntaub ntawv rau hauv SQL Developer li cas?
Kuv yuav import TNS cov ntaub ntawv rau hauv SQL Developer li cas?

Video: Kuv yuav import TNS cov ntaub ntawv rau hauv SQL Developer li cas?

Video: Kuv yuav import TNS cov ntaub ntawv rau hauv SQL Developer li cas?
Video: Mus ua nyab rau yim hmoob tsis zoo 7/27/2017 2024, Kaum ib hlis
Anonim

SQL Developer

  1. Thaum hauv SQL Developer , xauj rau Cov cuab yeej, ces rau Kev nyiam.
  2. Tom qab ntawd nthuav cov Database tivthaiv, nyem rau Advanced, thiab hauv qab " Tns npe Directory", mus saib rau lub folder qhov twg koj tns npe . ora ua ntaub ntawv yog nyob. Thiab koj ua tiav! Tam sim no kev sib txuas tshiab lossis kev sib txuas tam sim no koj tuaj yeem txuas ntawm lub TNS npe kev xaiv.

Kuj nug, TNS yog dab tsi hauv SQL Developer?

Tns npe. ora [DOCS] yog cov ntaub ntawv teeb tsa rau SQL ntawv * Net uas piav qhia txog cov npe kev pabcuam network rau cov ntaub ntawv hauv koj lub koom haum. Yeej, nws qhia Oracle daim ntawv thov yuav ua li cas nrhiav koj cov databases. Daim ntawv tshaj tawm no tsuas yog ib qho kev nthuav dav sai ntawm yuav ua li cas kom tau SQL Developer kom 'pom' cov ntaub ntawv no thiab txhais qhov kev sib txuas.

Tsis tas li ntawd, qhov twg SQL Developer nrhiav Tnsnames Ora? SQL Developer nrhiav tnsnames . ora ua cov ntaub ntawv nyob rau hauv cov chaw hauv qab no: koj USER Home directory. $ORACLE_HOME etworkadmin - xav tias koj muaj tus neeg siv khoom nruab.

Kuj kom paub yog, SQL Developer puas siv Tnsnames Ora?

ora ua hauv Oracle SQL Developer . Koj muaj Oracle tus neeg siv software thiab a tns npe . ora ua cov ntaub ntawv twb ntsia ntawm koj lub tshuab, Oracle SQL Developer yuav cia li populate Connections navigator los ntawm net service names teev nyob rau hauv tns npe . ora ua.

Kuv yuav txuas mus rau SQL Developer li cas?

Configure Oracle SQL Developer Cloud Connection

  1. Khiav Oracle SQL Developer hauv zos. Oracle SQL Developer home page qhia.
  2. Nyob rau hauv kev sib txuas, txoj nyem Connections.
  3. Xaiv Kev Txuas Tshiab.
  4. Ntawm New/Select Database Connection Dialog, ua cov lus hauv qab no:
  5. Nyem Test.
  6. Nyem Txuas.
  7. Qhib qhov txuas tshiab.

Pom zoo: