Re: tnsnames.ora, OCI and ORA-12514

In article <IeZq5.672$V91.26857_at_weber.videotron.net>,   "news.cactuscom.com" <mmelanco_at_sfi-software.com> wrote:
> Is this on NT ? If so is the path to the home directory set in the
 user
> path or in the system path, in your case it has to be in system
path...

No, it's on Linux - sorry, I thought I'd mentioned that.

Not sure what you mean here - are you referring to the ORACLE_HOME environment variable?

Thanks,

Bob Vastine-Parker

> MarcM
> <vpdev_at_my-deja.com> wrote in message news:8ofpk0$fk8
 $1_at_nnrp1.deja.com...
> > My apologies if this has been covered before - I searched the
 archives
> > and couldn't find anything.
> >
> > I have been writing a daemon program that uses the Oracle 8.1.5 OCI
> > functions to process some queries against a database on a different
> > machine, connected via TCP/IP.
> >
> > From the command line, I can connect to that database with no
 problem
> > using sql*plus, and a tnsping works as well. If I start up the
 program
> > from the command line in the directory with the tnsnames.ora file,
 it
> > will work great.
> >
> > When I start it up as a daemon, however, or in any directory that is
> > not where the tnsnames.ora file is, I get the dreaded ORA-12514
 error
> > message.
> >
> > I have checked all the appropriate environment variables, but for
> > security reasons this daemon must wipe it's environment and start
> > clean. I thought this might be the problem, so I specifically
 imported
> > TNS_ADMIN and ORACLE_HOME (among other variables) on program init,
 but
> > still no joy.
> >
> > Has anyone run into this before? What am I missing here? I know I'll
> > probably kick myself once I finally do find the answer, but any
 help at
> > all would be greatly appreciated.
> >
> > Thanks in advance,
> >
> > Bob Vastine-Parker
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 09:00:26 CEST