Oracle Instant Client

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)
   )
)

Kasulikud lisamaterjalid

• http://www.oracle.com/technology/software/tech/oci/instantclient/index.html