linux下面C++调用oracle OCI出现 .proc: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
解决方法:
在/etc/profile中添加
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib;
export LD_LIBRARY_PATH
然后可以用source /etc/profile 生效一下
终端需要断开重新连接一次
oracle 调用OCI出现以下错误:
cannot restore segment prot after reloc: Permission denied
解决方案,执行:
/usr/sbin/setenforce 0
编译连接选项:
g++ -Wall -g -o oci_out -I$OCI_ROOT -L/u01/app/oracle/product/9.2.0/lib -lclntsh -lrt oci_main.cpp
//oci_main.cpp
#include "oci.h"
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
int main()
{
printf("Hello world!\n");
OCIEnv * m_envhp;
OCIError * m_errhp;
OCIServer * m_srvhp;
OCISvcCtx * m_svchp;
OCISession * m_usrhp;
OCIDescribe * m_dschp;
OCITrans * m_txnhp;
sword status;
char *dblink="mobile";
char *username="mobile";
char *password="mobile";
int mode = OCI_THREADED|OCI_OBJECT;
OCIInitialize((ub4)mode, (dvoid *)0,
(dvoid*(*)(dvoid *ctxp, size_t size))0,
(dvoid*(*)(dvoid *ctxp, dvoid *memptr, size_t newsize))0,
(void (*)(dvoid *ctxp, dvoid *memptr))0);
OCIEnvInit(&m_envhp, (ub4)OCI_DEFAULT, (size_t)0, (dvoid**)0);
//
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_errhp, (ub4)OCI_HTYPE_ERROR,
(size_t)0, (dvoid**)0);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_srvhp, (ub4)OCI_HTYPE_SERVER,
(size_t)0, (dvoid**)0);
status = OCIServerAttach(m_srvhp, m_errhp, (text*)dblink,
(sb4)strlen(dblink), (ub4)OCI_DEFAULT);
char error_msg[512]={0};
int err=0;
if (status != OCI_SUCCESS)
{
OCIErrorGet((dvoid *)m_errhp, (ub4)1, (text *)NULL, &err,
(unsigned char*)error_msg, (ub4)sizeof(error_msg), OCI_HTYPE_ERROR);
printf("%s\n",error_msg);
return FALSE;
}
//
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_svchp, (ub4)OCI_HTYPE_SVCCTX,
(size_t)0, (dvoid**)0);
OCIAttrSet((dvoid*)m_svchp, (ub4)OCI_HTYPE_SVCCTX, (dvoid*)m_srvhp, (ub4)0,
(ub4)OCI_ATTR_SERVER, m_errhp);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_usrhp, (ub4)OCI_HTYPE_SESSION,
(size_t)0, (dvoid**)0);
OCIAttrSet((dvoid*)m_usrhp, (ub4)OCI_HTYPE_SESSION, (dvoid*)username,
(ub4)strlen(username), (ub4)OCI_ATTR_USERNAME, m_errhp);
OCIAttrSet((dvoid*)m_usrhp, (ub4)OCI_HTYPE_SESSION, (dvoid*)password,
(ub4)strlen(password), (ub4)OCI_ATTR_PASSWORD, m_errhp);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_dschp,
(ub4)OCI_HTYPE_DESCRIBE, (size_t)0, (dvoid **)0);
status = OCISessionBegin(m_svchp, m_errhp, m_usrhp, OCI_CRED_RDBMS,
OCI_DEFAULT);
OCIHandleAlloc((dvoid *)m_envhp, (dvoid **)&m_txnhp, OCI_HTYPE_TRANS, 0, 0);
OCIAttrSet((dvoid *)m_svchp, OCI_HTYPE_SVCCTX, (dvoid *)m_txnhp, 0,
OCI_ATTR_TRANS, m_errhp);
OCIAttrSet((dvoid*)m_svchp, (ub4)OCI_HTYPE_SVCCTX, (dvoid*)m_usrhp, (ub4)0,
(ub4)OCI_ATTR_SESSION, m_errhp);
return 1;
}
解决方法:
在/etc/profile中添加
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib;
export LD_LIBRARY_PATH
然后可以用source /etc/profile 生效一下
终端需要断开重新连接一次
oracle 调用OCI出现以下错误:
cannot restore segment prot after reloc: Permission denied
解决方案,执行:
/usr/sbin/setenforce 0
编译连接选项:
g++ -Wall -g -o oci_out -I$OCI_ROOT -L/u01/app/oracle/product/9.2.0/lib -lclntsh -lrt oci_main.cpp
//oci_main.cpp
#include "oci.h"
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
int main()
{
printf("Hello world!\n");
OCIEnv * m_envhp;
OCIError * m_errhp;
OCIServer * m_srvhp;
OCISvcCtx * m_svchp;
OCISession * m_usrhp;
OCIDescribe * m_dschp;
OCITrans * m_txnhp;
sword status;
char *dblink="mobile";
char *username="mobile";
char *password="mobile";
int mode = OCI_THREADED|OCI_OBJECT;
OCIInitialize((ub4)mode, (dvoid *)0,
(dvoid*(*)(dvoid *ctxp, size_t size))0,
(dvoid*(*)(dvoid *ctxp, dvoid *memptr, size_t newsize))0,
(void (*)(dvoid *ctxp, dvoid *memptr))0);
OCIEnvInit(&m_envhp, (ub4)OCI_DEFAULT, (size_t)0, (dvoid**)0);
//
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_errhp, (ub4)OCI_HTYPE_ERROR,
(size_t)0, (dvoid**)0);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_srvhp, (ub4)OCI_HTYPE_SERVER,
(size_t)0, (dvoid**)0);
status = OCIServerAttach(m_srvhp, m_errhp, (text*)dblink,
(sb4)strlen(dblink), (ub4)OCI_DEFAULT);
char error_msg[512]={0};
int err=0;
if (status != OCI_SUCCESS)
{
OCIErrorGet((dvoid *)m_errhp, (ub4)1, (text *)NULL, &err,
(unsigned char*)error_msg, (ub4)sizeof(error_msg), OCI_HTYPE_ERROR);
printf("%s\n",error_msg);
return FALSE;
}
//
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_svchp, (ub4)OCI_HTYPE_SVCCTX,
(size_t)0, (dvoid**)0);
OCIAttrSet((dvoid*)m_svchp, (ub4)OCI_HTYPE_SVCCTX, (dvoid*)m_srvhp, (ub4)0,
(ub4)OCI_ATTR_SERVER, m_errhp);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_usrhp, (ub4)OCI_HTYPE_SESSION,
(size_t)0, (dvoid**)0);
OCIAttrSet((dvoid*)m_usrhp, (ub4)OCI_HTYPE_SESSION, (dvoid*)username,
(ub4)strlen(username), (ub4)OCI_ATTR_USERNAME, m_errhp);
OCIAttrSet((dvoid*)m_usrhp, (ub4)OCI_HTYPE_SESSION, (dvoid*)password,
(ub4)strlen(password), (ub4)OCI_ATTR_PASSWORD, m_errhp);
OCIHandleAlloc((dvoid*)m_envhp, (dvoid**)&m_dschp,
(ub4)OCI_HTYPE_DESCRIBE, (size_t)0, (dvoid **)0);
status = OCISessionBegin(m_svchp, m_errhp, m_usrhp, OCI_CRED_RDBMS,
OCI_DEFAULT);
OCIHandleAlloc((dvoid *)m_envhp, (dvoid **)&m_txnhp, OCI_HTYPE_TRANS, 0, 0);
OCIAttrSet((dvoid *)m_svchp, OCI_HTYPE_SVCCTX, (dvoid *)m_txnhp, 0,
OCI_ATTR_TRANS, m_errhp);
OCIAttrSet((dvoid*)m_svchp, (ub4)OCI_HTYPE_SVCCTX, (dvoid*)m_usrhp, (ub4)0,
(ub4)OCI_ATTR_SESSION, m_errhp);
return 1;
}