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

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 15 Oct 2008 21:06:09 +0200
Message-ID: <48f63f27$0$190$e4fe514c@news.xs4all.nl>

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" <qlng2000_at_gmail.com> schreef in bericht news:d84df020-1347-4a73-bb41-73db357f41e6_at_t39g2000prh.googlegroups.com...

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?

Thanks,

On Oct 15, 11:03 am, sybra..._at_hccnet.nl wrote:
> On Wed, 15 Oct 2008 09:46:27 -0700 (PDT), beta <qlng2..._at_gmail.com>
> wrote:
>
> >Thanks guys,
>
> >I've searched forums.oracle.com 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