1.proc: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file: No such file or directory问题
设置:
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
2.错误:
System default option values taken from: /app/qual/product/12.1.0/dbhome_1/precomp/admin/pcscfg.cfg
Error at line 33, column 11 in file /usr/include/stdio.h
# include <stddef.h>
..........1
PCC-S-02015, unable to open include file
Error at line 15, column 10 in file /usr/include/_G_config.h
#include <stddef.h>
.........1
PCC-S-02015, unable to open include file
这类错误找出头文件所在的版本:
find . -name stdio.h
./usr/include/bits/stdio.h
./usr/include/stdio.h
./usr/include/c++/4.8.2/tr1/stdio.h
修改$ORACLE_HOME//precomp/admin/ pcscfg.cfg文件,
sys_include=($ORACLE_HOME/precomp/public,/usr/include,/usr/lib/gcc/x86_64-redhat-linux/4.1.2/include,/usr/lib/gcc/x86_64-redhat-linux/4.4.7/include,/usr/lib/gcc/x86_64-redhat-linux/4.4.4/include,/usr/lib64/gcc/x86_64-suse-linux/4.1.2/include,/usr/lib64/gcc/x86_64-suse-linux/4.3/include)
ltype=short
define=__x86_64__
sys_include=($ORACLE_HOME/precomp/public,/usr/include,/usr/lib/gcc/x86_64-redhat-linux/4.1.2/include,/usr/lib/gcc/x86_64-redhat-linux/4.4.7/include,/usr/lib/gcc/x86_64-redhat-linux/4.8.2/include,/usr/lib64/gcc/x86_64-suse-linux/4.1.2/include,/usr/lib64/gcc/x86_64-suse-linux/4.3/include)
ltype=short
define=__x86_64__
3.make文件编写:
#目标文件
TARGET=oracle_connect
#ORACLE工具
ORA_INC=-I$(ORACLE_HOME)/precomp/public
ORA_LIBDIR=-L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/rdbms/lib -L$(ORACLE_HOME)/precomp/lib -L$(ORACLE_HOME)/sqlplus/lib -L$(ORACLE_HOME)/otrace/lib
ORA_LIBS= -lclntsh
CFLAGS= $(ORA_INC) -I.
PROC=proc
#C编译
CC=gcc
#编译程序
$(TARGET): $(TARGET).pc$(PROC) $(TARGET).pc
$(CC) $(CFLAGS) -o $(TARGET) $(TARGET).c $(ORA_LIBDIR) $(ORA_LIBS) -lm
mv $(TARGET) $(HOME)/bin
rm $(TARGET).c $(TARGET).lis