Re: dbi:oracle win2k ORA-1222 problems
- From: jkstill@xxxxxxxxxx (Jared Still)
- Date: Thu, 16 Jun 2005 21:17:46 -0700
ORA-1222 is "MAXINSTANCES of %s requires MAXLOGFILES be at least %s,
not %s" which is incurred during database or controlfile creation.
Maybe a different error message you are seeing?
IAC, an Oracle 9.2 client cannot connect to an Oracle 7 database, so
maybe an upgrade of the database is in order, or a downgrade of the
client you are using to 8.1
HTH
Jared
On Wed, 2005-06-15 at 19:38, Hope Peter wrote:
> 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
>
.
- References:
- dbi:oracle win2k ORA-1222 problems
- From: Hope Peter
- dbi:oracle win2k ORA-1222 problems
- Prev by Date: Need DBD/DBI install Help Pls.
- Next by Date: Re: DBI / DBD / MySQL installation problem
- Previous by thread: dbi:oracle win2k ORA-1222 problems
- Next by thread: Best practices for SQL error handling?
- Index(es):
Relevant Pages
|
