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

Hello Marto,

Apologies for missing to share the details

The error got resolved as the last command make install required root to complete the installation which I was not having. On acquiring the root privilege the error has gone

TERM=vt100; export TERM
#  Set base Oracle environment.
ORAENV_ASK=YES;                                export ORAENV_ASK
ORACLE_SID=CLIENT19G;                             export ORACLE_SID
ORACLE_BASE=/app/chart/oracle;                       export ORACLE_BAS
+E
ORACLE_HOME=${ORACLE_BASE}/product/19c;      export ORACLE_HOME
TNS_ADMIN=${ORACLE_BASE}/admin/network;        export TNS_ADMIN
ORAINST=/tmp/oraInst.loc;                       export ORAINST

#  NLS Settings
ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data; export ORA_NLS33
ORA_NLS10=${ORACLE_HOME}/nls/data;             export ORA_NLS10
#NLS_LANG=american_america.WE8ISO8859P15;       export NLS_LANG
NLS_DATE_FORMAT='DD-MON-YYYY:HH24-MI-SS';      export NLS_DATE_FORMAT

TNS_ALIAS=STG                                         ; export TNS_ALI
+AS

PATH=$PATH:${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:/usr/local/bin:/us
+r/sbin:/usr/ccs/bin:/usr/contrib/bin:/usr/openwin/bin; export PATH
LD_LIBRARY_PATH=${ORACLE_HOME}/lib       ; export LD_LIBRARY_PATH
PS1='${USER}@`hostname`:[${ORACLE_SID}]:`pwd` $ '; export PS1
#export PS1=$LOGNAME
PS2="`hostname`: $ "; export PS2
EDITOR=vi; export EDITOR
umask 022

alias ping=/usr/sbin/ping
stty erase ^?
[download]

Post successful I am getting below version mismatch error

install_driver(Oracle) failed: DBD::Oracle object version 1.80 does not match bootstrap parameter 1.24 at /usr/lib64/perl5/DynaLoader.pm line 213. Compilation failed in require at (eval 28) line 3. 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.

What should I do now?

Thanks

Comment on Re^4: /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^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
`DBD::Oracle object version 1.80 does not match bootstrap parameter 1. +24` [download] This means that Perl finds a `Oracle.so` for DBD::Oracle 1.80, but the `Oracle.pm` it loads is version 1.24. This problem usually comes from different module search paths in PERL5LIB and/or using a different version of Perl between installing the module and then running your test program.	[reply] [d/l] [select]
Re^6: /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:28 UTC
Hello Corion, How can I upgrade/install Oracle.pm Apologies for a simple question but I am pretty new to perl and I am resolving the issues on the go as I am encountering them Thanks	[reply]
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
Where did you install the SDK? Your ORACLE_HOME seems to point at the Oracle 19c database installation, there's no mention of the instant client path. Your install is still not correct, hence the first message is the same. The second message message about tells you that Oracle.pm (of the DBD::Oracle install you made) relates to v1.24, where as the Oracle shared object file you have is for version 1.60. Perhaps confusion from trying to install different versions of the module. Stick to the latest release unless you have good reason not to. Since you don't show how, I'm guessing you're doing a `perl Makefile.PL`, you should get more details from `perl Makefile.PL -v`.	[reply] [d/l] [select]
Re^6: /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 12:09 UTC
Hello Marto, As I have mentioned I have installed Oracle 19c (19.3). The path to ORACLE_HOME is for the client installation only The client that I have installed was downloaded from https://www.oracle.com/uk/database/technologies/oracle19c-linux-downloads.html under the header Oracle Database 19c Client (19.3) for Linux x86-64	[reply]
Re^7: /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 12:21 UTC
That path looks like it's for the 19c database, not the instantclient. Depending on how Oracle is installed (often out of our hands, by DBAs etc), you may not have everything you need to build DBD::Oracle, hence why I suggested getting the components listed in the modules README, setting `ORACLE_HOME` (and `LD_LIBRARY_PATH`) as required then building the module. From experience this is more likely to be successful, less likely to run into some Oracle related shenanigans.	[reply] [d/l] [select]