Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Install / Config Issue?

Status
Not open for further replies.

AntP

Programmer
Apr 12, 2002
6
US
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 qw:)sql_types);
use CGI qw:)cgi-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();
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top