ocilib 安裝配置

1，安裝操作系統的時候最好安裝一些兼容的包，開發相關的包，否則後來你會很鬱悶
2，安裝oracle相關開發工具，
 oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm
 oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm
 oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386.rpm
3,安裝ocilib
一般是tar.gz安裝包
./configure && make && make install
4，配置環境變量.bash_profile
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/11.2/client64/lib:/usr/local/lib/
PATH=$PATH:/usr/lib/oracle/11.2/client64/bin
#export ORACLE_HOME=/usr/lib/oracle/11.2/client64:/u01/app/oracle/product/11.2.0/db_1

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

測試1，首先能夠sqlplus 連接一個數據庫

測試2，

#include "ocilib.h"

int main(void)
{
    OCI_Connection *cn;

    if (!OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT))
        return EXIT_FAILURE;

    cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);

    printf("Server major    version : %i\n",   OCI_GetServerMajorVersion(cn));
    printf("Server minor    version : %i\n",   OCI_GetServerMinorVersion(cn));
    printf("Server revision version : %i\n\n", OCI_GetServerRevisionVersion(cn));
    printf("Connection      version : %i\n\n", OCI_GetVersionConnection(cn));

    OCI_Cleanup();

    return EXIT_SUCCESS;
}

保存爲ocitest。c

然後執行：

gcc ocitest.c  -locilib

./a.out

查看執行結果