Oracle XE Client

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

Kasulikud lisamaterjalid

• http://www.oracle.com/technology/products/database/xe/index.html