It is a known bug in the installer. The recommendation is for installing that you have your TWO_TASK and your SID/Service Name the same while installing. Once you have installed you can edit the ar.conf and eliminate the second tnsnames.ora entry.
My guess is that somewhere in the installer someone accidentally reversed the two. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Monday, April 23, 2012 7:16 AM To: [email protected] Subject: Stack Installer Oracle Import ITSM 7.6.04 sp2 / Oracle 11g / Redhat Having an issue installing using the stack installer. Using the following tnsname entry: p123 = (DESCRIPTION = (LOAD_BALANCE=OFF) (ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = remedy_prod_app) ) ) Before running the installer tested connecting to the database using sqlplus. I could also tnsping "p123". During the installation I use "p123" as the Oracle Connect Identifier and "remedy_prod_app" as the Oracle Service Name. The installer validates everything and there appears to be no issues until it gets to the point where it starts the Oracle import. The import fails with: IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully After a few attempts using different configurations I captured the "imp" process: /usr/oracle/product/11.2.0/client/bin/imp file= /usr/ar/bmc/Utilities/arsystem.dmp buffer= 10240000 fromuser=ARADMIN touser=aradmin feedback=1000000 log=/tmp/ARSystemDBImport.log My final attempt was to add a second tnsnames entry using the service name "remedy_prod_app" as the entry point: remedy_prod_app = (DESCRIPTION = (LOAD_BALANCE=OFF) (ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = remedy_prod_app) ) ) The installer worked. The installed ar.conf file only references the "p123" so I removed the second tnsnames entry from the tnsnames file and ARS runs fine. Has anyone seen this same issue where two tnsnames entries are required for installation? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
