OK, I may be opening myself up to a complete flaming session here. What with my lack of knowledge in Oracle. :-(
Anyway, we've an issue whereby we have 2 servers with supposedly identical installs of both their respective Operating System, and Oracle.
Oracle Version: 8
O/S: SunOS 5.6
Basically we can connect to the first server without any problems at all, however when I try and run the same script on server number 2, with the server name changed (naturally) I get the following error message:install_driver(Oracle) failed: Can't load '/sbcimp/run/pd/perl/5.004_04/lib/site_perl/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /MINT/tools/bin/perl: fatal: libclntsh.so.1.0: open failed: No such file or directory at /sbcimp/run/pd/perl/5.004_04/lib/sun4-solaris/5.00404/DynaLoader.pm line 166.
at (eval 1) line 2
at test_conn.cgi line 18
The script is good, I know this is not the issue, I think maybe it's related to an environment variable / setup somewhere.
I checked on the Net to try and get some background info on the message and cannot really find anything specifically related.
If anyone has a thought could you kick me please.
Many Thanks...
Below is the script I'm using which works good on server 1 then dies horribly on server 2:
#! /MINT/tools/bin/perl
#use strict;
use DBI qwsql_types);
use CGI qwcgi-lib :standard);
# Setup ORACLE stuff
$ENV{ORACLE_BASE}="/oracle";
$ENV{ORACLE_HOME}="/oracle";
$ENV{LD_LIBRARY_PATH}="\$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ccs/lib";
$ENV{ORACLE_SID}="ORCL8";
$ENV{TMPDIR}="/tmp";
$ENV{PATH}="\$PATH:\$ORACLE_HOME/bin:/usr/ccs/lib";
$ENV{ORACLE_TERM}="vt100";
$ENV{ORACLE_OWNER}="oracle";
# Setup DB Connection
my $dbh = DBI->connect( 'dbi:Oracle:drsite.world',
'mintrecon',
'mintrecon',
{
RaiseError => 0,
PrintError => 0,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect();
Anyway, we've an issue whereby we have 2 servers with supposedly identical installs of both their respective Operating System, and Oracle.
Oracle Version: 8
O/S: SunOS 5.6
Basically we can connect to the first server without any problems at all, however when I try and run the same script on server number 2, with the server name changed (naturally) I get the following error message:install_driver(Oracle) failed: Can't load '/sbcimp/run/pd/perl/5.004_04/lib/site_perl/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /MINT/tools/bin/perl: fatal: libclntsh.so.1.0: open failed: No such file or directory at /sbcimp/run/pd/perl/5.004_04/lib/sun4-solaris/5.00404/DynaLoader.pm line 166.
at (eval 1) line 2
at test_conn.cgi line 18
The script is good, I know this is not the issue, I think maybe it's related to an environment variable / setup somewhere.
I checked on the Net to try and get some background info on the message and cannot really find anything specifically related.
If anyone has a thought could you kick me please.
Many Thanks...
Below is the script I'm using which works good on server 1 then dies horribly on server 2:
#! /MINT/tools/bin/perl
#use strict;
use DBI qwsql_types);
use CGI qwcgi-lib :standard);
# Setup ORACLE stuff
$ENV{ORACLE_BASE}="/oracle";
$ENV{ORACLE_HOME}="/oracle";
$ENV{LD_LIBRARY_PATH}="\$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ccs/lib";
$ENV{ORACLE_SID}="ORCL8";
$ENV{TMPDIR}="/tmp";
$ENV{PATH}="\$PATH:\$ORACLE_HOME/bin:/usr/ccs/lib";
$ENV{ORACLE_TERM}="vt100";
$ENV{ORACLE_OWNER}="oracle";
# Setup DB Connection
my $dbh = DBI->connect( 'dbi:Oracle:drsite.world',
'mintrecon',
'mintrecon',
{
RaiseError => 0,
PrintError => 0,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect();