HELP! Oracle 7.3.2 / Livewire / ORA-12154 ERROR!!

Help! I'm running a web server (Netscape Enterprise 3.0) on a Sparc Solaris 2.5.1 machine w/ Livewire and Oracle 7.3.2.2

As far as I can tell, all of my .ora files work fine.. (I can connect via SQLPlus perfectly, and I can connect fine using Perl)

I've set up Livewire to connect to the Oracle database.. and for the most part it works.. except after a while, I start receiving the error:

(Copied from the Livewire Debug window:)

Error in database services:
[SERVERERROR] Error from
Server: Error while trying to
retrieve text for error
ORA-12154 gx

I've looked up the error message w/ oerr:

// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

I've double checked many times that TNSNAMES.ORA does exist, and that it is set properly. (After all, sqlplus runs fine, and the livewire script runs fine for about 20-30 times.) But once the error occurs, indefinite time will not bring it back. I would have to stop the database, stop the server, and restart them again to get it to work again.

I am completely baffled by this error, and don't even know where to start to fix it. ANY help would be GREATLY appreciated!!!! Thank you!!

Lyle
lyle_at_netstreams.com

-- 
_____________________________________________________________________________
Lyle Fong              NetStreams Consulting            Pager: (510) 810-1210