Pro*C-PL/SQL---Problem---More details

From: Vo Thuan <vnguyen_at_nbnet.nb.ca>
Date: Mon, 21 Jun 1999 09:20:03 -0400
Message-ID: <sPqb3.83$Jj1.14888@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.

Extract

---

    EXEC SQL WHENEVER SQLERROR DO sql_error(); ....

    EXEC SQL CONNECT :glh_username IDENTIFIED BY :glh_password;     if (g_OK)

       EXEC SQL COMMIT WORK RELEASE; int sql_error()
{

    EXEC SQL WHENEVER SQLERROR CONTINUE;     EXEC SQL ROLLBACK RELEASE;
    return(1);
}

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. Even the short extract didn't work!

Need help!

Thx Received on Mon Jun 21 1999 - 08:20:03 CDT