473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Oracle Connection Pool Problem

Hi All,

I know this might not be an appropriate newsgroup for this question. I
have tried to search in OTN but seems no good solution exists. Just see any
developers face similar problem before

I have used Oracle Data Provider.NET (ODP) and built a C# window
service. I have used the oracle connection pooling as default. However, as
my oracle database would be down for backup every night. Every day, i need
to restart my C# service in order to avoid the TNS Packet Writer failure
error. I know this is becoz the previous connections pooled are no longer
valid due to the shutdown of Oracle database.

ODP suggest using an option in the connection string "valid
connection=true" to avoid this problem, however, performance penalty will be
paid for the round trip checking of connection, that indeed violates the
objective of using connection pool i think.

Any developers encountered this problem? any standard way to tackle
this?

Regards,

Alex
Nov 16 '05 #1
3 7591
Hi, Alex.

I think that you can find a solution here:

http://support.microsoft.com/default...b;en-us;830173

HTH

Alberto Salvati
Nov 16 '05 #2
Dear Alberto,

Thx for your information. But that is the fix for Microsoft Data
Adapeter for Oracle. And the one i am using is coming from Oralce. More
precisely is Oracle Data Adapter (ODP .NET)

Regards,

Alex
"Alberto Salvati" <zz*@supereva.it> wrote in message
news:ck***********@newsreader1.mclink.it...
Hi, Alex.

I think that you can find a solution here:

http://support.microsoft.com/default...b;en-us;830173

HTH

Alberto Salvati

Nov 16 '05 #3
Alex,

Instead of trying to compensate for it in your code, can you make it so
that the event that triggers the backup also shuts down your service while
the DB is offline, and then restarts your service when it comes back online?
This would be a better solution IMO (it decouples the maintinence of the DB
from your code, and makes your code cleaner).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Alex Chan" <Ga********@hotmail.com> wrote in message
news:Oz**************@TK2MSFTNGP14.phx.gbl...
Hi All,

I know this might not be an appropriate newsgroup for this question. I
have tried to search in OTN but seems no good solution exists. Just see
any
developers face similar problem before

I have used Oracle Data Provider.NET (ODP) and built a C# window
service. I have used the oracle connection pooling as default. However, as
my oracle database would be down for backup every night. Every day, i need
to restart my C# service in order to avoid the TNS Packet Writer failure
error. I know this is becoz the previous connections pooled are no longer
valid due to the shutdown of Oracle database.

ODP suggest using an option in the connection string "valid
connection=true" to avoid this problem, however, performance penalty will
be
paid for the round trip checking of connection, that indeed violates the
objective of using connection pool i think.

Any developers encountered this problem? any standard way to tackle
this?

Regards,

Alex

Nov 16 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Prashanth | last post by:
Hi, We are facing some issues in COM+ deployment. We get system error "Unable to enlist in a distributed transaction" . It has a very inconsistant behaviour. On refreshing the screens couple of...
0
by: JWM | last post by:
I am trying to implement Oracle connection pooling for the following code, which was written by someone else. Here is my main question -- this java file creates code that is executed every hour,...
1
by: Eirik Tryggeseth | last post by:
During deployment of an application using distributed transactions managed under COM+ on an Oracle 9i RAC database, we encounter situations where the load balancing mechanisms in the RAC result in...
0
by: ʹÃûÑï | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access...
2
by: Steve Foo | last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it. I have contacted Singapore Microsoft support regarding the problem...
0
by: Nathan | last post by:
Hi We are having an application that uses ASP.Net / Oracle DB 9.2.0.7 / ODP for .net with connection pooling on We are using ODP .Net 9.2.0.4.01. We have set the parameters as below in the...
1
by: ori | last post by:
Hi, I have an ASP.Net application hosted in a windows server 2003 (IIS 6.0). The application uses a Oracle Database to retrieve some data through an Oledb connection. I've set the IIS...
20
by: fniles | last post by:
I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...
6
by: S_K | last post by:
Hi all! I'm writing an ASP.NET web application that uses an Oracle database. I OPEN the Oracle connection by using the following code: if (this.ConnectionString != "") { this.Connection =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.