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

On Wed, 15 Oct 2008 11:36:03 -0700 (PDT), beta <qlng2000_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