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

[Grooms, Frederick W]

The way I always tell people to set up for Oracle.

Say this is your TNSNAMES.ORA file where your ARS server is installed and your 
ARS server uses MYENTRY1.
    MYENTRY1 =
      (description =
        (address_list =
          (address = (protocol = tcp)(host = MYHOST1)(port = 1521))
        )
        (connect_data =
          (sid = MYSID1)
        )
      )

    MYENTRY2 =
      (description =
        (address_list =
          (address = (protocol = tcp)(host = MYHOST2)(port = 1521))
        )
        (connect_data =
          (service_name = MYSID2)
        )
      )

In the profile of the user that ARS runs under I tell people to set the 
following environment variables:
    set TWO_TASK=MYENTRY1
    set ORACLE_SID=MYSID1
    set TNS_ADMIN={location of tnsnames.ora file}
    export TWO_TASK
    export ORACLE_SID
    export TNS_ADMIN

With these variables set you should be able to connect with sqlplus like:   
sqlplus scott/tiger

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Tournier, Pascal
Sent: Tuesday, March 09, 2010 10:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: ORA-12154: TNS:could not resolve the connect identifier specified

**
Hi,

I'm trying to install ARS 7.5 (patch 04) on our new LINUX server. I'm running 
Oracle 11 and I'm using the installation within a upgrade mode as we have 
imported our DB data (oracle 9) into our new DB (Oracle 11). Following the BMC 
support matrix, we are using the oracle client 10...

The problem is that I get the following error during the installation :
ORA-12154: TNS:could not resolve the connect identifier specified
 Or depending on the setting I provide I get
ORA-12514: TNS:listener does not currently know of service requested in connect 
descriptor

I have checked the tnsname.ora file as well as the listener.ora and everything 
seems to work fine... the listener is started, I can do a TNS ping, I can 
connect with SQLPLUS,...

Also during the installation he ask me for the "Oracle Connection Identifier" 
and don't really which information I should provide at this point.

Any idea ?

Thanks
Regards




_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"