Re: Oracle Connectivity/Windows Service
From: Sahil Malik (contactmethrumyblog_at_nospam.com)
Date: 03/07/05
- Next message: Paul via .NET 247: "Set the Identity for a colunm keeping its values"
- Previous message: Sahil Malik: "Re: Add a record directly to a table"
- In reply to: Karthikeyan Raghuraman via .NET 247: "Oracle Connectivity/Windows Service"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Mar 2005 14:19:07 -0500
Hmm .. This is a guess, but I think I'm correct on this (90% chance I'm
correct).
OracleConnection probably maintains a connection pool, just like
SqlConnection does. When you restart the database server, the connection
pool is now corrupted, and the server the service was running on has no way
of knowing that.
.NET 2.0 has introduced two new methods "ClearPool" - for one
connectionstringpool and "ClearPools" - for all pools to come over this
problem. But in 1.1 you will have to restart the machine the service is
running on.
Does restarting your Windows Service machine help? Could u do a failover
database model?
- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
"Karthikeyan Raghuraman via .NET 247" <anonymous@dotnet247.com> wrote in
message news:#q6v2h0IFHA.1360@TK2MSFTNGP10.phx.gbl...
> We have a windows service written in VB.NET.
> This service is used to trigger applications. The functionality of the
service can be briefly explained as
>
> 1. The Service accesses the Oracle database.
> 2. Checks the status of certain table entries.
> 3. Depending on the table entries processes are triggered.
> 4. The Service is a perpeterating one with a periodicity of 2 minutes.
>
> Issue:
>
> 1. The service is installed and is started. It is functioning as expected.
Now the Database is brought down (say for backup) and is brought up again.
> When the Database is brought down the service is not able to access the
database which is expected.
> Now when the database is brought up the service still persists with the
error.
>
> ERROR from the service:
> --------------------------------
> ERROR MESSAGE : ORA-01034: ORACLE not available
>
> ORA-27101: shared memory realm does not exist
>
> SVR4 Error: 2: No such file or directory
> --------------------------------
> A manual restart of the service is required to make the service functional
again.
>
> Software Details
> -------
> Oracle Version : Oracle 9i Enterprise Edition,
> Release 9.2.0.4.0
> NET Framework: Microsoft .NET 2003, v1.1.4322
> ------
>
> The service works well on Windows 2003 server but this issue comes in
Windows 2000 server SP4.
>
> Any inputs on this will be of help
>
> --------------------------------
> From: Karthikeyan Raghuraman
>
> -----------------------
> Posted by a user from .NET 247 (http://www.dotnet247.com/)
>
> <Id>o7P+hRe3/0WrQ0UqB79M1A==</Id>
- Next message: Paul via .NET 247: "Set the Identity for a colunm keeping its values"
- Previous message: Sahil Malik: "Re: Add a record directly to a table"
- In reply to: Karthikeyan Raghuraman via .NET 247: "Oracle Connectivity/Windows Service"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
