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

From: beta <>
Date: Wed, 15 Oct 2008 11:36:03 -0700 (PDT)
Message-ID: <>

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?


On Oct 15, 11:03 am, wrote:
> On Wed, 15 Oct 2008 09:46:27 -0700 (PDT), beta <>
> wrote:
> >Thanks guys,
> >I've searched and all other places, but still no
> >luck. The ORA-12154 error message is very general. I am very
> >appreciated if you have any clues.
> You didn't search those places. You would have found a solution.
> I asked you two questions and you didn't respond to them.
> I guess you can't be bothered to do any troubleshooting.
> If that's correct, why don't you hire a consultant to do your job, sit
> back at your desk, with your feet on it, and beat the consultant with
> a whip, when he is not productive enough?
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 15 2008 - 13:36:03 CDT

Original text of this message