Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified

Calm down Sybrand! There is only one tnsname.ora on a server (It is easy to find - sorry I didn't tell you that up front!) do you have idea or NO answer or DON"T know the answer. if it is not so difficult, just show your knowledge about it. Thanks much,

On Oct 15, 12:40 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 15 Oct 2008 11:36:03 -0700 (PDT), beta <qlng2..._at_gmail.com>
> wrote:
>
>
>
> >I am a developer consultant ! it is a serious issue for me.
> >The error message (ORA-12154: TNS:could not resolve the connect
> >identifier specified) like the environment is not correct setup for a
> >web. What I've done was create a new startup web sript
>
> >*****************************
> >#/bin/sh
> >export ORACLE_BASE=/opt/app/oracle
> >export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
> >export ORACLE_SID=demo
> >export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1/lib
> >export TNS_ADMIN=/opt/app/oracle/product/11.1.0/db_1/network/admin
>
> >/usr/local/apache2/bin/apachectl start
>
> >********************************
>
> >The PHP program works fine on CLI, but it not work on a web at all. Do
> >you have any ideas, gurus?
>
> Again, No answer.
> Why is that so darn difficult? Because you are a developer?
> A simple shell find command would disclose multiple tnsnames.ora
> files.
> Or don't you know Unix at all too?
> Most developers I have dealt with are just button-pushers.
> They know 0 about programming methodologies, they just hack, and they
> know 0 about databases, and are unwilling to do any effort to learn.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 15 2008 - 15:21:34 CDT