Pro*C -- PL/SQL - Problem

From: Vo Thuan <vnguyen_at_nbnet.nb.ca>
Date: Fri, 18 Jun 1999 09:09:12 -0400
Message-ID: <dora3.102$ih4.17101@wagner.videotron.net>

Program

---

I created a daemon which retrieve, when requested, data on DB (v7.3.4) (on another unix server). I used Pro*C(v.2.2.4) and Sql*Net (v.2.3.4) and PL/SQL (we have some packages on db server). Everything goes well when DB is up o another server.

Problem

---

When db is down...
At first requested, from daemon, we got this message...

    ORA-01034: ORACLE not available
    ORA-07429: smsgsg: shmget() failed to get segment.     Digital Unix Error: 2: No such file or direct

FINE! All other subsequent requests gave us this message...

    ORA-12154: TNS:could not resolve service name

Even if DB turn ON, we got the same message... I have to stop (kill) my daemon and restart it to do more request.

Need help!

Thx Received on Fri Jun 18 1999 - 08:09:12 CDT