Re: Oracle Connection Pool Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nicholas Paldino [.NET/C# MVP] (mvp_at_spam.guard.caspershouse.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 11:11:22 -0400

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]
               - mvp@spam.guard.caspershouse.com
"Alex Chan" <GalexyChan@hotmail.com> wrote in message 
news:OziacWYsEHA.2196@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
>
>

Relevant Pages

  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... I left the connection sit idle and checked back in an hour. ... server and browsed around for a few minutes. ... it would seem that there is still some issue with the V6 RDP ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: Backup Question
    ... If it is possible to backup the ... the net connection using a DSL Router ... but by error I altered the connection settings to include DHCP ... connect using a static IP & using the DNS Servers that the ISP ...
    (alt.os.linux.suse)
  • Re: whats the best virus protection
    ... > not your system and your downloads are malware free before backup. ... once you connect to storage device while the PC is Internet ... Anyways it only takes a few moments to unconnect the Inet connection ...
    (alt.comp.anti-virus)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... Well, it turns out the RDP connection dropping issue won't go away, ... level to the server in the office may have an affect on the issue. ... I just remembered I also re-installed RDP Client V6 last night as ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: Access DB question
    ... We received an email, to a valid user, from a domain say (example.net ... Was it supposed to be blocked based on envelope sender or sending host? ... So in this case I don't think connection blocking is the issue. ... Since it came through our backup MX connection blocking doesn't ...
    (comp.mail.sendmail)