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

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?.

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