PIB

• Oracle Database Instant Client

Instant Client for Linux x86
から Basic, SQL*Plus, SDK, ODBC を拾ってきたら
/tmp 辺りに適当な作業フォルダーを掘って移動しておく。

あとは以下の処理を流すだけ

unzip instantclient-basic-linux32-11.2.0.1.zip 
unzip instantclient-sqlplus-linux32-11.2.0.1.zip 
unzip instantclient-sdk-linux32-11.2.0.1.zip 
unzip instantclient-odbc-linux32-11.2.0.1.zip 

mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/bin/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/lib/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/jdbc/lib/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/odbc/html/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/odbc/util/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/sqlplus
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/rdbms/public/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/rdbms/demo/
mkdir -p usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/precomp/lib/
mkdir -p usr/share/doc/oracle-instant-client/
mkdir -p etc/ld.so.conf.d/

mv instantclient_11_2/adrci              usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/bin/
mv instantclient_11_2/genezi             usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/bin/
mv instantclient_11_2/sqlplus            usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/bin/
mv instantclient_11_2/sdk/ott            usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/bin/
mv instantclient_11_2/*.so*              usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/lib/
mv instantclient_11_2/ODBC*.htm*         usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/odbc/html/
mv instantclient_11_2/odbc*.sh           usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/odbc/util/
mv instantclient_11_2/*.jar              usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/jdbc/lib/
mv instantclient_11_2/*.sql              usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/sqlplus/
mv instantclient_11_2/sdk/demo           usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/rdbms/
mv instantclient_11_2/sdk/include/*      usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/rdbms/public/
mv instantclient_11_2/sdk/ottclasses.zip usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/precomp/lib/
mv instantclient_11_2/*README            usr/share/doc/oracle-instant-client/
mv instantclient_11_2/sdk/*README        usr/share/doc/oracle-instant-client/

ln -s libclntsh.so.11.1 usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/lib/libclntsh.so
ln -s libocci.so.11.1   usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/lib/libocci.so

echo /usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/lib > etc/ld.so.conf.d/oracle-instant-client.conf

tar zcvf oracle_instant_client-11.2.0.1.tgz usr etc
alien oracle_instant_client-11.2.0.1.tgz

oracle-instant-client_11.2.0.1-2_all.deb が出来るので

# dpkg -i oracle-instant-client_11.2.0.1-2_all.deb

としてインストール。

libaio.so.1 が必要なので未インストールの場合

# aptitude install libaio1

としてインストールしておく

以下のように設定する

# export ORACLE_HOME=/usr/lib/oracle/instant/app/oracle/product/11.2.0.1/client/

• Debian - Oracle Database 10g Express Edition