DBI oracle connection ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)
- From: "learner" <tzhai2002@xxxxxxxxx>
- Date: 28 Jun 2005 14:24:34 -0700
Hi,
I am using using a perl script to connect to my oracle db with DBI.
It worked previously, then our DB admin updated oracle in some way, it
stopped working, anyway, it gave this msg on trace:
DBI 1.47-ithread default trace level set to 0x0/2 (pid 3237)
-> DBI->connect(dbi:Oracle:ABE, etop, ****, HASH(0x13b36c))
-> DBI->install_driver(Oracle) for solaris perl=5.008005 pid=3237
ruid=144203 euid=144203
install_driver: DBD::Oracle version 1.16 loaded from
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris-thread-multi/DBD/Oracle.pm
-> STORE in DBD::_::common for DBD::Oracle::dr
(DBI::dr=HASH(0x1ca75c)~0x3065dc 'ShowErrorStatement' 1) thr#229a0
<- STORE= 1 at Oracle.pm line 61
<- install_driver= DBI::dr=HASH(0x1ca75c)
-> connect for DBD::Oracle::dr (DBI::dr=HASH(0x1ca75c)~0x3065dc 'ABE'
'etop' **** HASH(0x3092ac)) thr#229a0
-> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x3092a0)~INNER) thr#229a0
DESTROY for DBI::db=HASH(0x3092a0) ignored - handle not
initialised
ERROR: '-1' 'ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS
settings etc.)' (err#1)
<- DESTROY= undef at DBI.pm line 596
!! ERROR: '-1' 'ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS
settings etc.)' (err#0)
<- connect= undef at DBI.pm line 596
-> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::Oracle::dr::errstr
<- $DBI::errstr= 'ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS
settings etc.)'
DBI connect('ABE','etop',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.)
-- DBI::END
-> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x1ca75c)~0x3065dc)
thr#229a0
<- disconnect_all= (not implemented) at DBI.pm line 675
! -> DESTROY in DBD::_::common for DBD::Oracle::dr
(DBI::dr=HASH(0x3065dc)~INNER) thr#229a0
! <- DESTROY= undef during global destruction
my perl connection:
use DBI;
$ENV{'ORACLE_HOME'}="/usr/abeora";
$ENV{'ORACLE_SID'}="ABE";
unlink 'dbitrace.log' if -e 'dbitrace.log';
### Set trace output to a file at level 2 and prepare()
DBI->trace( 2, 'dbitrace.log' );
$dbh = DBI -> connect ('dbi:Oracle:ABE', $username, $passw,
{ RaiseError => 1,
AutoCommit => 0}
) || die "Database connection not made:
$DBI::errstr";
$sth = $dbh->prepare($_[0]);
$sth->execute();
ENV is also set in .cshrc in the shell. and I 've tried with without it
in the script etc, keep giving the same error.
So should I wait for my DB admin return from vacation to bug him or is
there something I missed obviously?
Thanks,
.
- Prev by Date: DBI.ppd
- Next by Date: RE: DBI.ppd
- Previous by thread: DBI.ppd
- Next by thread: I have problems with installing DBI-1.48 on Freebsd 5.4
- Index(es):
Relevant Pages
|
|
