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:[email protected]] On Behalf Of Tournier, Pascal
Sent: Tuesday, March 09, 2010 10:13 AM
To: [email protected]
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"
