Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified
Date: Wed, 15 Oct 2008 21:06:09 +0200
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
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
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, sybra..._at_hccnet.nl wrote:
> On Wed, 15 Oct 2008 09:46:27 -0700 (PDT), beta <qlng2..._at_gmail.com>
> >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
(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