Oracle Instant Client

Sissejuhatus

TODO

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