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

From: Shakespeare <shakespeare_at_mi5.uk.com>
Date: Thu, 16 Oct 2008 11:13:28 +0200
Message-ID: <48f705b8$0$184$e4fe514c@news.xs4all.nl>

PLEASE DON'T TOP POST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Put your response below

"beta" <qlng2000_at_gmail.com> schreef in bericht news:0abac823-900f-47d1-8a2b-7495b9b97c23_at_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.
>
> Shakespeare

Since you seem to make more typos:
1) it should be tnsnames.ora, not tnsname.ora (check this) 2) don't retype output, but copy/paste it if your typing accuracy is like this.
3) Your output of TNSPING says your tnsnames is not where you expect it to be.

AND PLEASE STOP TOP POSTING, POSTS GET A BIT CONFUSING THIS WAY ShakespearE Received on Thu Oct 16 2008 - 04:13:28 CDT