Oracle XE Client: erinevus redaktsioonide vahel
Allikas: Kuutõrvaja
Mine navigeerimisribaleMine otsikasti
| (ei näidata sama kasutaja 2 vahepealset redaktsiooni) | |||
| 1. rida: | 1. rida: | ||
===Sissejuhatus=== | ===Sissejuhatus=== | ||
Oracle XE Client on olnud populaarne Oracle andmebaasi klient, 2010 aasta tingimustes on teda osaliselt hakanud asendama [[:Oracle Instant Client]]. | |||
===Tarkvara paigaldamine=== | ===Tarkvara paigaldamine=== | ||
http://www.oracle.com/technology/products/database/xe/index.html | |||
Tarkvara paigaldamiseks tuleb lisada /etc/apt/sources.list faili rida | |||
deb http://oss.oracle.com/debian unstable main non-free | |||
ja öelda | |||
# wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add - | |||
# apt-get update | |||
# apt-get install oracle-xe-client | # apt-get install oracle-xe-client | ||
===Tarkvara kasutamine=== | ===Tarkvara kasutamine=== | ||
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/sqlplus | Tarkvara kasutamiseks on abiks sobiva sisuga tnsnames.ora fail, nt | ||
# cat /etc/oracle/tnsnames.ora | |||
LOOM= | |||
(DESCRIPTION = | |||
(ADDRESS_LIST = | |||
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) | |||
) | |||
(CONNECT_DATA = | |||
(SERVICE_NAME = LOOMAAED) | |||
) | |||
) | |||
ja seejärel öelda | |||
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/sqlplus kasutajanimi/parool@LOOM | |||
===Kasulikud lisamaterjalid=== | ===Kasulikud lisamaterjalid=== | ||
* http://www.oracle.com/technology/products/database/xe/index.html | * http://www.oracle.com/technology/products/database/xe/index.html | ||
Viimane redaktsioon: 12. mai 2010, kell 13:16
Sissejuhatus
Oracle XE Client on olnud populaarne Oracle andmebaasi klient, 2010 aasta tingimustes on teda osaliselt hakanud asendama Oracle Instant Client.
Tarkvara paigaldamine
http://www.oracle.com/technology/products/database/xe/index.html
Tarkvara paigaldamiseks tuleb lisada /etc/apt/sources.list faili rida
deb http://oss.oracle.com/debian unstable main non-free
ja öelda
# wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add - # apt-get update # apt-get install oracle-xe-client
Tarkvara kasutamine
Tarkvara kasutamiseks on abiks sobiva sisuga tnsnames.ora fail, nt
# cat /etc/oracle/tnsnames.ora
LOOM=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LOOMAAED)
)
)
ja seejärel öelda
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/sqlplus kasutajanimi/parool@LOOM
