INSTALASI ORACLE INSTANTCLIENT LINUX

1. Download terlebih
   dahulu 3 buah file yaitu

• instantclient-basic-linux32-10.2.0.3-20061115.zip

• instantclient-sdk-linux32-10.2.0.3-20061115.zip

• instantclient-sqlplus-linux32-10.2.0.3-20061115.zip

2. Esktrak ke 3 file
   tersebut ke dalam folder /opt/oracle

unzip
-d /opt/oracle instantclient-basic-linux32-10.2.0.3-20061115.zip

unzip
-d /opt/oracle instantclient-sdk-linux32-10.2.0.3-20061115.zip

unzip
-d /opt/oracle instantclient-sqlplus-linux32-10.2.0.3-20061115.zip

3. Lakukan konfigurasi
   Client

cd
/opt/oracle/instantclient_10_2 (your version may be diff)

sudo
ln -s libclntsh.so.10.1 libclntsh.so

sudo
ln -s libclntsh.so.10.1 libclntsh.so && ln -s libocci.so.10.1
libocci.so

sudo
mkdir bin

cd
bin

sudo
ln -s ../sqlplus .

4. Konfigurasikan file
   /opt/oracle/instantclient_10_2/admin/tnsname.ora, isi dengan:

simpondb
=

(DESCRIPTION
=

(ADDRESS
= (PROTOCOL = tcp)(HOST = 192.168.88.1)(PORT = 1521))

(CONNECT_DATA
=

(SERVER
= DEDICATED)

(SERVICE_NAME = db1)

)

)

5. Setting Environment
   agar aplikasi dapat menggunakan Oracle client.

touch
/etc/profile.d/oracle.sh

chmod
+x /etc/profile.d/oracle.sh

isikan
dengan

export
ORACLE_HOME=/opt/oracle/instantclient_10_2

export
TNS_ADMIN=/opt/oracle/instantclient_10_2/admin

export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

export
PATH=$PATH:$ORACLE_HOME/bin