Oracle call interface (OCI) demo programs come with database software installation. For the release 21.7 you can find them in the directory ${ORACLE_HOME}\/sdk\/demo\/<\/i>.<\/p>\n
Linking is failing:<\/p>\n
make -f demo.mk buildoci EXE=cdemo81 OBJS=cdemo81.o\nrm -rf SunWS_cache\n\/usr\/bin\/g++ -o cdemo81 -g cdemo81.o -L..\/..\/ -locci -lclntsh -lpthread\n\/usr\/bin\/ld: cannot find -locci\n\/usr\/bin\/ld: cannot find -lclntsh<\/span>\ncollect2: error: ld returned 1 exit status\nmake: *** [demo.mk:81: buildoci] Error 1<\/code><\/pre>\nThe error message above tells us that the Oracle client library libclntsh and OCI library libocci couldn’t be found. The both libraries are contained in the lib directory of the Oracle database software installation:<\/p>\n
ls ${ORACLE_HOME}\/lib\/libclntsh.so\n\/u00\/oracle\/orabase\/product\/21.7.0.0.220719_a\/lib\/libclntsh.so\n\nls ${ORACLE_HOME}\/lib\/libocci.so\n\/u00\/oracle\/orabase\/product\/21.7.0.0.220719_a\/lib\/libocci.so<\/code><\/pre>\nLD_LIBRARY_PATH is pointing to the correct directory:<\/p>\n
env | grep LD_LIBRARY_PATH\nLD_LIBRARY_PATH=\/u00\/oracle\/orabase\/product\/21.7.0.0.220719_a\/lib<\/code><\/pre>\nBut LD_LIBRARY_PATH doesn’t help here because it is used only during runtime and not during linking.<\/p>\n
The library directory path during linking must be specified with the -L option. There’s an entry in the makefile demo.mk but it is set to ${ORACLE_HOME} instead of ${ORACLE_HOME}\/lib.<\/p>\n
ICLIBHOME=..\/..\/\nICLIBPATH=-L$(ICLIBHOME)<\/code><\/pre>\nWith the following correction<\/p>\n
#ICLIBPATH=-L$(ICLIBHOME)\nICLIBPATH=-L$(ICLIBHOME)\/lib<\/span><\/code><\/pre>\nthe demo program links and compiles without problems:<\/p>\n
make -f demo.mk buildoci EXE=cdemo81 OBJS=cdemo81.o\nrm -rf SunWS_cache\n\/usr\/bin\/g++ -o cdemo81 -g cdemo81.o -L..\/..\/\/lib -locci -lclntsh -lpthread\n\nls cdemo81\ncdemo81<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"An error in the make file with an easy fix. Continue Reading