11gpath失败 oracle_为什么Perl的DBI抱怨“失败：ERROR OCIEnvNlsCreate”？当我尝试连接到Oracle 11g时？...

I am getting the following error connecting to an Oracle 11g database using a simple Perl script:

failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at

The script is as follows:

#!/usr/local/bin/perl

use strict;

use DBI;

if ($#ARGV < 3) {

print "Usage: perl testDbAccess.pl dataBaseUser dataBasePassword SID dataBasePort\n";

exit 0;

}

my ($user, $pwd, $sid, $port) = @ARGV;

my $host = `hostname`;

my $dbh;

my $sth;

my $dbname = "dbi:Oracle:HOST=$host;SID=$sid;PORT=$port";

openDbConnection();

closeDbConnection();

sub openDbConnection() {

$dbh = DBI->connect ($dbname, $user ,$pwd , { RaiseError => 1}) || die "Database connection not made: $DBI::errstr";

}

sub closeDbConnection() {

#$sth->finish();

$dbh->disconnect();

}

Anyone seen this problem before?

解决方案

Check your Oracle client configuration (including, as the message says, ORACLE_HOME), check file permissions, etc. It's unlikely that DBI per se has anything to do with the problem, and I know for a fact that DBD::Oracle is compatible with the 11g libraries (at least the 11g InstantClient).