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
>