connections differences between 8i and 9i

Chris Greaney

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

Jul 19 '05 #1

Subscribe Reply

8558

sybrandb

"Chris Greaney" <cg******@csc.com> wrote in message news:<Bg******************@news.indigo.ie>...

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

Jul 19 '05 #2

sybrandb

"Chris Greaney" <cg******@csc.com> wrote in message news:<Bg******************@news.indigo.ie>...

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

Jul 19 '05 #3

Chris Greaney

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>

<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...

"Chris Greaney" <cg******@csc.com> wrote in message

news:<Bg******************@news.indigo.ie>...

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

Jul 19 '05 #4

Similar topics

2397

Question about database connections

by: Mudge | last post by:

Hi, My hosting provider only allows me to use 50 connections to my MySQL database that my Web site will use. I don't know what this 50 connections means exactly. Does this mean that only 50...

PHP

4156

mysql_pconnect Too many connections ERROR

by: Angelos | last post by:

I get this error mysql_pconnect Too many connections ... every now and then. Does anyone knows where it comes from ? There are a lot of sites running on the server and all of them use the...

PHP

2559

closing open connections

by: C Sharp beginner | last post by:

I'm sorry about this verbose posting. This is a follow-up to my yesterday's posting. Thanks William for your reply. I understand it is a good practice to open connections as late as possible and...

C# / C Sharp

1131

DB Connections in ASP.net ?

by: Deasun | last post by:

Good evening all, Have a question about coonections. We are disscusing two ways; 1] Open the connection. Run your SQL. Close the connection. This done is a function or sub. Or 2] Open...

ASP.NET

2116

# of pooled connections seem too high

by: Bob | last post by:

We have a production web site that's data intensive (save user input to DB and query for displaying) with the ASP.NET app part on one W2K server and SQL 2000 DB on another W2K server. I have set...

ASP.NET

8412

crystal reports unreleased connections

by: Peter Proost | last post by:

Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're...

Visual Basic .NET

6051

Two mysql connections

by: elyob | last post by:

Not really tried going two ways at once, but I have an include_once connection to a mysql_database, now I need to retrieve info from a second mysql_database .. My mysql_connects are getting...

PHP

13666

mysql too many connections performance issues

by: marcfischman | last post by:

Please help. I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000 page views. The server is a RedHat Linux...

MySQL Database

3366

Problem: Database connections remain open

by: Usman Jamil | last post by:

Hi I've a class that creates a connection to a database, gets and loop on a dataset given a query and then close the connection. When I use netstat viewer to see if there is any connection open...

.NET Framework

1083

Doubt connections

by: Paulo | last post by:

Hi, if the customer choose access (mdb) I have to use OleDbConnection, OleDbCommand classes, etc... etc, but if the customer chooses Sql Server as database I have to use SqlConnection,...

ASP.NET

7224

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7120

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7323

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7380

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

4706

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3192

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3180

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

763

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

415

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General