http://qs1969.pair.com?node_id=11137236


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

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.

  • Comment on Re^5: /app/chart/oracle/product/19c/sdk/include/oci.h:745:20: fatal error: ociver.h: No such file or directory
  • Select or Download Code

Replies are listed 'Best First'.
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

      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.