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

From: Shakespeare <>
Date: Wed, 15 Oct 2008 21:06:09 +0200
Message-ID: <48f63f27$0$190$>

PLEASE DON'T TOP POST (which means: please reply below the original text, it's custom in this group). See my reply below. -- Shakespeare

"beta" <> schreef in bericht

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

You've got the wrong TNS_ADMIN setting, should be /u01/app/oracle/product/11.1.0/db_1/network/admin/ (According to your tnsping)
or copy your contents of TNSNAMES.ORA in /u01/app/oracle/product/11.1.0/db_1/network/admin/ to /opt./app/oracle/product/11.1.0/db_1/network/admin/

Please post the contents of SQLNET.ORA in both directories so we can check those.

Shakespeare Received on Wed Oct 15 2008 - 14:06:09 CDT

Original text of this message