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"
