Red Hat Enterprise Linux AS4, C++ OCCI connect Oracle 9i

Red Hat Enterprise Linux AS4, C++ OCCI connect Oracle 9i，前提是已经安装好Oracle 9i。1. 下载对应的ORACLE client安装。http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html因为没有9i的client提供下载了，我选择最接近的版本下载：Version 10.1.0.5
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Download instantclient-basic-linux32-10.1.0.5-20060511.zip （31,413,713 bytes）（cksum - 384697539）下载之后解压。2. 先把示例代码给出来：//oci.cpp
#include <iostream>
#include <string>
#include <occi.h>
using namespace std;
using namespace oracle::occi;int main（）
{
Connection *conn;
Environment *env;
Statement *stmt; //build a connection
string struser（"scott"）;
string strpwd（"tiger"）;
string strconn_string（""）;
cout << "1" << endl;

env = Environment::createEnvironment（Environment::OBJECT）;
cout << "2" << endl; conn = env->createConnection（struser, strpwd, strconn_string）;
cout << "3" << endl; if（ NULL ！= conn）
cout << "conn success" << endl;
else
cout << "conn failed" << endl; //execute sql statement
string strsql（"select to_char（sysdate,"yyyy-mm-dd hh24:mi:ss"） from dual"）;
stmt = conn->createStatement（strsql）;
ResultSet *rset = stmt->executeQuery（）; while（rset->next（））
{
string time = rset->getString（1）;
cout << "now time:" << time << endl;
}

//close resourses
stmt->closeResultSet（rset）;
conn->terminateStatement（stmt）;
env->terminateConnection（conn）;
Environment::terminateEnvironment（env）; return 0;
}3. 编译这里对g++的版本有要求，如果是g++ 3.x.x的，可能会爆出如下错误：undefined reference to `oracle::occi::Environment::createEnvironment（orac le::occi::Environment::Mode, void*, void* （*）（void*, unsigned int）, void* （*）（void*, void*, unsigned int）, void （*）（void*, void*））"网上很多讨论这个错误的，解决办法是安装低版本的g++。--------------------------------------------------------------------------------资料（可以不看）：解决方案的出处：http://www.dbforums.com/showthread.php？1619980-Makefile-problem-for-OCCI-on-Oracle-9iIf you"re getting the following error messages:undefined reference to `oracle:occi::Environment::createEnvironment（oracle:occi::Environment::Mode, void*, void* （*）（void*, unsigned）, void* （*）（void*, void*, unsigned）, void （*）（void*, void*））"andundefined reference to `oracle:occi::Environment::terminateEnvironment（oracle:occi::Environment*）"then you"re probably running oracle9i on RedHat 8.0. to solve this, download and install the following rpm"s from this redhat link:* compat-gcc-7.3-2.96.118.i386.rpm
* compat-gcc-c++-7.3-2.96.118.i386.rpm
* compat-libstdc++-7.3-2.96.118.i386.rpm
* compat-libstdc++-devel-7.3-2.96.118.i386.rpmand compile with g++296 instead of g++. sure you"ll be stuck with g++-2.96, but at least it will compile and run.--------------------------------------------------------------------------------如下4个rpm包安装：* compat-gcc-7.3-2.96.118.i386.rpm
* compat-libstdc++-7.3-2.96.118.i386.rpm
* compat-libstdc++-devel-7.3-2.96.118.i386.rpm
* compat-gcc-c++-7.3-2.96.118.i386.rpm在Linux公社1号FTP服务器下载：------------------------------------------分割线------------------------------------------FTP地址：ftp://ftp1.linuxidc.com用户名：ftp1.linuxidc.com密码：www.linuxidc.com在 2016年LinuxIDC.com3月Red Hat Enterprise Linux AS4, C++ OCCI connect Oracle 9i下载方法见 http://www.linuxidc.com/Linux/2013-10/91140.htm------------------------------------------分割线------------------------------------------请按照安装上述顺序安装rpm包，因为最后一个依赖于第一二三个。如果安装的时候报错说“正在安装的g++与系统上存在的g++有冲突”，在rpm后加上-aid --force参数，如下：sudo rpm -ivh xxx.rpm -aid --force安装好此版本的g++后，就可以用以下命令编译了： g++296 -o oci -I /opt/oracle/product/rdbms/public/ -I /opt/oracle/product/rdbms/demo/ -I /home/oracle/instantclient10_1/ -L /opt/oracle/product/lib/ -L /opt/oracle/product/rdbms/lib/ oci.cpp -lclntsh -locci /usr/lib/libstdc++.so.5 -Wall -O -g注意仔细看上边所包含的编译目录，先看看自己的$ORACLE_HOME在哪里，看看上述的目录都在不在。其中instantclient10_1目录便是第一步下载的Oracle client。4. 运行结果如下图更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12更多RedHat相关信息见RedHat 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=10本文永久更新链接地址