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

From: <>
Date: Wed, 15 Oct 2008 21:40:45 +0200
Message-ID: <>

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

Original text of this message