Oracle Connectivity/Windows Service

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Karthikeyan Raghuraman via .NET 247 (anonymous_at_dotnet247.com)
Date: 03/07/05 

Date: Mon, 07 Mar 2005 11:04:17 -0800

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>

Relevant Pages

  • Re: GLOBAL_NAME vs. SERVICE_NAMES
    ... In an Oracle 10g database, would someone mind putting in English the ... Imagine a large database with Accounts Payable, Accounts Receivable, ... Oracle replication functionality doesn't actually function unless ...
    (comp.databases.oracle.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)
  • Re: I want to add to myknowledge
    ... 7, Oracle 6, Sybase, SQL Server ... Oracle Database Administrator ... Trained installation and support personnel in basic ... Senior Oracle Database Administrator ...
    (comp.databases.oracle.server)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.programmer)