RE: oracle win2k ORA-1222 problems
- From: Ron.Reidy@xxxxxxxxxxxxxxxxxx (Ron Reidy)
- Date: Thu, 16 Jun 2005 09:15:48 -0600
AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com.
Jeff Urlwin just posted today about using the DBD::Oracle build for AS 5.8.4.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Roy Niemann [mailto:rniemann@xxxxxxxxxxxx]
Sent: Thursday, June 16, 2005 8:50 AM
To: Hope Peter; dbi-users@xxxxxxxx
Subject: RE: oracle win2k ORA-1222 problems
Aloha (I'm jealous of course if you're in Hawaii),
Activestate PERL does not support ORACLE in release 5.8 as far
as I can tell. I am having a real problem with that! Go to their web
site and they'll list the modules supported / failed during their
installation. Oracle is listed as "failed" if I recall correctly. I may
be wrong but I have yet to figure out how to get PERL/Oracle to get on
speaking terms. It's kinda like my ex-wife.
Regards from the East Coast,
Roy
-----Original Message-----
From: Hope Peter [mailto:hope_peter@xxxxxxx]
Sent: Wednesday, June 15, 2005 10:39 PM
To: dbi-users@xxxxxxxx
Subject: dbi:oracle win2k ORA-1222 problems
Aloha.
Have just inherited a failed web app. It originally was running on
unix. Then got ported to NT. Then ported to Win2k. Client network
admins recently updated the server and the web application will no
longer connect to the database.
The web server is a WIN2k w/sp4 box running IIS5, Oracle Client 9.2,
ActiveState Perl 5.8.6.811, DBI 1.43, DBD-Oracle 1.16, Oraperl 1.44.
The database is Oracle 7 running on a totally different machine.
The scripts running in the web browser come back with a ORA-1222 invalid
protocol error.
But if I run them from the command prompt, they execute fine.
I found a bit of code that would check all available DBI drivers and
their data sources.
#!/usr/bin/perl -w
use DBI;
my @drivers = DBI->available_drivers();
die "No drivers found!\n" unless @drivers; # should never happen
foreach my $driver ( @drivers ) {
print "Driver: $driver\n";
my @dataSources = DBI->data_sources( $driver );
foreach my $dataSource ( @dataSources ) {
print "\tData Source is $dataSource\n";
}
print "\n";
}exit;
When this was run from the command prompt I got
Driver: Oracle
Data Source is DBI:Oracle:Space
Data Source is DBI:Oracle:GSS
When run from the web page all that comes up is
Driver: Oracle
I can not figure out why the web version isnt working correctly.
Pete
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
.
- Prev by Date: Re: Oracle schema comparison
- Next by Date: RE: Oracle schema comparison
- Previous by thread: RE: oracle win2k ORA-1222 problems
- Next by thread: RE: oracle win2k ORA-1222 problems
- Index(es):
Relevant Pages
|
