/app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory

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
When you installed instantclient did you also install the SDK along with the basic package? https://metacpan.org/release/MJEVANS/DBD-Oracle-1.80/source/README#L53. ociver.h is in `/instantclient_19_12/sdk/include`. If so do you have the correct environment variables set?	[reply] [d/l]
Re^2: /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory by silversurfer2in (Initiate) on Oct 05, 2021 at 10:28 UTC
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]
Re^3: /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:37 UTC
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]
Re^4: /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory by silversurfer2in (Initiate) on Oct 05, 2021 at 11:14 UTC
Re^5: /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory by Corion (Patriarch) on Oct 05, 2021 at 11:21 UTC
Some notes below your chosen depth have not been shown here
Re^5: /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 11:29 UTC
Some notes below your chosen depth have not been shown here


Pathologically Eclectic Rubbish Lister
	PerlMonks