silversurfer2in has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks,

I am working on a roject which perl version v5.16.3. There are scripts in perl which are connecting to the Oracle database 19c and in order to do that we have oracle client 19.3 installed as well on the Linux server.

As part of tgis connectivity I am trying to install DBD::Oracle driver for the database connectivity. I tried using v1.80, v1.74 and even 1.48 by using below commands perl Makefile.PL make make install But while executing "make" I am getting below eror and have no clue how to fix it 
make
cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib/lib/DBD/Oracle/Troub
+leshooting/Cygwin.pod
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Troubleshooting/Vms.pod blib/lib/DBD/Oracle/Troubles
+hooting/Vms.pod
cp lib/DBD/Oracle/Troubleshooting/Linux.pod blib/lib/DBD/Oracle/Troubl
+eshooting/Linux.pod
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle/Troubleshoot
+ing.pod
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp lib/DBD/Oracle/Troubleshooting/Hpux.pm blib/lib/DBD/Oracle/Troubles
+hooting/Hpux.pm
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp lib/DBD/Oracle/Troubleshooting/Sun.pod blib/lib/DBD/Oracle/Troubles
+hooting/Sun.pod
cp lib/DBD/Oracle/Troubleshooting/Macos.pod blib/lib/DBD/Oracle/Troubl
+eshooting/Macos.pod
cp lib/DBD/Oracle/Troubleshooting/Aix.pod blib/lib/DBD/Oracle/Troubles
+hooting/Aix.pod
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp lib/DBD/Oracle/Troubleshooting/Win64.pod blib/lib/DBD/Oracle/Troubl
+eshooting/Win64.pod
cp lib/DBD/Oracle/Troubleshooting/Win32.pod blib/lib/DBD/Oracle/Troubl
+eshooting/Win32.pod
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib64/perl5/vendor_perl
+/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /usr/share/perl5/vendor_perl/ExtUtils/xsubpp  -typemap /
+usr/share/perl5/ExtUtils/typemap -typemap typemap  Oracle.xs > Oracle
+.xsc && mv Oracle.xsc Oracle.c
gcc -c  -I/app/chart/oracle/product/19c/sdk/include -I/app/chart/oracl
+e/product/19c/rdbms/public -I/app/chart/oracle/product/19c/rdbms/demo
+ -I/app/chart/oracle/product/19c/rdbms/public -I/app/chart/oracle/pro
+duct/19c/plsql/public -I/app/chart/oracle/product/19c/network/public 
+-I/usr/lib64/perl5/vendor_perl/auto/DBI -D_REENTRANT -D_GNU_SOURCE -f
+no-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LA
+RGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTI
+FY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-
+size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\"1.48\"
+ -DXS_VERSION=\"1.48\" -fPIC "-I/usr/lib64/perl5/CORE"  -Wall -Wno-co
+mment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.3.0.0\" -DORA_OCI_102 -DO
+RA_OCI_112 Oracle.c
In file included from Oracle.h:37:0,
                 from Oracle.xs:1:
/app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: o
+civer.h: No such file or directory
 #include <ociver.h>
                    ^
compilation terminated.

[download]
Please help me out as I have been struggling from days on this. Thanks, Gaurav
  • Comment on /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory
  • Download Code

Replies are listed 'Best First'.
Re: /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory
by marto (Cardinal) on Oct 05, 2021 at 10:11 UTC
[reply]
[d/l]
      Hello Marto,

      Thanks for for your valuable input. It seems my installation wasn't correct so I downloaded instantclient-sdk-linux.x64-21.3.0.0.0.zip from Oracle and copied the ociver.h file at the location and post which the installation completed successfully.

      But now I am facing another error as per below

      install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /app/chart/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 28) line 3. Compilation failed in require at (eval 28) line 3. Perhaps a module that DBD::Oracle requires hasn't been fully installed at /app/chart/perl5/StagingDBI.pm line 98. @(in cleanup) Can't call method "disconnect" on an undefined value at /app/chart/perl5/StagingDBI.pm line 265.

      Can you please help me with this as completely new to perl so apologies for asking multiple questions

      Thanks

[reply]

        DBD::Oracle is not installed correctly. Unless you really know what you're doing don't copy single files from the SDK, follow the guidance, install the basic instant client, then the SDK, sqlplus also helps to debug connectivity problems. You haven't shown what your environment variables are set to (e.g. ORACLE_HOME), this is also in the note. The more detail you provide about your environment and what you've done the easier it'll be for others to help. How do I post a question effectively?.

[reply]
[d/l]

Back to Seekers of Perl Wisdom