I am trying to install DBD:Oracle and DBD so that I can write a script to clean up some
attachments with our primary database, and change the pointers to show that the attachments
are gone. But I ran into an issue with the above packages. I tried the initial install using
cpan. but I did not have the environment variables set, so it did not compile correctly. I would
like to remove and reinstall the packages, or mostly just get them working. I do have an 11.2.0.4
Oracle client on the server. But I will be connecting to another server for the database.
Can someone point me in the right direction. The server is Redhat 6.8. Thanks
$:~/ ./runMyPerlScript.pl
Can't load '/usr/local/lib/perl5/site_perl/5.28.0/x86_64-linux/auto/DB
+I/DBI.so' for module DBI: /usr/local/lib/perl5/site_perl/5.28.0/x86_6
+4-linux/auto/DBI/DBI.so: undefined symbol: PL_sv_immortals at /usr/li
+b64/perl5/DynaLoader.pm line 200.
at /usr/local/lib/perl5/site_perl/5.28.0/x86_64-linux/DBI.pm line 284
+.
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+28.0/x86_64-linux/DBI.pm line 284.
Compilation failed in require at /usr/local/lib/perl5/site_perl/5.28.0
+/x86_64-linux/DBD/Oracle.pm line 20.
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+28.0/x86_64-linux/DBD/Oracle.pm line 20.
Compilation failed in require at /home/oracle/scripts/purge_proddoc_sc
+ript/purge_proddoc_script.pl line 16.
BEGIN failed--compilation aborted at /home/oracle/scripts/purge_proddo
+c_script/purge_proddoc_script.pl line 16 (#1)
(F) The module you tried to load failed to load a dynamic extensio
+n. This
may either mean that you upgraded your version of perl to one that
+ is
incompatible with your old dynamic extensions (which is known to h
+appen
between major versions of perl), or (more likely) that your dynami
+c
extension was built against an older version of the library that i
+s
installed on your system. You may need to rebuild your old dynamic
extensions.
Uncaught exception from user code:
Can't load '/usr/local/lib/perl5/site_perl/5.28.0/x86_64-linux
+/auto/DBI/DBI.so' for module DBI: /usr/local/lib/perl5/site_perl/5.28
+.0/x86_64-linux/auto/DBI/DBI.so: undefined symbol: PL_sv_immortals at
+ /usr/lib64/perl5/DynaLoader.pm line 200.
at /usr/local/lib/perl5/site_perl/5.28.0/x86_64-linux/DBI.pm line 284
+.
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+28.0/x86_64-linux/DBI.pm line 284.
Compilation failed in require at /usr/local/lib/perl5/site_perl/5.28.0
+/x86_64-linux/DBD/Oracle.pm line 20.
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+28.0/x86_64-linux/DBD/Oracle.pm line 20.
Compilation failed in require at /home/oracle/scripts/purge_proddoc_sc
+ript/purge_proddoc_script.pl line 16.
BEGIN failed--compilation aborted at /home/oracle/scripts/purge_proddo
+c_script/purge_proddoc_script.pl line 16.
at /home/oracle/scripts/purge_proddoc_script/purge_proddoc_script.pl
+line 16.
$:~/scripts/purge_proddoc_script > cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)
#!/usr/bin/perl
use strict;
use warnings;
use diagnostics;
package purge_proddoc_script;
use Getopt::Std;
# use Sys::Hostname;
use POSIX qw(setuid setgid);
use English;
use Carp;
use Cwd 'abs_path';
use DBD::Oracle qw(:ora_session_modes);
use DBI;
use File::Basename;
use IO::Handle;
use Log::Log4perl qw( :easy );
use Text::Diff;
local $SIG{__WARN__} = \&Carp::cluck;
$SIG{__DIE__} = sub {
# return if $^S; # ignore die in an eval block
# Get the actual caller for the "die" and not the wrapper
local $Log::Log4perl::caller_depth;
$Log::Log4perl::caller_depth++;
LOGDIE($_[0]);
};
# possible log values: DEBUG, INFO, WARN, ERROR, FATAL
my $debug_level="INFO";
# my $error_mail_list='bbyrd@aires.com, ASayed@aires.com, vkamins@aire
+s.com, RKatru@aires.com';
my $error_mail_list='bbyrd@aires.com';
# Unbuffer STDOUT and STDERR
select STDERR; $| = 1;
select STDOUT; $| = 1;
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.