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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 16 Oct 2008 20:31:38 +0200
Message-ID: <9ad2b$48f7888a$524b5c40$15845@cache3.tilbu1.nb.home.nl>


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
>
> *****************************
> #/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
Odd... you tnsping uses
/u01/app/oracle/product/11.1.0/db_1/network/admin/

-- 

Regards,
Frank van Bortel
Received on Thu Oct 16 2008 - 13:31:38 CDT

Original text of this message