Pro*C ---PL/SQL --- Problem
From: Vo Thuan <vnguyen_at_nbnet.nb.ca>
Date: Fri, 18 Jun 1999 09:18:47 -0400
Message-ID: <vwra3.104$ih4.17112_at_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.
When db is down...
At first requested, from daemon, we got this message...
Date: Fri, 18 Jun 1999 09:18:47 -0400
Message-ID: <vwra3.104$ih4.17112_at_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 - 15:18:47 CEST