Soci库linux下编译方法.doc

Soci库的linux编译方法 1、下载soci库源码 2、在目标机器上配置数据库环境 以oracle为例：（其他数据库只需要简单安装客户端即可） 下载oracle客户端安装包 oracle-instantclient-basic-12.1.0.5-1.i386.rpmoracle-instantclient-devel-12.1.0.5-1.i386.rpmoracle-instantclient-sqlplus-12.1.0.5-1.i386.rpm 按如上的顺序安装三包 # rmp -ivh 带安装包名 C）配置环境变量 # vi /etc/profile 编辑如下 export ORACLE_HOME=/usr/lib/oracle/12.1/client export LD_LIBRARY_PATH=:$ORACLE_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH:. export SQLPATH=/usr/lib/oracle/12.1/client/network/admin export TNS_ADMIN=/usr/lib/oracle/12.1/client/network/admin export PATH=$PATH:${ORACLE_HOME}bin:. export ORACLE_SID=PLAT D）配置监听文件 #cd /usr/lib/oracle/12.1/client/network/admin 拷贝如下三文件到上面目录 listener.ora sqlnet.ora tnsnames.ora 编辑文件内容如下： listener.ora文件： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = XTPLAT) (ORACLE_HOME = /usr/lib/oracle/12.1/client) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.220)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) ) sqlnet.ora文件： SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) tnsnames.ora文件： XTPLAT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.220)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XTPlat) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) E) 环境变量没设置好 #sqlplus openVone/openVone@XTPLAT 能出现如下： [root@localhost admin]# sqlplus openVone/openVone@XTPLAT SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 24 10:49:59 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL 配置ok 3、解压soci源码soci-x.y.z到目