Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified
Date: Wed, 15 Oct 2008 13:31:05 -0700 (PDT)
Message-ID: <0abac823-900f-47d1-8a2b-7495b9b97c23@b31g2000prf.googlegroups.com>
Sorry Shakespear!
The /opt is a mistake, here is my new environment setup - I have only one tnsname.ora
#/bin/sh
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 export ORACLE_SID=demo
export LD_LIBRARY_PATH=/u01/app/oracle/product/11.1.0/db_1/lib export TNS_ADMIN=/u01/app/oracle/product/11.1.0/db_1/network/admin
/usr/local/apache2/bin/apachectl start
*****************EOF*************88
###sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/
11.1.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
##### listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/
11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = cuenot.mendelbio.com)(PORT =1521))
)
)
##### tnsname.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/
11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEMO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cuenot.xxx.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = demo)
)
)
MENM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = paul.xxx.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = menm)
)
)
On Oct 15, 12:06�pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> 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" <qlng2..._at_gmail.com> schreef in berichtnews: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. > > ShakespeareReceived on Wed Oct 15 2008 - 15:31:05 CDT