Erinevus lehekülje "Oracle Instant Client" redaktsioonide vahel
Allikas: Kuutõrvaja
(→Kasutamine) |
(→Kasutamine) |
||
| 2. rida: | 2. rida: | ||
TODO | TODO | ||
| + | |||
| + | ===Tarkvara paigaldamine=== | ||
| + | |||
| + | Kopeerida aadressilt http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxx86_64soft.html sobiva andmebaasi versiooni jaoks failid, nt | ||
| + | |||
| + | * Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications | ||
| + | * Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client | ||
===Kasutamine=== | ===Kasutamine=== | ||
Redaktsioon: 24. märts 2010, kell 15:00
Sissejuhatus
TODO
Tarkvara paigaldamine
Kopeerida aadressilt http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxx86_64soft.html sobiva andmebaasi versiooni jaoks failid, nt
- Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
- Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
Kasutamine
Otseselt käsureal näidates kõik ühenduse parameetrid
$ LD_LIBRARY_PATH=. ./sqlplus loom/parool@10.0.192.64:1521/loomdb.loomaaed ... SQL>
tnsnames.ora faili abil
$ xport TNS_ADMIN=/opt/oic $ LD_LIBRARY_PATH=. ./sqlplus loom/parool@loomdb ... SQL>
kus tnsnamed.ora sisaldab nt
loomdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = loomdb.loomaaed)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = loomdb.loomaaed)
)
)
