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

From: beta <qlng2000_at_gmail.com>
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.
>
> Shakespeare

Received on Wed Oct 15 2008 - 15:31:05 CDT