dbTalk Databases Forums  

connections differences between 8i and 9i

comp.databases.oracle comp.databases.oracle


Discuss connections differences between 8i and 9i in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Greaney
 
Posts: n/a

Default connections differences between 8i and 9i - 08-18-2004 , 07:52 AM






Hello all, I have a old application that works with Oracle 8i but when I
use the same application on Oracle 9i I get an error when I try to connect -
[Error while trying to retrieve text for error ORA-03113]. This
application is on a HP Unix box and is connecting to Windows NT Oracle
database.

There is no difference in the way the application attempts to connect. Its
only when I point this app to Oracle 9i does this become an error.

Thanks
Chris Greaney



Reply With Quote
  #2  
Old   
sybrandb@yahoo.com
 
Posts: n/a

Default Re: connections differences between 8i and 9i - 08-19-2004 , 02:55 AM






"Chris Greaney" <cgreaney (AT) csc (DOT) com> wrote

Quote:
Hello all, I have a old application that works with Oracle 8i but when I
use the same application on Oracle 9i I get an error when I try to connect -
[Error while trying to retrieve text for error ORA-03113]. This
application is on a HP Unix box and is connecting to Windows NT Oracle
database.

There is no difference in the way the application attempts to connect. Its
only when I point this app to Oracle 9i does this become an error.

Thanks
Chris Greaney
You'll need to find out what version of sqlnet/net8/net you are using.
Likely you don't use 8i drivers. Sqlnet 2.3 against 9i databases
doesn't work and is not supported. I'm not sure about 8.0

Hth

Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #3  
Old   
sybrandb@yahoo.com
 
Posts: n/a

Default Re: connections differences between 8i and 9i - 08-19-2004 , 03:18 AM



"Chris Greaney" <cgreaney (AT) csc (DOT) com> wrote

Quote:
Hello all, I have a old application that works with Oracle 8i but when I
use the same application on Oracle 9i I get an error when I try to connect -
[Error while trying to retrieve text for error ORA-03113]. This
application is on a HP Unix box and is connecting to Windows NT Oracle
database.

There is no difference in the way the application attempts to connect. Its
only when I point this app to Oracle 9i does this become an error.

Thanks
Chris Greaney
You'll need to find out what version of sqlnet/net8/net you are using.
Likely you don't use 8i drivers. Sqlnet 2.3 against 9i databases
doesn't work and is not supported. I'm not sure about 8.0

Hth

Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #4  
Old   
Chris Greaney
 
Posts: n/a

Default Re: connections differences between 8i and 9i - 08-19-2004 , 06:38 AM



I'm able to connect using SQL plus as follows:
SQL*Plus: Release 8.1.6.0.0 - Production on Thu Aug 19 11:50:57 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>

<sybrandb (AT) yahoo (DOT) com> wrote

Quote:
"Chris Greaney" <cgreaney (AT) csc (DOT) com> wrote

Hello all, I have a old application that works with Oracle 8i but when
I
use the same application on Oracle 9i I get an error when I try to
connect -
[Error while trying to retrieve text for error ORA-03113]. This
application is on a HP Unix box and is connecting to Windows NT Oracle
database.

There is no difference in the way the application attempts to connect.
Its
only when I point this app to Oracle 9i does this become an error.

Thanks
Chris Greaney

You'll need to find out what version of sqlnet/net8/net you are using.
Likely you don't use 8i drivers. Sqlnet 2.3 against 9i databases
doesn't work and is not supported. I'm not sure about 8.0

Hth

Sybrand Bakker
Senior Oracle DBA



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.